topic unable to convert character value into date in SAS Programming

unable to convert character value into date

rohithverma — Sat, 02 May 2020 18:53:46 GMT

Intially i had a ".XLSB " formatted file which i have saved in format as ".XLSX" file. But the dates present in XLSB are converted into character in ".XLSX" .So while applying any date format for this it was taking as year 2080 but not the present year.

For example in ".XLSB" the format is "28-JAN-2020" while after converting into ".XLSX" the same value is converted to "43858:"

and when i tried to apply format for this it was converting into "28-JAN-2080".

Please help me on this.

Re: unable to convert character value into date

PaigeMiller — Sat, 02 May 2020 20:11:26 GMT

https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Conversion-from-Excel-Date-to-SAS-Date/td-p/475824

Re: unable to convert character value into date

Kurt_Bremser — Sat, 02 May 2020 20:52:02 GMT

Add

'30dec1899'd

to this value, and apply a SAS date format.