Hi, my tables in SAS window correctly display some very small numbers as zeroes (0) --> since I have rounded them previously in SAS code to six decimal places. Yet whilst exporting this table to CSV file I see very small numbers saved in CSV as strings, say, "2E-9" instead of zeroes. Such a format of figures (written as exponentials) can't be accepted by further inbound systems to which this CSV needs to be uploaded. How to make sure that figures in my CSV file will be saved as figures to, say, six decimal places, exactly as I rounded those up in my SAS table, also including these zeroes - to avoid saving those almost zeroes as strings with exponentials? Many thanks! Details: I am using SAS VIYA. delimiter to be used is a tilde, yet I checked also other basic delimiters like a pipe or semicolon and the result is the same below a part of the code where I am rounding figures to 6 decimal places (some very small figures aptly appear as zeroes in SAS VIYA): proc sql; create table &Currentrun. as select Ultimo format=YYMMDD10.0 as Ultimo , round(_%eval(&JJJJ.+0)_0_CVAR,.000001) as CVAR_1 , round(_%eval(&JJJJ.+0)_0_EAD,.000001) as EAD_1 from out.&Currentrun._trans ; quit; below a part of the code where I export the data to a CSV file: PROC EXPORT DATA= &Currentrun. OUTFILE= "&Path./&JJJJ.&MM./&subpath./Example_file.csv" DBMS=CSV REPLACE; delimiter='~'; RUN;
... View more