topic Re: Formatting Proc Univariate Variables as a Percent in SAS Procedures

Formatting Proc Univariate Variables as a Percent

BRT001 — Tue, 19 Jan 2016 14:58:17 GMT

Hi,

I am running a statistical analysis using the proc univariate (proc uni) function and to format the proc uni variable, I used the percent function percentn.n. It worked for just the first variable but not for the others. I was wondering if there is a special/different function for formatting proc uni variables as a percent?

Re: Formatting Proc Univariate Variables as a Percent

Jagadishkatam — Tue, 19 Jan 2016 15:15:19 GMT

I believe you need to apply the format to the variables in the separate dataset with the existing dataset created by the proc univariate

Re: Formatting Proc Univariate Variables as a Percent

Rick_SAS — Tue, 19 Jan 2016 15:23:08 GMT

Please show the statements that you are using. PROC UNIVARIATE ignores formats except for CLASS variables and for the display of INSET statistics.

Re: Formatting Proc Univariate Variables as a Percent

BRT001 — Tue, 19 Jan 2016 15:24:50 GMT

Hi,

Here is an example of the statements I am using (the percentages work for the output but not for the results):

PROC SQL;

CREATE TABLE SET100 AS SELECT DISTINCT

A.YRY,

A.MTM,

A.ID,

A.RES,

A.PRES,

(PRES * MoDays*24) as total_month,

A.DRES/calculated total_month format percentn10.2 AS PTRES

FROM SET00 A

WHERE A.CRES>0 AND A.DRES>0

order by calculated ptres desc;

QUIT;

proc univariate data=SET100;

var PTRES;

run;

ODS RTF CLOSE;

Re: Formatting Proc Univariate Variables as a Percent

Ksharp — Wed, 20 Jan 2016 01:45:01 GMT

A.DRES/calculated total_month AS PTRES format=percentn10.2