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
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 |
Answer / aloor
proq sql;
Select * from class where score =(select max(score) from
class);
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
how would you create multiple observations from a single observation? : Sas programming
what does the run statement do? : Sas programming
How to do user inputs and command line arguments in SAS? D&B
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
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
What are _numeric_ and _character_ and what do they do?
Which command is used to save logs in the external file?
what is study design in while working with SAS? what are screening variables in SAS?
What does a PROC TRANSPOSE do?
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?