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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.