topic Re: Add string with Proc Format in SAS Procedures

Add string with Proc Format

dirks — Thu, 09 Nov 2017 13:25:32 GMT

Hi,

I need a user defined format and I never used PROC Format before and I am a bit lost here.

I need a format like this:

Input Value: 0.571

Output Value: +/+ 57,1%

Input Value: -1.3

Output Value: -/- 130%

This is what I got so far:

Data numbers;
input values;
cards;
0.1119
0.2119
0.57119
-0.5134
2
40
-5
;
run;

proc format;

picture advperc
low -< 0 = '99.99 %' (prefix='-/- ' mult=10000)
0 - high = '99.99 %' (prefix='+/+ ' mult=10000);
run;

proc print data = numbers;
format values advperc.;
run;

I m not quite there yet. The last 3 lines are not right.

Thank you in advance

Dirk

Re: Add string with Proc Format

Ksharp — Thu, 09 Nov 2017 13:39:32 GMT


Data numbers;
input values;
cards;
0.1119
0.2119
0.57119
-0.5134
2
40
-5
;
run;
proc format;
picture advperc
low - -1 = '00000 %' (prefix='+/+ ' mult=10000)
-1< -< 0 = '00.00 %' (prefix='-/- ' mult=10000)
0 - < 1 = '00.00 %' (prefix='+/+ ' mult=10000)
1 - high = '00000 %' (prefix='+/+ ' mult=10000);

run;
proc print data = numbers;
format values advperc.;
run;

Re: Add string with Proc Format

dirks — Thu, 09 Nov 2017 13:50:21 GMT

Thank you!

I had to add another 0 and it is working now:

1 - high = '000000 %' (prefix='+/+ ' mult=10000);

Best regards

Dirk

Re: Add string with Proc Format

Ksharp — Thu, 09 Nov 2017 13:52:40 GMT

Add more 0s.


Data numbers;
input values;
cards;
0.1119
0.2119
0.57119
-0.5134
2
40
-5
;
run;
proc format;
picture advperc
low - -1 = '0000000 %' (prefix='-/- ' mult=10000)
-1< -< 0 = '00.00 %' (prefix='-/- ' mult=10000)
0 - < 1  = '00.00 %' (prefix='+/+ ' mult=10000)
1 - high = '0000000 %' (prefix='+/+ ' mult=10000);
run;
proc print data = numbers;
format values advperc.;
run;

Re: Add string with Proc Format

Ksharp — Thu, 09 Nov 2017 13:58:29 GMT

Actually this could be more simple.


Data numbers;
input values;
cards;
0.1119
0.2119
0.57119
-0.5134
2
40
-5
;
run;
proc format;
picture advperc
low -< 0 = '0000000000.00 %' (prefix='-/- ' mult=10000)
0 - < high  = '0000000000.00 %' (prefix='+/+ ' mult=10000) ;
run;
proc print data = numbers;
format values advperc.;
run;

Re: Add string with Proc Format

dirks — Thu, 09 Nov 2017 14:03:00 GMT

I just noticed that the positive numbers arent correct.

2 should be 200, 40 is 40000 and so on.

Re: Add string with Proc Format

Ksharp — Thu, 09 Nov 2017 14:12:49 GMT

I don't understand.

200=2*100 ,whereas 40000=40*1000

Re: Add string with Proc Format

dirks — Thu, 09 Nov 2017 14:15:03 GMT

I ve got this working now.

Data numbers;
input values;
cards;
 0.1119
 0.2119
 0.57119
 -0.5134
 2
 40
 -5
 ;
run; 

proc format;

picture advperc 
		low  -< 0		    = 	'0000.99 %' (prefix='-/- ' mult=10000)
		0   - high			=	'0000.99 %' (prefix='+/+ ' mult=10000);
run;

proc print data = numbers;
format values advperc.;
run;

Re: Add string with Proc Format

dirks — Thu, 09 Nov 2017 14:17:31 GMT

I had a typo,

2 = 200, 40 = 4000

Your first output gave me

SAS Output

Obs values1234567

+/+ 11.19 %

+/+ 21.19 %

+/+ 57.11 %

-/- 51.34 %

+/+ 20000 %

+/+ 400000 %

-/- 50000 %

Re: Add string with Proc Format

Ksharp — Thu, 09 Nov 2017 14:24:30 GMT

I think you should multiply 100 not 10000.


Data numbers;
input values;
cards;
0.1119
0.2119
0.57119
-0.5134
2
40
-5
;
run;
proc format;
picture advperc
low -< 0 = '0000000000.99 %' (prefix='-/- ' mult=100)
0 - < high  = '0000000000.99 %' (prefix='+/+ ' mult=100) ;
run;
proc print data = numbers;
format values advperc.;
run;