topic Export issue with CSV fil in SAS Programming

Export issue with CSV fil

AshokD — Tue, 08 Jan 2019 07:10:25 GMT

Hi All,

I am trying export a dataset with employee_id field to CSV file. File was created but the last digit value is getting replaced with "0".

Ex:- In dataset , Employee_ID has value 8593217412 , when i export the data the value looks like 8593217410

SAS Code:-

ods csv file='LIST1.csv';
proc print data=work.TEST1;
run;
ods csv close;

Is there any solution for this ?

Please someone correct me where I'm wrong here.

Thanks

Re: Export issue with CSV fil

Kurt_Bremser — Tue, 08 Jan 2019 08:13:40 GMT

Please post a sample of work.test1 in a data step with datalines (see my footnotes).

ODS CSV is probably the least efficient way to create a csv file; proc export is a much better way to go, and writing your own data step the best.

Re: Export issue with CSV fil

ballardw — Tue, 08 Jan 2019 16:09:10 GMT

What FORMAT is currently assigned to your Employee_Id variable?

How are you examining the values in the CSV file? If using a spread sheet you might have a display that is rounding values for some reason and you should check the appearance in a plain text editor such as NotePad or even the SAS editor.

It would appear that your variable is numeric. ID variables that you are not doing arithmetic with should generally not be numeric but character.