Loop through a list and create a dataset

zqkal — Tue, 30 Apr 2019 16:20:05 GMT

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

Re: Loop through a list and create a dataset

novinosrin — Tue, 30 Apr 2019 16:27:42 GMT


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


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

topic Loop through a list and create a dataset in SAS Programming

Loop through a list and create a dataset

Re: Loop through a list and create a dataset