topic If then statement in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122643#M33705 <HTML><HEAD></HEAD><BODY><P>Good morning,</P><P></P><P>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.</P></BODY></HTML> Wed, 27 Feb 2013 13:56:38 GMT AshleyM 2013-02-27T13:56:38Z If then statement https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122643#M33705 <HTML><HEAD></HEAD><BODY><P>Good morning,</P><P></P><P>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.</P></BODY></HTML> Wed, 27 Feb 2013 13:56:38 GMT https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122643#M33705 AshleyM 2013-02-27T13:56:38Z Re: If then statement https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122644#M33706 <HTML><HEAD></HEAD><BODY><P>If by not available you mean the value is missing then you could do:</P><P></P><P>if not missing(termdate) then usedate=termdate;</P><P>else usedate=sentdate;</P><P></P><P>or you could use the coalese function</P><P></P><P>usedate=coalese(termdate,sentdate);</P></BODY></HTML> Wed, 27 Feb 2013 13:59:10 GMT https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122644#M33706 Tom 2013-02-27T13:59:10Z Re: If then statement https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122645#M33707 <HTML><HEAD></HEAD><BODY><P>Perfect. Thank you! </P></BODY></HTML> Wed, 27 Feb 2013 14:59:35 GMT https://communities.sas.com/t5/SAS-Procedures/If-then-statement/m-p/122645#M33707 AshleyM 2013-02-27T14:59:35Z