sas Proc SQL Create an empty dataset based on an existing dataset


Example

Method 1:

 proc sql;
    create table foo like sashelp.class;
    quit;

Method 2:

proc sql;
create table bar as 
    select * from sashelp.class (obs=0);
quit;

Method 1 should be the preferred option