Answer / richa

It can be done by first sorting the dataset in the
ascending order of salary and then using the 'point='
option.

For eg:

proc sort data = x;
by salary;
quit;

/*second highest salary*/
data y;
a = 2;
set x point = a;
stop;
run;

/*fifth highest salary*/
data y;
a = 5;
set x point = a;
stop;
run;

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

1 Answers   GSK,

---

How do dates work in SAS data?

0 Answers  

---

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  

---

i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,

---

What is the basic syntax style in SAS?

0 Answers  

---

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  

---

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers  

---

What is the role of unrestrictive users? : sas-grid-administration

0 Answers  

---

how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,

---

What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,

---

how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,

---

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

---