topic Re: How to format value with Dollar and Percent in SAS Programming

How to format value with Dollar and Percent

jhh197 — Tue, 08 Feb 2022 09:22:24 GMT

Hi ,

I have a dataset where Amt columns are in form of values and i want output to look like when Flag is yes then format amount fields with dollar sign and Falg is N then with % sign

T3 = T1/T2

Test1

SPP	SLN	Amt1	Amt2	T1	T2	Flag
650	300	20	53	15	24	Y
325	250	52	87	10	32	N

Output should look like

SPP

SLN

Amt1

Amt2

Flag

650

300

20$

53$

15$/24$

325

250

52%

87%

10%/32%

Can anyone please help

Re: How to format value with Dollar and Percent

PeterClemmensen — Tue, 08 Feb 2022 09:25:19 GMT

You want Amt1 and Amt2 to be numeric and T3 to be character, correct?

Re: How to format value with Dollar and Percent

andreas_lds — Tue, 08 Feb 2022 10:32:12 GMT

So if flag = 'Y' you want to attach "$" to Amt1 and Amt2 and combine T1 and T2 and if flag = "N" you want to "%" instead of "$". Right?

You do want a report, correct?

Re: How to format value with Dollar and Percent

AMSAS — Tue, 08 Feb 2022 15:47:44 GMT

Is this what you are looking for?
No sure why you are doing this, so there might be a better solution

data have ;
	infile cards ;
	input amt1 amt2 t1 t2 flag $ ;
cards ;
20 53 15 24 Y
52 87 10 32 N
;

data want ;
	length 
		amt1F $10
		amt2F $10
		T3 $100 ;
	set have ;
	if flag="Y" then 
		symbol="$" ;
	else
		symbol="%" ;
	amt1F=trim(putn(amt1,"8."))!!symbol ;
	amt2F=trim(putn(amt2,"8."))!!symbol ;
	t3=trim(putn(t1,"8."))!!symbol!!"/"!!trim(left(putn(t2,"8.")))!!symbol ;
	put amt1F= amt2F= t3= ;

run ;

Re: How to format value with Dollar and Percent

jhh197 — Tue, 08 Feb 2022 16:55:25 GMT

Yes . Right .

Re: How to format value with Dollar and Percent

jhh197 — Tue, 08 Feb 2022 17:05:38 GMT

Thank you so much for all help . This is right . I will apply same logic to my data and check . Will update .

Re: How to format value with Dollar and Percent

jhh197 — Thu, 10 Feb 2022 00:51:59 GMT

Thank you so much for all your help . It worked 🙂