topic Re: Formatting Class variable but not analytical variable in SAS Procedures

Formatting Class variable but not analytical variable

darrylovia — Wed, 08 Dec 2010 20:55:08 GMT

Hello SAS Forum Users,

I'm trying to create a report that bins my variable into groups (say quartiles) and then find the mean for the variable in the bin. When I use a format in proc summary, the format applies to both the binned value(class variable) and the analytical variable.

See the below code as an example with the problem that I am having. Using the SASHELP tables, the output data set has the class variable, mean and std all formated with the quartilefmt. Is there a way to only apply the format to the class variable, so I can see the mean and std with no formatting?

Thanks

proc format;
value quartilefmt
low - 43155 = '1'
43155 <- 118849 = '2'
118849 <- 336513 = '3'
336513 <- high = '4';

proc summary data=sashelp.shoes nway;
class inventory;
format inventory quartilefmt.;
var inventory;
output out=inventory_by_quartiles mean=mean std=std;
run;

Re: Formatting Class variable but not analytical variable

SPR — Wed, 08 Dec 2010 21:26:09 GMT

Hello Darrylovia,

I had the same problem and to solve it created a copy of inventory variable, applied format to it and used as a class variable:
[pre]
data i;
set sashelp.shoes;
inv=inventory;
run;
proc summary data=i nway;
class inv;
format inv quartilefmt.;
var inventory;
output out=inventory_by_quartiles mean=mean std=std;
run;
[/pre]
I should also notice that without NWAY option you will get total mean and std that could be useful.
Sincerely,
SPR

Re: Formatting Class variable but not analytical variable

RSRay_SAS — Fri, 07 Jan 2011 22:40:42 GMT

Using a DATA Step view (data i / view = i) will avoid making a copy of the original data set which could be important if it is large. The new column will exist only in memory for single pass processing.