topic Re: How to create the following data step or macro variable. in SAS Programming

How to create the following data step or macro variable.

Ram_SAS — Tue, 28 Jun 2016 19:35:16 GMT

From the following observations I need to create two variable var101 and var102 (either data step or macro variable).

ID numvalue

101 23

101 27

101 29

101 22

102 23

102 32

var101 = 23 27 29

var102 = 22 23 32

Re: How to create the following data step or macro variable.

Ram_SAS — Tue, 28 Jun 2016 19:40:39 GMT

The SQL into clause could load everything into one macro variable, but I want to group them into different variables based on the ID. Any suggestions?

Re: How to create the following data step or macro variable.

Reeza — Tue, 28 Jun 2016 20:01:09 GMT

Multiple queries? But why?

You could also use a data step that concatenates variable and creates macro variable at the end of each group id.

Untested but the gist of the idea is there.

Data _null_;
Length var_string $200.;
Set have;

By id;
Retain var_string;
If first.id then call missing(var_string);

Var_string = catt(var_string, value);

If last.id then call symputx('var'|put(id, z3.), var_string);

Run;

Re: How to create the following data step or macro variable.

Ram_SAS — Tue, 28 Jun 2016 20:18:23 GMT

Awesome ! Thanks for your help !