Help using Base SAS procedures

creating dataset name using variable values

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

creating dataset name using variable values

[ Edited ]

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 


Accepted Solutions
Solution
‎02-04-2018 08:45 PM
Super User
Posts: 6,785

Re: creating dataset name using variable values

Posted in reply to rohithverma

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.

View solution in original post


All Replies
Solution
‎02-04-2018 08:45 PM
Super User
Posts: 6,785

Re: creating dataset name using variable values

Posted in reply to rohithverma

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.

Super User
Posts: 10,787

Re: creating dataset name using variable values

Posted in reply to rohithverma

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;
New Contributor
Posts: 4

Re: creating dataset name using variable values

Posted in reply to rohithverma
Thanqq so much
New Contributor
Posts: 4

Re: creating dataset name using variable values

Posted in reply to 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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 178 views
  • 1 like
  • 3 in conversation