Posts Tagged ‘ SAS to Oracle/EXCEL ’

How to preserve leading zeros when export to csv file

April 1, 2011
By

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

Create Oracle Tables

January 4, 2011
By

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

Variables names to avoid when create Oracle tables from SAS

November 23, 2010
By

Oracle Reserved Words
Read more »

Tags:
Posted in SAS | Comments Off

Proc-x is looking for 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

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.

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.