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.
Add
'30dec1899'd
to this value, and apply a SAS date format.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.