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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.