Interested to Buy Any Domain ? << Click Here >> for more details...
How to get second top scorer student from a class- table
having different sections A, B, C & D? each section has same
number of student.
- 4 Answers
- 8720 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chandu
DATA ONR;
INPUT
@1 a
@3 b
@5 c
@7 d
;
SUM_VALUE =SUM (A, B, C, D);
RUN;
PROC SORT DATA=ONE NODUPKEY;
BY SUM_VALUE;
RUN;
DATA ONE_RESULT;
SET SUM;
IF _N_ = 2 THEN OUTPUT;
RUN;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Tell me about % include and % eval? : sas-macro
what can you learn from the sas log when debugging? : Sas programming
What sas features do you use to check errors and data validation?
Give an example where SAS fails to convert character value to numeric value automatically?
AE datasets names? how many types?
What can be the size of largest dataset in SAS?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What commands are used in the case of including or excluding any specific variables in the data set?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Explain the main difference between the sas procedures and functions? : Sas-administrator
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what is transformation in sas data integration? : Sas-di
how to remove duplicates using proc sql?
