Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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.

Question Posted / 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

Mention the category in which sas informats are placed?

0 Answers  

How do you debug and test your SAS programs?

0 Answers   Quintiles,

if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,

How can I remove header from output data set?

0 Answers  

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

0 Answers  

Name any two sas spawners? : sas-grid-administration

0 Answers  

how does sas handle missing values in an update? : Sas programming

1 Answers  

How would you delete observations with duplicate keys?

13 Answers   Accenture,

I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 Answers  

how does sas handle missing values in functions? : Sas programming

0 Answers  

How do you debug macros?

3 Answers   Accenture,

how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,

For more SAS Interview Questions Click Here
Categories