topic Re: how to Export DATA to csv with 16 decimal places in values ? in SAS Programming

how to Export DATA to csv with 16 decimal places in values ?

RU114 — Thu, 24 Oct 2024 02:46:38 GMT

Hi,

I need to export dataframes calculated in SAS to csv with 16 decimal places. How do this ? is there an option in proc export ?

proc export data=sas-dataset-name
  outfile='/path/to/output/filename.csv'
  dbms=csv
  replace;
run;

Re: how to Export DATA to csv with 16 decimal places in values ?

LinusH — Thu, 24 Oct 2024 09:35:24 GMT

If you got your dataframe result to a SAS dataset, you can formats to the columns you need to have a specified numger of decimals:

proc datasets lib=library-name;
	modify sas-dataset-name;
		format variable-name 22.16;
	run;
quit;

Re: how to Export DATA to csv with 16 decimal places in values ?

ballardw — Thu, 24 Oct 2024 14:27:52 GMT

How critical are the 15th and 16th decimal places? If very critical then a basic SAS data set may not be where this belongs due to precision of storage.

Re: how to Export DATA to csv with 16 decimal places in values ?

Tom — Thu, 24 Oct 2024 17:21:13 GMT

Note that the 16th digit will not be reliable stored in SAS numbers. See Numerical Precision discussion in the documentation:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lepg/p0dv87zb3bnse6n1mqo360be70qr.htm

To control how values are PRINTED in SAS you can attach a FORMAT to the variable. The EXPORT produces just uses a normal data step with PUT statement to write the CSV file. So whatever format was attached to the variable will be used.

16 digits total? You might try using BEST17. (leaving one space for the decimal point). Or perhaps BEST18. if you have any negative values.

16 to the right of the decimal point? How many to the left of the decimal point? Use 18.16 to write 16 to the right of the decimal point, a decimal point, and one digit to the left.

Or something else?