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!
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;
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;
Thank you so much!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.