Answer / shambhu kumar verma

Proc Sort data = AAA;
by section descending score;
run;

Data BBB;
set AAA;
by section;
if first.section;
run;

Answer / aloor

proq sql;
Select * from class where score =(select max(score) from
class);
quit;

What is the role of administrative users? : sas-grid-administration

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,

---

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  

---

what is the basic structure sas administrator? : Sas-administrator

0 Answers  

---

what is change analysis in sas di ? : Sas-di

0 Answers  

---

what is the use of catalog?

1 Answers   Cognizant,

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

0 Answers  

---

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  

---

What is SAS?

0 Answers  

---

What are the functions which are used for character handling functions?

0 Answers  

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.

10 Answers   Accenture,

---

How will you generate test data with no input data?

0 Answers  

---