Numeric Days to a Date Format

[deleted_user]

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

[sbb]

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

[Doc_Duke]

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