topic Re: Change number format in CATT in SAS Programming

Change number format in CATT

hhchenfx — Thu, 09 Jun 2022 16:26:33 GMT

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;

Re: Change number format in CATT

AhmedAl_Attar — Thu, 09 Jun 2022 16:34:49 GMT

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

Re: Change number format in CATT

ballardw — Thu, 09 Jun 2022 16:35:30 GMT

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

Re: Change number format in CATT

hhchenfx — Thu, 09 Jun 2022 17:01:39 GMT

Thank you for your help.

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

HHC

Re: Change number format in CATT

ballardw — Thu, 09 Jun 2022 17:45:19 GMT

@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***.