Answer / shambhu kumar verma

Proc Sort data = AAA;
by section descending score;
run;

Data BBB;
set AAA;
by section;
if first.section;
run;

Answer / aloor

proq sql;
Select * from class where score =(select max(score) from
class);
quit;

what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,

---

What is the role of sas grid administrator? : sas-grid-administration

1 Answers  

---

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

---

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

8 Answers   Verinon Technology Solutions,

---

If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 Answers  

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

1 Answers   L&T,

---

how many data types in sas? : Sas-administrator

1 Answers  

---

sas macros

12 Answers   TCS,

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers  

---

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

7 Answers   Accenture,

---

What is the basic structure of the SAS base program?

1 Answers  

---

How to create a permanent sas data set?

1 Answers  

---