topic Re: PERCENTAGE FORMAT in SAS Programming

How i get output in percentage format

Brownisiak69 — Fri, 19 May 2023 02:23:26 GMT

DATA XYZ;
SET XYZ_V1;
KEEP DTS COD Q_1 Q_2 Q_3 Q_4 QPC_1 QPC_2 QPC_3 QPC_4 TOTAL_SUM;
LENGTH QPC_1 QPC_2 QPC_3 QPC_4 $6;
QPC_1=Q_1/TOTAL_SUM;
QPC_2=Q_2/TOTAL_SUM;
QPC_3=Q_3/TOTAL_SUM;
QPC_4=Q_4/TOTAL_SUM;
RUN;

HOW DO I GET OUTPUT IN A PECENTAGE FORMAT?

Re: PERCENTAGE FORMAT

AMSAS — Thu, 18 May 2023 17:34:42 GMT

You are probably looking for a format

Possibly something like PERCENTw.d Format

Re: PERCENTAGE FORMAT

ballardw — Fri, 19 May 2023 11:44:57 GMT

[Admin Note] Added links to format documentation

Percentw.d or PercentNw.d. The Percentw.d format will place () around negative values so reserves two of the positions of the width for those. The PercentNwd. format uses a negative sign, hence the N in the name, for negative values and reserves one position for that.

As an example if you want the format as a default. This only displays one decimal point in the percent.

(Missed the inappropriate definition of variables a character)

 DATA  XYZ;
SET XYZ_V1;
KEEP DTS COD Q_1 Q_2 Q_3 Q_4 QPC_1 QPC_2 QPC_3 QPC_4 TOTAL_SUM;
LENGTH QPC_1 QPC_2 QPC_3 QPC_4 $6;
QPC_1=Q_1/TOTAL_SUM;
QPC_2=Q_2/TOTAL_SUM;
QPC_3=Q_3/TOTAL_SUM;
QPC_4=Q_4/TOTAL_SUM;
format Qpc_:  percentn8.1; 
RUN;

Re: PERCENTAGE FORMAT

Kurt_Bremser — Thu, 18 May 2023 19:53:04 GMT

Why do you define variables which will hold the results of calculations as character?

Remove the LENGTH statement and use a FORMAT statement with PERCENT7.2 instead.

Re: PERCENTAGE FORMAT

Brownisiak69 — Fri, 19 May 2023 02:18:59 GMT

If I use format percent7.2, this type of error message shows

Re: PERCENTAGE FORMAT

Brownisiak69 — Fri, 19 May 2023 02:27:34 GMT

As tried the query provided by you worked successfully, much more thanks for your help and support.

Re: PERCENTAGE FORMAT

Tom — Fri, 19 May 2023 02:28:13 GMT

You have to tell the FORMAT statement what variable(s) you want the PERCENT format to be attached to. It cannot read your mind. That is why it is telling you that it is expecting a NAME or a variable list here it has indicated it detected the error.

Re: PERCENTAGE FORMAT

Brownisiak69 — Fri, 19 May 2023 02:36:44 GMT

Yes, I get the result. The length statement hold my program, so I removed the length statement and added the format statement and got the result.