topic Re: Change the format of numeric value in SAS Programming

Change the format of numeric value

SASdevAnneMarie — Tue, 15 Dec 2020 12:20:09 GMT

Hello Experts,

I have a numeric value with comma

-0,165530135449

I would like to have this value with a point: -0.165530135449

Could you advise me the format please, the best32. doesn't work.

Thank you very much!

Re: Change the format of numeric value

yabwon — Tue, 15 Dec 2020 12:26:55 GMT

Try this:

data _null_;
  x = -0.165530135449;

  put x= bestx32.15;
  put x= best32.15;
  put x= comma32.15;
  put x= commax32.15;
run;


data _null_;
input x commax32.;


  put x= bestx32.15;
  put x= best32.15;
  put x= comma32.15;
  put x= commax32.15;


cards;
-0,165530135449
;
run;

Re: Change the format of numeric value

SASdevAnneMarie — Tue, 15 Dec 2020 12:37:35 GMT

Thank you very much!
Could I do that with modify statement in proc sql? I need to modify the existing format column in the table.

Re: Change the format of numeric value

yabwon — Tue, 15 Dec 2020 12:43:51 GMT

data have;
  x = -0.165530135449;
  format x datetime.; /* wrong format */ 
run;
proc print data = have;
run;

proc sql;
  alter table have
    modify x format=commax32.15 /* new format */
  ;
quit;
proc print data = have;
run;

B-)

Re: Change the format of numeric value

SASdevAnneMarie — Tue, 15 Dec 2020 12:51:06 GMT

It replaces the comma by point?

Re: Change the format of numeric value

yabwon — Tue, 15 Dec 2020 12:56:31 GMT

what do you mean by "it"?

Re: Change the format of numeric value

PaigeMiller — Tue, 15 Dec 2020 13:50:10 GMT

@SASdevAnneMarie wrote:
It replaces the comma by point?

Formats change the appearance of the number for the benefit of humans looking at the number; the underlying numeric value is unchanged. I don't think the word "replaces" applies here.

Re: Change the format of numeric value

Tom — Tue, 15 Dec 2020 17:20:10 GMT

@SASdevAnneMarie wrote:

Hello Experts,

I have a numeric value with comma

-0,165530135449

I would like to have this value with a point: -0.165530135449

Could you advise me the format please, the best32. doesn't work.

Thank you very much!

If you have a numeric variable and it is display the decimal marker as a comma instead of a period then you have either attached a format that asks to display that way (BESTX, COMMAX, NLNUM) or the SAS session is running with language settings that tells SAS you are in a part of the world where comma is the normal character to use.

Check what format is attached to the variable. For example by running PROC CONTENTS on the dataset.

You can use the NLNUMI format to force SAS to display the values with period for the decimal place and comma as the thousands separators no matter what the language settings are..

Re: Change the format of numeric value

SASdevAnneMarie — Tue, 15 Dec 2020 17:53:29 GMT

Yes, it works, beacause after I can export the file with period.

Re: Change the format of numeric value

SASdevAnneMarie — Tue, 15 Dec 2020 17:54:00 GMT

The format commax32.15 🙂