Change number format in CATT

[hhchenfx]

Hi Everyone,

I have number 15.699997 and I want to create variable with value 15.69***.

Can you please modify the code below to get it work?

Thanks,

HHC

data have;
	input a;
	datalines;
15.699997
;
run;

data want;
	set have;
	c=catt(a, " **** ");
run;

[AhmedAl_Attar · Accepted solution]

data want;
set have;
c=catt(PUT(a,8.2), "****");
run;

[ballardw]

This works for that single value.

God knows why you want that. Smacks of the social sciences * ** and *** for "significance levels"

data have;
	input a;
   x = cats(substr(put(a,f9.6),1,5),"***");
datalines;
15.699997
;

If you have a more generic question you should make it so as the proposed solution won't work for values above 100 most likely and may have issues with small values of A

[hhchenfx]

Thank you for your help.

The *** is just an example. I add text to number.

HHC

[ballardw]

---

@hhchenfx wrote:

Thank you for your help.

The *** is just an example. I add text to number.

HHC

---

I thought you wanted 15.69***. Using 8.2 format results in 15.70***.