Hi,   Can you please provide me dataset rank_mtcars. I am not able to find it anywhere.   Thanks!! Vijay ... View more

Using Drop C is the main trick here. What is does is it will drop that column when creating dataset. Try this Data ratings1; set ratings(drop = C); run;   Ratings1 will have all variable apart from C.   Retain C. What this statement does it, 1 it will not reinitialize value of C to missing on reading new observation, 2 remember value from previous obsevration.   Try reading some sas paper for more on retain statement, it pretty powerful statement.   put first.id last.id;   well this statement is not needed, I was just trying out something. You can remove this statement and program will work just fine. Main purpose of put is in debugging, it will write/print values in log for reach observation.               ... View more

Hi Lamia,   This is quite interestting. To me it looks like as C variable is in orignal data set, so code that you have written is not working. Everytime row is getting read of rating dataset C is getting assigned 0. Here is how we can get around it.   data ratings1; set ratings(drop=c); retain c; if first.id then c=0; put first.id last.id; by id notsorted; c+j1; run; ... View more

I am very new to SAS. Base SAS we can do with datastep. But how can we do it with Proc SQL?? ... View more