topic Re: date converted to days (character variable) how to convert back to date in SAS Programming

date converted to days (character variable) how to convert back to date

SASuserlot — Tue, 06 Oct 2020 22:43:18 GMT

I exported excel file to sas, ex: for some reason date in excel is ddmmmyyy (15oct2020) converted to character days variable (41250, character) how I can bring it back to 15oct2020 in my proc report.

excel date=15oct202-

sas dataset=41250- character variable

I want in proc report as 15oct2020

Re: date converted to days (character variable) how to convert back to date

SASuserlot — Tue, 06 Oct 2020 22:48:52 GMT

Correction its imported from excel to SAS

Re: date converted to days (character variable) how to convert back to date

Tom — Tue, 06 Oct 2020 23:28:40 GMT

The best solution is to fix the Excel file so the column with the date values does not have any cells with strings instead of dates. Then SAS won't have to convert the numbers to character strings.

Otherwise convert the string to a number and adjust for the difference in how SAS and Excel count days.

sas_date = input(excel_string,32.) + '30DEC1899'd ;
format sas_date date9.;

Re: date converted to days (character variable) how to convert back to date

SASuserlot — Wed, 07 Oct 2020 00:26:41 GMT

Thanks a lot it worked.👍👍. Just curios if I want display it as 08-aug-2019, i need use date 11.?

Re: date converted to days (character variable) how to convert back to date

Tom — Wed, 07 Oct 2020 00:34:13 GMT

With a width of 11 the DATE format will add hyphens. But if you need it to display the month using lowercase letters you will need to make a custom format.

Re: date converted to days (character variable) how to convert back to date

SASuserlot — Wed, 07 Oct 2020 00:36:31 GMT

sounds great, it worked in both, I am fine with AUG capitals. Thanks.