topic Re: Numeric Days to a Date Format in SAS Enterprise Guide

Numeric Days to a Date Format

deleted_user — Wed, 27 May 2009 13:31:03 GMT

I have a string parameter that I have that I enter as a date (mm/dd/yyyy). I do not have this parameter enclosed in quotes because of something I am doing later in the process. I then want to subtract 1 day from this date that is being entered. So, I am trying to convert this string into a date so I can use the INTNX function. I am having troubles converting the parameter string into a date format.

Please help! Message was edited by: rmccray

Re: Numeric Days to a Date Format

sbb — Wed, 27 May 2009 13:48:18 GMT

Try using the INPUT function in a SAS variable assignment statement, specifying the appropriate INFORMAT name as the second argument. Check resources on the SAS support http://support.sas.com/ website, such as the technical conference paper listed below.

Scott Barry
SBBWorks, Inc.

A Beginners Guide to SAS  Date and Time Handling
Wayne Finley, State of California HHSDC, Sacramento, CA
http://www2.sas.com/proceedings/sugi25/25/btu/25p058.pdf

Re: Numeric Days to a Date Format

Doc_Duke — Wed, 27 May 2009 13:49:35 GMT

input(, mmddyy10.) will convert to a number, PUT(, mmddyy10.) goes the other way, so to get the new var to have a string value that is one day less,

=PUT(INPUT(,mmddyy10.)-1,mmddyy10.);

Doc Muhlbaier
Duke