Help with SAS code

ugly_duck_ling — Wed, 25 May 2022 13:02:55 GMT

I have a dataset that I am required to tell SAS to output the number of observations that are dictated by the "count" variable.

The dataset is:

data one;
input type $ count;
datalines;
1 2
2 2
3 1
4 5
5 3
;
run;

My code for that was:

data two;
set one;
do i= 1 to 5;
if i gt count then delete;
output;
end;
run;

The above code is satisfactory, yet I am wondering if could re-write the code and get the same result by starting my code with the following do loop:

do i= 1 to N /* where N is a variable */

Can anyone help me with that?

Thanks!

Re: Help with SAS code

AMSAS — Thu, 26 May 2022 16:19:07 GMT

Is this what you mean?

data one;
	input type $ count;
datalines;
1 2
2 2
3 1
4 5
5 3
;
run;

 
 

data two;
	set one;
	do i= 1 to count;
		output;
	end;
run;

ugly_duck_ling — Thu, 26 May 2022 17:57:26 GMT

Thank you so much!