topic How do I turn ddMMMyyyy into one day prior? in SAS Procedures

How do I turn ddMMMyyyy into one day prior?

JohnWiz — Tue, 09 Aug 2011 20:43:57 GMT

I have a table with a column containing Effective Dates in DDMMMYYYY format. Expiration Date values don't exist on the table so I need to create my own values for 'Expiration Date'. I need to Select (EFFECTIVE_DATE - 1 as EXPR_DATE) essentially so that if the Effective Date reads 02APR2011 the new field EXPR_DT will show 01APR2011.

Can anyone help me please?

How do I turn ddMMMyyyy into one day prior?

art297 — Tue, 09 Aug 2011 20:47:59 GMT

If you are doing it in proc sql you already have the correct syntax if you leave off the parentheses.

A SAS date - 1 is equal to the SAS date of the prior day. Thus, in a datastep, EXPR_DATE=EFFECTIVE_DATE - 1; would work.

How do I turn ddMMMyyyy into one day prior?

JohnWiz — Tue, 09 Aug 2011 20:50:06 GMT

awesome. hadn't even bother trying a proc yet. Thanks a bunch.

How do I turn ddMMMyyyy into one day prior?

Doc_Duke — Tue, 09 Aug 2011 20:52:06 GMT

SAS stores dates internally as the number of days from 1/1/1960, so date arithmetic is simple. If effective_date is a SAS date, then

expr_dt = effective_date-1;

FORMAT expr_dt date9.;

should do it. If effective_date is a character string, then you need to first convert it to a SAS date using the INPUT function, like

effective_date_new= INPUT(effective_date, anydate9.);

Doc Muhlbaier

Duke