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.



Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output..

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

Post New Answer

More SAS Interview Questions

Briefly explain input and put function?

0 Answers  


How do you add a number to a macro variable?

2 Answers  


How sas treats the dsd delimiters?

0 Answers  


code the tables statement for a single level frequency?

2 Answers  


What is the good sas programming practices for processing large data sets?

0 Answers  






How do you specify the number of iterations and specific condition within a single do loop?

0 Answers  


what are some good sas programming practices for processing very large data sets? : Sas programming

0 Answers  


What are the table names in oracle database...?

0 Answers   HSBC,


Name types of category in which SAS Informats are placed?

0 Answers  


Can you execute macro within another macro? : sas-macro

0 Answers  


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

0 Answers  


What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, ASD Lab, CitiGroup,


Categories