Hi!
I have a problem. I have a dataset looking like the following:
ID check-in check-out
XX 5/1/2016 7/1/2016
YX 12/31/2016 3/1/2017
I want to duplicate the data such that I have the intensity on each day. I want it to look like the following:
ID date
XX 5/1/2016
XX 6/1/2016
XX 7/1/2016
YX 12/31/2016
YX 1/1/2017
YX 2/1/2017
YX 3/1/2017
Does anyone now how to do this?
Use a do loop:
data want (drop=check_in check_out); set have; do date_want=check_in to check_out; output; end; run;
Use a do loop:
data want (drop=check_in check_out); set have; do date_want=check_in to check_out; output; end; run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.