creating dataset name using variable values

[rohithverma]

consider an example of sashelp.class. Using this data set i want each record in this dataset is to be appeared in different datasets and the names of these data sets should be appeared as similar to the variable  "name"  values  in the sashelp.class in macros 

[Astounding · Accepted solution]

Do you have a specific question to ask?

Do you want somebody to just solve the problem for  you?

Must a solution use macro language?

Do you want somebody to outline a series of steps you should take?

Do you want somebody to suggest a first step you could take to get started?

I will go with the last approach, how can you get started.  Use PROC SQL to create a macro variable holding a long list of all the NAME values found in sashelp.class.

[Ksharp]

Is that necessary to make a macro ?

data have;
 set sashelp.class;
run;

data _null_;
if _n_=1 then do;
if 0 then set have;
declare hash h(dataset:'have(obs=0)');
h.definekey('name');
h.definedata(all:'y');
h.definedone();
end;
set have;
h.add();
h.output(dataset:name);
h.clear();
run;

[rohithverma]

Thanqq so much

[rohithverma]

I have tried it but I am getting either first OBS into all datasets or last observation into all datasets .So I am unable to do that one