01-19-2016 09:58 AM
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?
01-19-2016 10:15 AM
01-19-2016 10:17 AM - edited 01-19-2016 10:23 AM
Please show the statements that you are using. PROC UNIVARIATE ignores formats except for CLASS variables and for the display of INSET statistics.
01-19-2016 10:24 AM
Here is an example of the statements I am using (the percentages work for the output but not for the results):
CREATE TABLE SET100 AS SELECT DISTINCT
(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;
proc univariate data=SET100;
ODS RTF CLOSE;