no observations copied

[shynu]

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

[RW9]

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.  

[Reeza]

Proc SQL;

create table b1

 like a1;

quit;

[RW9]

Nice, I always forget the like command.

[Shmuel · Accepted solution]

and one more:

data b1; set a1(obs=0); run;