Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 4385 Views
- I also Faced
- E-Mail Answers
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 |
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
Where do you use proc means over proc freq?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
how to read character value without using substr function in sas ?
How would you code the criteria to restrict the output to be produced?
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
How would you code a merge that will keep only the observations that have matches from both sets?
what is operational data and operational system? : Sas-di
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
Tell e how how dealt with..
Teradata 
