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 |
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
Are you familiar with special input delimiters? How are they used?
Name statements that are execution only?
What are _numeric_ and _character_ and what do they do?
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
How do you debug macros?
What is interleaving in SAS?
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
how does sas handle missing values in functions? : Sas programming
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
If a variable contains letters or special characters, can it be numeric data type?