Answer Posted / 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;

Explain what is the use of proc gplot?

1185

---

do you need to know if there are any missing values? : Sas programming

1044

---

What is the basic syntax style in SAS?

1157

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2240

---

What function CATX syntax does?

1207

---

what is the Population you used in your project, is it ITT or PP?

2736

---

which features do you use to check the data validations and errors? : Sas-administrator

1044

---

How do dates work in SAS data?

1165

---

What was the last computer book you purchased? Why?

2369

---

Explain input and put function?

1132

---

How does the internal authentication work in sas? : sas-grid-administration

1113

---

which date function advances a date, time or datetime value by a given interval? : Sas programming

1037

---

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

1277

---

What is the basic structure of the SAS base program?

1310

---

how sas deals with business intelligence? : Sas-bi

1050

---