topic choose all variables _numeric_ except for variable period in SAS Programming

choose all variables _numeric_ except for variable period

SachinRuk — Thu, 23 Jun 2011 03:38:40 GMT

Hi All,

In my data step my period variable is numeric in format yymmdd8. My question is I want to do a proc summary such that:

proc summary data=mydata nvar;
class period;
var _numeric_ (except for period);
output out=mysummary sum=;
run;

Any thoughts?

Thanks,
Sachin

Re: choose all variables _numeric_ except for variable period

ArtC — Thu, 23 Jun 2011 04:53:29 GMT

This comes close, although analysis is done on the CLASS variable it is eliminated from the data set. There is no NVAR option (that I know of).
[pre]proc summary data=sashelp.class;* nvar;
class age;
var _numeric_;
output out=mysummary(drop=age_:)
sum=/autoname;
run;
proc print data=mysummary;
run;[/pre]

Re: choose all variables _numeric_ except for variable period

SachinRuk — Thu, 23 Jun 2011 05:51:41 GMT

Appreciate the response.

and sorry that was meant to be nway. What does sum=/autoname do?

Thanks,
Sachin

Re: choose all variables _numeric_ except for variable period

SachinRuk — Thu, 23 Jun 2011 05:53:13 GMT

and the drop=age_: while Im at it. Not sure what it does specifically.

Thanks again

Re: choose all variables _numeric_ except for variable period

ArtC — Thu, 23 Jun 2011 06:01:45 GMT

The autoname option allows MEANS/SUMMARY to name the output variables - very handy for an automated session. Without it you MUST name the new variables if there is more than one analysis variable. The resultant naming convention is always analysisvar_statistic (such as AGE_SUM). In our case we want to drop all statistics (in the example there is only SUM) that are associated with AGE. This list of variables can be abbreviated by specifying AGE_: (the colon essentially says all variables that start with AGE_).

Re: choose all variables _numeric_ except for variable period

Ksharp — Thu, 23 Jun 2011 10:16:10 GMT

Then chang to use proc means;
[pre]

proc format;
value fmt
low-100 = 'thin'
101 - high='fat'
;
run;
proc means data=sashelp.class nway noprint;
class weight;
output out=mysummary sum= /autoname;
format weight fmt.;
run;
[/pre]

Ksharp Message was edited by: Ksharp

Re: choose all variables _numeric_ except for variable period

ballardw — Thu, 23 Jun 2011 16:55:32 GMT

If your original is doing most of what you want all you actually want to do is ignore the variable then drop it from analysis:

proc summary data=mydata (drop=period) nvar;

Re: choose all variables _numeric_ except for variable period

advoss — Fri, 24 Jun 2011 15:14:38 GMT

Actually, since you are using period as your class variable, PROC SUMMARY will essentially ignore "period" as one of the _numeric_ variables and will issue the following:

WARNING: Variable period already exists on file WORK.MYSUMMARY.

WARNING: The duplicate variables will not be included in the output data set of the output statement number 1.