topic Re: Copy Structure of Table without copying Data in SAS Programming

Copy Structure of Table without copying Data

dassuz — Tue, 04 Jul 2017 13:56:26 GMT

Hi i have a table with about 20 columns and millions of lines of data, I want to make a copy of the structure of the table without copying any data. What would be the best way to do this?

Re: Copy Structure of Table without copying Data

Shmuel — Tue, 04 Jul 2017 13:59:15 GMT

data want;

set have(obs=0);

run;

Re: Copy Structure of Table without copying Data

Ksharp — Tue, 04 Jul 2017 14:09:44 GMT

1) proc sql; create table have like sashelp.class; quit; 2) data have; set sashelp.class; stop; run;