topic Re: SAS Scenario in SAS Programming

SAS Scenario

Son_Of_Krypton — Tue, 21 Aug 2018 07:23:13 GMT

i have a below table

Data Have;
Input id name $ city $;
cards;
100 Thomas Paris
101 Chris London
102 Martin US
103 John Hongkong
;
run;

for above table i want each city's own table including its records

like a different table named paris which includes only paris data

Re: SAS Scenario

Kurt_Bremser — Tue, 21 Aug 2018 07:41:56 GMT

The usual question: What for?

In most cases, splitting a dataset is not necessary, as you can use by-group processing to perform analysis for each group (in your case "city") separately in one step.

Splitting more than doubles the required disk space and adds additional steps to be performed, resulting in less efficient code.

Re: SAS Scenario

RW9 — Tue, 21 Aug 2018 07:50:05 GMT

AS said above, use by group processing, for example:

proc print data=have;
  by city;
run;

Its far more efficient, in processing, coding, and storage needs.

Re: SAS Scenario

Son_Of_Krypton — Tue, 21 Aug 2018 09:31:10 GMT

okay but i don't want to print it i want to create a dataset for each city by its name

Re: SAS Scenario

RW9 — Tue, 21 Aug 2018 09:34:04 GMT

Thats an example, by group works in all scenarios. If you can be more specific then can show.

Re: SAS Scenario

Son_Of_Krypton — Tue, 21 Aug 2018 09:37:52 GMT

looking for solution if you have any solution in your mind please share

Re: SAS Scenario

Son_Of_Krypton — Tue, 21 Aug 2018 09:40:37 GMT

asume this question as scenario not as a practical work

Re: SAS Scenario

RW9 — Tue, 21 Aug 2018 09:45:56 GMT

data have;
  input id name $ city $;
cards;
100 Thomas Paris
101 Chris London
102 Martin US
103 John Hongkong
;
run;

proc sort data=have out=loop nodupkey;
  by city;
run;

data _null_;
  set loop;
  call execute(cat('data ',tranwrd(strip(city)," ","_"),'; set have; where city="',strip(city),'"; run;'));
run;