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