Posts Tagged ‘ SAS to Oracle/EXCEL ’

How to preserve leading zeros when export to csv file

April 1, 2011
By
How to preserve leading zeros when export to csv file

data one;input id $;/* create formatting to preserve leading zeros in excel */cid&nbsp =&nbsp '&nbsp=&nbsp"&nbsp'&nbsp ||&nbsp id&nbsp ||&nbsp '&nbsp"&nbsp';cards;00123123980123400034;run;data one (drop=id);&nbsp &nbsp &nbsp set one;run;ods listing clo...
Read more »

Tags: ,
Posted in SAS | Comments Off on How to preserve leading zeros when export to csv file

Create Oracle Tables

January 4, 2011
By
Create Oracle Tables

libname oradb Oracle User=orauser Password=xxxxxxx Path="@orapth"; proc sql;      create table oradb.dsn as      select * from temp;quit;run;proc append base=oradb.dsn data=temp1 force;run;
Read more »

Tags: ,
Posted in SAS | Comments Off on Create Oracle Tables

Variables names to avoid when create Oracle tables from SAS

November 23, 2010
By
Variables names to avoid when create Oracle tables from SAS

Oracle Reserved Words
Read more »

Tags:
Posted in SAS | Comments Off on Variables names to avoid when create Oracle tables from SAS

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors





Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.