topic Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output in New SAS User

How do I omit "_TYPE_" and "_FREQ_" from a proc means output

hz16g22 — Sun, 12 Mar 2023 22:25:14 GMT

I tried to type stuff like nofreq or notype, but that didnt work like how noobs would

this is the code

10   proc means data=amphibians noprint;
11       var Green_frogs Brown_frogs Common_toad Fire_bellied_toad
12           Tree_frog Common_newt Great_crested_newt;
13       output out=Number_Of_Species_Observed sum= / ;
14       title "Number of Species Observed";
15   run;

Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output

SASKiwi — Sun, 12 Mar 2023 22:53:30 GMT

proc means data=amphibians noprint;
  var Green_frogs Brown_frogs Common_toad Fire_bellied_toad
       Tree_frog Common_newt Great_crested_newt;
  output out=Number_Of_Species_Observed (drop = _type_ _freq_) sum= / ;
  title "Number of Species Observed";
run;

Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output

PaigeMiller — Mon, 13 Mar 2023 10:16:51 GMT

Or even simpler:

 output out=Number_Of_Species_Observed (drop = _:) sum= ;

Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output

ballardw — Mon, 13 Mar 2023 11:32:32 GMT

Note that data set options are available pretty much anywhere you have a data set used for input or output.

The options would go in () immediately following the set name. In this case you want to DROP variables but you can do a number of other things. It is worth looking at the documentation as these are extremely useful.

Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output

hz16g22 — Mon, 13 Mar 2023 13:24:58 GMT

Thanks,

Just to know, what does the colon mean in this case? cos it seems like it would work the same if i put a "%" instead, or does not work?

Re: How do I omit "_TYPE_" and "_FREQ_" from a proc means output

PaigeMiller — Mon, 13 Mar 2023 13:53:35 GMT

@hz16g22 wrote:

Thanks,

Just to know, what does the colon mean in this case? cos it seems like it would work the same if i put a "%" instead, or does not work?

The colon in (drop=_:) indicates all variables whose names that begin with an underscore. Had I typed something different, such as (drop=age:) the colon indicates all variables whose names begin with age. You can use the colon any place where SAS can accept a list of variable names. It also works on SAS data set names.