topic Re: Is it possible to get code that will replicate an existing table? in SAS Procedures

Is it possible to get code that will replicate an existing table?

UniversitySas — Sat, 14 Mar 2020 13:25:38 GMT

I was wondering if SAS has some sort of way to automatically generate a code like this:

data temp;
infile DATALINES dsd missover;
input ID Miles Windows Occupants;
CARDS;01, 100, 2, 5
02, 200, 4, 5
03, 300, 2, .
04, ., 6, 2
05, 500, ., 8
06, 600, ., .
07, 700, 4, 5
08, 800, 4, .
02, 4, 1.7, 3
02, 5, 5.1, 4;
run;

to replicate an existing table, in the event we want to share our code, without providing the original data set, so that

someone can just highlight our code and run it. Is it possible? I only have about 100 rows, which isn't much but it would be an absolute

pain to type out.

Re: Is it possible to get code that will replicate an existing table?

Kurt_Bremser — Sat, 14 Mar 2020 13:31:09 GMT

See my footnotes, there's a link to a macro that does that.

Re: Is it possible to get code that will replicate an existing table?

PeterClemmensen — Sat, 14 Mar 2020 13:45:16 GMT

Check this out

https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

Re: Is it possible to get code that will replicate an existing table?

UniversitySas — Sat, 14 Mar 2020 14:03:05 GMT

Thank you, it worked like a charm!