Answer / venkatesh layam

by using monotonic function u can create first and lastobs

Answer / venkatesh layam

crate one data in sql with adding of new var (a = 1) and
sort(order by) descending order by another variable and
take distinct of a (newvar-which is already created) --then
u wil get last observation.

next do ascending and get first obs ,then union these two
data sets .u will get first and last obs.

Answer / rohitbedi

Create a new data set as below:

data demo;
input year month cpi;
datalines;
1990 6 129.9
1990 7 130.4
1990 8 131.6
1990 9 132.7
1991 4 135.2
1991 5 135.6
1991 6 136.0
1991 7 136.2
;
run;

Sort the data if needed.

Create a new id field:

data demo2;
set demo;
id = _n_;
run;

Display the first and last record for every date and finally remove the id column.

proc sql;
create table final as select * from demo2 where id in (select min(id) from demo2 group by year) or id in (select max(id) from demo2 group by year);
alter table final drop column id;
quit;

Answer / naveen

proc sql;
select first(orderprise)
from xxx;
quit;

how do the in= variables improve the capability of a merge? : Sas programming

0 Answers  

---

Mention the validation tools used in SAS?

0 Answers  

---

Did you used proc test? when?

0 Answers   Accenture, Quintiles,

---

How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?

1 Answers   Student,

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

---

What is the order of evaluation of the following operators + - * / ** () ???

2 Answers  

---

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 Answers  

---

what is the difference btw proc means and proc univariate?

8 Answers   HSBC, TCS,

---

which date functions advances a date time or date/time value by a given interval? : Sas programming

0 Answers  

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.

10 Answers   Accenture,

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  

---

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

---