Good morning,
I'd like to create a variable "usedate" where usedate will take the value of "termdate" and if "termdate" is not available it would take the value of "sentdate." While I'm familiar with how to write it in SPSS, I'm not sure how to write it in SAS.
If by not available you mean the value is missing then you could do:
if not missing(termdate) then usedate=termdate;
else usedate=sentdate;
or you could use the coalese function
usedate=coalese(termdate,sentdate);
If by not available you mean the value is missing then you could do:
if not missing(termdate) then usedate=termdate;
else usedate=sentdate;
or you could use the coalese function
usedate=coalese(termdate,sentdate);
Perfect. Thank you!
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 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.