Displaying percentage sign in just one column

Q1983 — Wed, 01 Feb 2017 03:50:45 GMT

Proc tabulate data=app_summary2 order= data format=10. S=[cellwidth=80]; /* order= formatted format=PCTFMT.;*/

Class LOAN_OFFICER racf_id /missing;

Var stp1 pct ln;

Tables LOAN_OFFICER * racf_id =' ' all={label='Total' S=[background = lightblue cellwidth=80]} *[STYLE=[Font_Weight=bold]],

all={ label='Apps Sent Summary' S=[background = lightblue]} *[STYLE=[Font_Weight=light]]

*(pct =''*mean='Total % Sum of % Sent to Processing'

stp1 =' '*sum='Sum of SENT_TO_PROC_BY_END_RPT_MO'

ln=''*sum ='Sum of CT_LN_NBR' )

/ box='Loan Officer and LO_RACF';

keylabel n='';

run;

This code creates a column of data. I want the first column called pct to display all numbers with a percentage sign next to it. I tried order=formatted and used a created picture format however it made all columns into percentages

Code for Last_Mo_Apps_Sent.sas
Loan Officer and LO_RACF		Apps Sent Summary
		Total % Sum of % Sent to Processing	Sum of SENT_TO_PROC_BY_END_RPT_MO	Sum of CT_LN_NBR
Loan Officer		100	2	2
doe	UVAY6
deed	UVAD89	68	15	22
Total		84	17	24

Re: Displaying percentage sign in just one column

mkeintz — Wed, 01 Feb 2017 06:51:16 GMT

If you divide your PCT variable by 100 then you could use the PERCENT5.0 format as in

*(pct =''*mean='Total % Sum of % Sent to Processing'*f=percent5.0

stp1 =' '*sum='Sum of SENT_TO_PROC_BY_END_RPT_MO'

ln=''*sum ='Sum of CT_LN_NBR' )

Putting the "f=" in that location assign the format just to the PCT var.

If you don't want to rescale PCT then you could use PROC FORMAT with a PICTURE statement to make your own format. Seomthing like:

proc format;

picture myfmt low-high='000%';

run;

Then put its name where the "percent5.0" is above.

xxx

topic Displaying percentage sign in just one column in ODS and Base Reporting

Displaying percentage sign in just one column

Re: Displaying percentage sign in just one column