topic Re: decimal points in SAS Programming

decimal points

r3570 — Wed, 22 Sep 2021 08:04:30 GMT

Hi All,

Can anyone help me to exhibit the numeric value with 2 decimal points as below

10010 should be represented as 10010.00

Re: decimal points

PeterClemmensen — Wed, 22 Sep 2021 08:11:58 GMT

Apply an appropriate format

data _null_;
   n = 10010;
   put n = 8.2;
run;

Re: decimal points

r3570 — Wed, 22 Sep 2021 08:41:56 GMT

I am not able to get the required out put.

I have the values as below

20010

20050

20070

20014

i need the below output.

20010.00

20050.00

20070.00

20014.00

Need a pgrm so that i can apply the same with minor changes.

Re: decimal points

Kurt_Bremser — Wed, 22 Sep 2021 08:49:13 GMT

See this for proof:

data want;
input number;
format number 8.2;
datalines;
20010
20050
20070
20014
;

proc print data=want noobs;
run;

Result:

number
20010.00
20050.00
20070.00
20014.00

If you have trouble with your application of this, please post the log.

Re: decimal points

Patrick — Wed, 22 Sep 2021 09:05:06 GMT

Below some sample code for both a numerical and a character variable.

If your variable is of type character then we must first convert the string to an number using an input statement and then use a put statement with a numerical format to create a string as you want it in your character variable. The character variable must have a length long enough to hold the additional 3 characters (the dot and two digits).

data have;
  input @1 myvar_num @1 myvar_char $;
  datalines;
20010
20050
20070
20014
;
 
data want;
  set have;
  format myvar_num 16.2;
  myvar_char=put(input(myvar_char,best32.),16.2 -l);
run;

proc print data=want;
run;