Tag: SAS to Oracle/EXCEL

How to preserve leading zeros when export to csv file

by  •  • Comments Off on 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 →

Create Oracle Tables

by  •  • Comments Off on Create Oracle Tables

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

Read more →