Answer / solasa

You can use aggregate (or summary) functions to summarize
the data in your tables. These functions can act on
multiple columns in a row or on a single column across rows.

Avg average of values •
NMiss number of missing values
Count number of non-missing values
• Prt probability of a greater absolute value of Student’s t
. CSS corrected sum of squares.
Freq (same as Count)
Nmiss,STDERR,MEan,Min,MAx etc


use this link:
http://www2.sas.com/proceedings/sugi30/257-30.pdf.


from
Solasa
solasa@in.com

Answer / singh.naveen409@gmail.com

There are some various kinds of aggregate functions, which
we have
like**************

AVG()=Average
COUNT()=Numbers of rows
FIRST()=First value
LAST()=Last Value
MAX()=Maximum value from rows
MIN()=Minimum Value from rows
SUM()=Total

Aggregate function which use to visualize the answer in
single value from tables value.

And Aggregate function use in sql with "HAVING" and where
condition.

Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?

1 Answers   HCL,

---

%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 Answers  

---

How would you remove a format that has been permanently associated with a variables?

3 Answers  

---

What is the difference between reading data from an external file and reading data from an existing data set?

0 Answers  

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  

---

Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.

4 Answers   Symphony,

---

What does a PROC TRANSPOSE do?

8 Answers   Accenture,

---

How many data types are there in SAS?

0 Answers  

---

what is pdv? how it is related to input buffer in sas?

5 Answers   HSBC, Satyam,

---

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,

---

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,

---

What is the difference between a PROC step and a DATA step?

14 Answers   Accenture, HSBC,

---