Loop through a list and create a dataset

[zqkal]

Hi SAS Users, 

I have a global macro which contains a list of values in which the order they appear represent the order they should appear in the dataset. 

%let values = A, C, D, Z; 

I want to loop through the list and create a dataset similar to this. I want this to be a dynamic dataset that updates itself when a new list is added. 

Values order 

A  1

C 2

D 3

Z 4

[novinosrin · Accepted solution]

%let values = A, C, D, Z; 


data want;
do order=1 to countw("&values",',');
values=scan("&values",order,',');
output;
end;
run;