topic Re: partial date export from SAS to csv in ODS and Base Reporting

partial date export from SAS to csv

Xinqiao — Thu, 07 May 2020 08:44:37 GMT

I want to export the sas data to csv, but I met some issue for partial date with ---. when I open csv with excel, the #NAME? error will show. How to show the format left to CSV file?

Re: partial date export from SAS to csv

Kurt_Bremser — Thu, 07 May 2020 09:15:51 GMT

Welcome to the SAS communities!

Please post your dataset and the code you used to export the dataset, so we can recreate your issue.

Post your dataset as a self-contained data step with datalines, so we do not need to make guesses about variable types and other attributes.

Post your code using the "little running man" button (8th icon right above the main posting window).

Re: partial date export from SAS to csv

andreas_lds — Thu, 07 May 2020 10:47:54 GMT

And what happens if you open the csv-file with a text editor like notepad++? Excel does strange things when reading files.

Re: partial date export from SAS to csv

ballardw — Thu, 07 May 2020 14:14:08 GMT

And to examine the CSV as such with a text editor you cannot SAVE the file from Excel. That will change the values of cells.

Re: partial date export from SAS to csv

Xinqiao — Sat, 09 May 2020 06:52:29 GMT

It is normal when I open it with notepad++, so its the excel issue, we can't see a partial data as ---20 in excel if the date=---2020?

Re: partial date export from SAS to csv

Xinqiao — Sat, 09 May 2020 07:24:51 GMT

If I want to fix the error, I try to add a TAP before the partial date, and the date ---2020 will show as ---2020 in excel, but it is different with other complete date, the complete date 01-JAN-2020 will show as 01-JAN-20.

Re: partial date export from SAS to csv

Xinqiao — Sat, 09 May 2020 07:25:50 GMT

Sorry, the TAP should be TAB

Re: partial date export from SAS to csv

Kurt_Bremser — Sat, 09 May 2020 17:04:05 GMT

Show us the data and the export code; only then will we be able to recreate your issue.