12-16-2016 05:45 AM
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.
12-16-2016 06:11 AM
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.
Need further help from the community? Please ask a new question.