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;

what is hierarchy flattening? : Sas-di

1039

---

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1286

---

What is the basic syntax of a sas program?

1155

---

What are the different types of sas functions?

1198

---

How can you create a macro variable with in data step? : sas-macro

1002

---

How do you test for missing values?

1580

---

What are the uses of sas?

1186

---

explain the difference between proc means and proc summary?

1075

---

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1118

---

Why and when do you use proc sql?

1194

---

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

1030

---

How many ways to overcome a missing values???

2766

---

is data integration and etl programming is same? : Sas-di

1018

---

Briefly explain input and put function?

1041

---

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

2700

---