In a shcool there are 1000 students. After completion of
every test in 6 subjects , each subject teacher submit the
marks of every student at different times and loaded in the
database commonly. How will you seperate the top two
subject marks for each each studet using SAS?
Answer Posted / bakul shah
/*
Bakul Shah
6/May/2009
*/
Data A ;
Array N{6};
Input Name $ N{*} ;
Call SortN(of N{*}); /* Sort for Intergers */
Put @5 Name $ @10 N{6} 3. +2 N{5} 3.;/* 6th and 5th */
DataLines;
David 76 81 65 87 78 98
Manisha 100 91 67 86 87 81
Bob 83 93 76 88 96 72
;
Run;
*;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between where and if statement?
Difference between informat and format?
How necessary is it to be creative in your work?
Explain what is data step?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What would you change about your job?
how does sas handle missing values in procs? : Sas programming
Describe crosslist option in tables statement?
I need level 2 to 5 sas using companies in india
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
what are sas bi dashboard components? : Sas-bi
What are the functions which are used for character handling functions?
What are the parameters of scan function?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?