topic Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in in SAS Programming

SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in csv

anjankumar08 — Thu, 27 Aug 2020 14:29:33 GMT

Hi guys,

I'm facing issue while converting SAS dataset to CSV. Character variable is converting to numeric in CSV file and missing trailing zeros. Below is the example.

SAS Dataset:

employy
1004.13100
1004.13140
1003.45620

after converting to CSV it is showing in numeric and missing trailing zeros

employy
1004.131
1004.1314
1003.4562

Need help. Appreciated

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

PeterClemmensen — Thu, 27 Aug 2020 14:33:30 GMT

How do your export? Post your code please.

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

anjankumar08 — Thu, 27 Aug 2020 14:38:42 GMT

Here is the code

PROC EXPORT DATA= XXX
OUTFILE= "C:\temp\test.csv"
DBMS=CSV REPLACE;
PUTNAMES=YES;
RUN;

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

Reeza — Thu, 27 Aug 2020 14:51:14 GMT

How did you 'check' your file? If you opened it in Excel, Excel does it's own interpretation of the CSV. Make sure to check the output using a text editor such as Notepad++.

@anjankumar08 wrote:

Here is the code

PROC EXPORT DATA= XXX
OUTFILE= "C:\temp\test.csv"
DBMS=CSV REPLACE;
PUTNAMES=YES;
RUN;

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

anjankumar08 — Thu, 27 Aug 2020 15:13:16 GMT

Hi,

It's showing correct in Notepad++

Thank you

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

anjankumar08 — Thu, 27 Aug 2020 15:16:29 GMT

Why it is like this? Why it is not showing correct in CSV?

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

ballardw — Thu, 27 Aug 2020 15:30:23 GMT

@anjankumar08 wrote:
Why it is like this? Why it is not showing correct in CSV?

What application are you using to look at the CSV file?

If you opened the file with Excel, and possibly other spreadsheets, and then SAVED the file when closing then you may very well have permanently altered the contents. As @Reeza said.

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

Reeza — Thu, 27 Aug 2020 15:33:13 GMT

Because Excel is interpreting the data when it reads it in. It shouldn't but it does. To avoid this open Excel, Data Tab>Import CSV/Text.
Set Data Detection to Do Not Detect Types.

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

anjankumar08 — Thu, 27 Aug 2020 15:35:34 GMT

Thank you Reeza got it.

Re: SAS dataset to CSV missing trailing zeros in character variable and it is converting numeric in

anjankumar08 — Thu, 27 Aug 2020 15:37:23 GMT

Thank you