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 / 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 |
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
what is the basic structure sas administrator? : Sas-administrator
What is the difference between SAS functions and procedures?
How to limit decimal places for variable using proc means?
what is sas olap server? : Sas-di
What other SAS features do you use for error trapping and data validation?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
what is the use of catalog?
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
How do you connect the desktop application to metadata server? : sas-grid-administration