Hpw do I do this??
Please someone help me
Table A1 : Conisit of 10 columns and there are 100 records
create a TABLE B1 from A1 where B1 should contain only the structure of A1 and no records should be copied.
Thank you
Well, Q1 - why, not really much point creating an emtpy copy of a dataset. But anyways, two options:
proc sql; create table WANT as select * from HAVE where 1=0; quit; data want; set have; if _n_ < 0 then output; run;
You could also generate it from metadata, but thats probably more code than the above.
Proc SQL;
create table b1
like a1;
quit;
Nice, I always forget the like command.
and one more:
data b1; set a1(obs=0); run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.