How to create the following data step or macro variable.

[Ram_SAS]

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

[Ram_SAS]

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? 

[Reeza · Accepted solution]

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;

[Ram_SAS]

Awesome ! Thanks for your help !