Imagine I got Data set like:
ID START_YEAR END_YEAR
1 2015 2017
my target is to convert this to:
ID YEAR
1 2015
1 2016
1 2017
Do you have any solution?
@PatrykSAS Welcome to the SAS Community 🙂
There you go
data have;
input ID START_YEAR END_YEAR;
datalines;
1 2015 2017
;
data want (keep=id year);
set have;
do year = start_year to end_year;
output;
end;
run;
data want;
set have;
do year=start_year to end_year by 1;
output;
end;
drop start_year end_year;
run;
@PatrykSAS Welcome to the SAS Community 🙂
There you go
data have;
input ID START_YEAR END_YEAR;
datalines;
1 2015 2017
;
data want (keep=id year);
set have;
do year = start_year to end_year;
output;
end;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.