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

[anjankumar08]

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 

[PeterClemmensen]

How do your export? Post your code please.

[anjankumar08]

Here is the code

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

[Reeza]

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;

---

[anjankumar08]

Hi,

It's showing correct in Notepad++ 

Thank you

[anjankumar08]

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

[ballardw]

---

@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.

[anjankumar08]

Thank you

[Reeza · Accepted solution]

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.

[anjankumar08]

Thank you Reeza got it.