topic Re: creating dataset name using variable values in SAS Procedures

creating dataset name using variable values

rohithverma — Sat, 03 Feb 2018 14:35:25 GMT

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

Re: creating dataset name using variable values

Astounding — Sat, 03 Feb 2018 15:35:12 GMT

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.

Re: creating dataset name using variable values

Ksharp — Sun, 04 Feb 2018 10:44:28 GMT

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;

Re: creating dataset name using variable values

rohithverma — Mon, 05 Feb 2018 01:47:16 GMT

Thanqq so much

Re: creating dataset name using variable values

rohithverma — Mon, 05 Feb 2018 01:48:55 GMT

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