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 hierarchy flattening? : Sas-di
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
explain about various caches available in data integrator? : Sas-di
what are sas/access and sas/connect? : Sas programming
What are the features of base sas system?
Give an example where SAS fails to convert character value to numeric value automatically?
What are the new features included in the new version of SAS Programming Language?
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?
What are the prime responsibilities of data integration administrator? : Sas-di
What is by-group processing?
How to limit decimal places for variable using proc means?
how to read the variables in sas? : Sas-administrator
Describe the function and untility of the most difficult SAS macro that you have written.
what is the basic structure sas administrator? : Sas-administrator
what is sas metadata repository? : Sas-bi