Answer Posted / basha

just i imagine data in data base is;
like below output dataset:
data rating;
input name $ a b c d e f;
cards;
raj 1 54 21 5 7 2
jar 2 21 54 67 3 5
;
answer:

proc sort data=rating;
by name;
run;
proc transpose data=rating out=marks(rename=(col1=marks
_name_=subjects) drop=_label_);
by name;
run;
proc sort data=marks;
by descending marks name;
run;
data jj;
set marks;
by name;
if first.name then ind=0;
ind+1;
run;
proc print;
where ind in(1,2);
run;

What is the command used to find missing values?

1107

---

How is character variable converted into numeric variable and vice versa?

1182

---

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2378

---

explain about data integrator metadata reports? : Sas-di

1113

---

To what type of programms have you used scratch macros?

2573

---

Give e an example of..

2346

---

Tell e how how dealt with..

2255

---

Explain data step in SAS

1107

---

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1202

---

What is PDV?

1162

---

Which date function advances a date, time or datetime value by a given interval?

1157

---

what is SAS OPTIMIZATION?

2302

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2936

---

What commands are used in the case of including or excluding any specific variables in the data set?

1098

---

How do you debug and test your SAS programs?

1566

---