Hi all,
I'm creating a new variable and not quite sure how to tackle it.
Essentially, this is what I want to do:
Data new_dataset;
Set old_dataset;
If confine_date between start_date and end_date then match = 'yes' else match = 'no';
Run;
The problem is that the dates aren't fixed. Any help/direction would be appreciated.
Thanks.
You mixed up IF and WHERE statement.
If start_date <= confine_date <= end_date then match = 'yes' else match = 'no';
place a semicolon before else in Xia code
If start_date <= confine_date <= end_date then match = 'yes';
else match = 'no';
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.