SAS Scenario

[Son_Of_Krypton]

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

[Kurt_Bremser]

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.

[Son_Of_Krypton]

asume this question as scenario not as a practical work

[RW9]

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.

[Son_Of_Krypton]

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

[RW9]

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

[Son_Of_Krypton]

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

[RW9 · Accepted solution]

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;