New Contributor
Posts: 4

Is it possible to create a dataset by looping variable

Assuming I have 3 variables a, b & c

where a = 1,2
b = 3, 4
c = 5, 6

Can I create a dataset that looks like this.

a -- b -- c
1 -- 3 -- 5
1 -- 3 -- 6
1 -- 4 -- 5
1 -- 4 -- 6
2 -- 3 -- 5
2 -- 3 -- 6
2 -- 4 -- 5
2 -- 4 -- 6

I tried doing this with some loops, but was not able to get it to work. So any help would be quite helpful, because using my actual data I would have 300-400k different combinations. Message was edited by: DarknessFalls
Valued Guide
Posts: 2,191

Re: Is it possible to create a dataset by looping variable

> Assuming I have 3 variables a, b & c
>
> where a = 1,2
> b = 3, 4
> c = 5, 6
>
> Can I create a dataset that looks like this.
>
> a -- b -- c
> 1 -- 3 -- 5
> 1 -- 3 -- 6
> 1 -- 4 -- 5
> 1 -- 4 -- 6
> 2 -- 3 -- 5
> 2 -- 3 -- 6
> 2 -- 4 -- 5
> 2 -- 4 -- 6
>
> I tried doing this with some loops, but was not able
> to get it to work. So any help would be quite
> helpful, because using my actual data I would have
> 300-400k different combinations.
>
> Message was edited by: DarknessFalls

data;
do a = 1,2 ;
do b = 3, 4 ;
do c = 5, 6 ;
output ;
end;end;end;
run;
Discussion stats