Friday, 7 October 2011

Create Null dataset


Dataset existed with variables without observations.

/*creating nulldataset*/
data demo;
length sno $ 5 gno $ 4 pid 4 age 3;
delete;
run;

/*extract*/
proc import datafile='<file path>\data1.xls'
out=demo1 dbms=excel replace;
sheet='sheet3$';
run;

/ *create null data set*/
 data dm;
 length studyid $ 8 sno $ 5 gno $ 4 pid 4 age 3 gender 3 ;
 delete;
 run;
 proc append base=dm data=demo1 force;
 run;

No comments:

Post a Comment