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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.