topic no observations copied in SAS Programming

no observations copied

shynu — Fri, 16 Dec 2016 10:45:12 GMT

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

Re: no observations copied

RW9 — Fri, 16 Dec 2016 11:11:45 GMT

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.

Re: no observations copied

Reeza — Fri, 16 Dec 2016 11:14:55 GMT

Proc SQL;

create table b1

like a1;

quit;

Re: no observations copied

RW9 — Fri, 16 Dec 2016 11:20:49 GMT

Nice, I always forget the like command.

Re: no observations copied

Shmuel — Fri, 16 Dec 2016 11:23:56 GMT

and one more:

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