topic Re: How to keep integer values with float values in same column in SAS Programming

How to keep integer values with float values in same column

tanya_henderson — Thu, 30 Apr 2020 12:11:05 GMT

I have data that contains values like this:

1.5

2.5

I want to export these values in this format. When I create my proc export: I get this:

1.0

1.5

2.0

2.5

How can I prevent this in my export? I want to prevent all of the .0 add-ons.

proc export data=FANEURO
outfile="~/FANEURO.csv"
dbms=dlm replace;
delimiter='|';
run;

Kurt_Bremser — Thu, 30 Apr 2020 12:21:27 GMT

Remove the format from the variable before exporting.

tanya_henderson — Thu, 30 Apr 2020 12:29:02 GMT