topic Re: Convert Char Var Date9 format to SASDATE for comparison. in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215063#M52944 <HTML><HEAD></HEAD><BODY><P>It would help to show the code actually used. I would say the most likely culprit are some specific values are not valid dates: 30FEB2014 for instance.</P><P>Show an entire error message.</P></BODY></HTML> Thu, 14 May 2015 18:08:46 GMT ballardw 2015-05-14T18:08:46Z Convert Char Var Date9 format to SASDATE for comparison. https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215060#M52941 <HTML><HEAD></HEAD><BODY><P>I am trying to convert a Character date DDMonYYY format to a SASDATE to compare against a Raw date read in as ccyymmdd and converted to SASDATE. I tried using INPUT function as in Sample 24591 using Date9, but it does not work. I get "Invalid argument to INPUT function at Line ### Column ##'. When I PUT the string data into the SASLOG it shows that it matches. The new data field using the INPUT function dusplays as missing.</P></BODY></HTML> Thu, 14 May 2015 16:41:17 GMT https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215060#M52941 SharonBH 2015-05-14T16:41:17Z Re: Convert Char Var Date9 format to SASDATE for comparison. https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215061#M52942 <HTML><HEAD></HEAD><BODY><P>Is this the problem : reading a date with a 3-digit year? </P></BODY></HTML> Thu, 14 May 2015 16:52:54 GMT https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215061#M52942 PGStats 2015-05-14T16:52:54Z Re: Convert Char Var Date9 format to SASDATE for comparison. https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215062#M52943 <HTML><HEAD></HEAD><BODY><P>No, that was a typo. The date read in is format is DDMonYYYY.</P></BODY></HTML> Thu, 14 May 2015 17:36:06 GMT https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215062#M52943 SharonBH 2015-05-14T17:36:06Z Re: Convert Char Var Date9 format to SASDATE for comparison. https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215063#M52944 <HTML><HEAD></HEAD><BODY><P>It would help to show the code actually used. I would say the most likely culprit are some specific values are not valid dates: 30FEB2014 for instance.</P><P>Show an entire error message.</P></BODY></HTML> Thu, 14 May 2015 18:08:46 GMT https://communities.sas.com/t5/SAS-Procedures/Convert-Char-Var-Date9-format-to-SASDATE-for-comparison/m-p/215063#M52944 ballardw 2015-05-14T18:08:46Z