topic Re: Formating number 0.000 with SAS in SAS Data Management

Formating number 0.000 with SAS

MainframeSAS — Sat, 08 Aug 2015 19:54:04 GMT

Good afternoon,

i`m currently producing a csv txt file with around 500.000 lines using SAS on mainframe (zos).

It has around 40 columns and its majority are numeric.

At certain point of my program i use the following to format the numbers :

FORMAT field1 field2 field3 field4 field5 field6 8.4;

My goal is to reduce the file output report size and since a lot of data is 0.0000 i thought i could replace this by 0 only.

This would save 5 characters and certainly would save some space.

Any ideia on how could i do this ?

Re: Formating number 0.000 with SAS

SASKiwi — Sun, 09 Aug 2015 01:41:56 GMT

The BEST format could do what you want. Try BEST8. - this will ensure 0 just shows as 0 and decimals like 12.34 will show as 12.34.

Re: Formating number 0.000 with SAS

Jagadishkatam — Sun, 09 Aug 2015 02:00:52 GMT

I believe picture format will work, please replace 8.4 with picture the below picture format

proc format fmtlib;

picture pct 0='9'

0<-high='09.9999';

run;

data have;

input x;

cards;

8.99

8.12

8.3

;

data want;

set have;

format x pct.;

run;

Thanks,

Jag

Re: Formating number 0.000 with SAS

data_null__ — Sun, 09 Aug 2015 11:54:56 GMT

Back in the day we used implied decimal in-formatting. How much space would getting rid of ALL the decimal points save?

How much more space would you save if you got rid of the field delimiters?

Re: Formating number 0.000 with SAS

Tom — Sun, 09 Aug 2015 14:17:48 GMT

I assume you wanted to apply the format to limit the display of non-significant precision in the numbers. You would probably have the best results by rounding the values to 4 decimal places and then letting SAS format the values using BEST format.

data _null_;

set mydata ;

array f field1-field8 ;

do over f; f=round(f,0.0001); end;

file 'myfile.csv' dsd ;

format field1-field8 ;

put (_all_) (:) ;

run;