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...


How to get top scorer student from a class-table having
different sections A,B, C & D? Each section having same
number of students.

Answers were Sorted based on User's Feedback



How to get top scorer student from a class-table having different sections A,B, C & D? Each sec..

Answer / shambhu kumar verma

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

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

Is This Answer Correct ?    5 Yes 0 No

How to get top scorer student from a class-table having different sections A,B, C & D? Each sec..

Answer / aloor

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SAS Interview Questions

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 Answers  


how would you create multiple observations from a single observation? : Sas programming

0 Answers  


what does the run statement do? : Sas programming

0 Answers  


How to do user inputs and command line arguments in SAS? D&B

2 Answers   BoA, Quintiles,


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

0 Answers  


i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,


What are _numeric_ and _character_ and what do they do?

1 Answers   Quintiles,


Which command is used to save logs in the external file?

0 Answers  


what is study design in while working with SAS? what are screening variables in SAS?

0 Answers   MSCR,


What does a PROC TRANSPOSE do?

8 Answers   Accenture,


Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 Answers  


Categories