Dear all,
proc means data=dsn noprint completetypes;
class trtmntgroup /preloadfmt;
output out=tot n=n;
format trtmntgroup trtf. ;
by vstgrp descending severity;
run;
This is the code I used for AE table. I got the values
without giving the variable ‘trtmntgroup(numeric)’ in var
statement. And if I give the var statement for that variable
i’m getting the same values.How is that possible? What is
the difference between class and var statement? Could any
one explain me how does proc means work at the back end.
And what is the difference between _freq_ value and N value
in proc means.
Thanks and regards,
Rajesh.
Answer Posted / vivek
Can use CLASS or BY. However if BY is used then the dataset
should be sorted first.
The _FREQ_ variable is automatically generated by SAS and
shows the number of observations for each level of the
CLASS variable.
The _N_ variable is automatically generated by SAS. It is
initially set to 1, and it increments by 1 every time the DATA
step iterates.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is program data vector (pdv)?
How we can create SAS USER DEFINED CODE?
name some data transformation used in sas di? : Sas-di
How do you add a number to a macro variable? : sas-macro
How would you determine the number of missing or nonmissing values in computations?
What would you change about your job?
what are some good sas programming practices for processing very large data sets? : Sas programming
what is hierarchy flattening? : Sas-di
What are all the problems you faced while validating tables and reports?
Of all your work, where have you been the most successful?
What commands are used in the case of including or excluding any specific variables in the data set?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How many data types are there in SAS?
how do the in= variables improve the capability of a merge? : Sas programming
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming