You should give an example of the data you have and what you want to see.  It's not perfectly clear what you are looking for here. ... View more

This selects the range, including 30 and 33:   data want; set have; where food_type between 30 and 33; run; ... View more

here you go:   data have; infile cards dsd; input customer$     phone$     phonetype $10.; cards; lori,12356,cellphone lori,45623,homephone lori,23687,workphone ; proc transpose data=have out=want (drop=_name_);by customer;id phonetype;var phone; ... View more

This turned into a real crap-fest.  It's not what I would call "easy to look at" but here's a solution:   data want other; do until(last.id); set have; by id age; /*Scenario 1*/ if not first.id then do; if last.age and lag2(age) ne age then birth_month = month; end; /*Scenario 2*/ retain _jan_age; if month = 1 then _jan_age = age; if month = 12 and age = _jan_age then birth_month = month; /*Scenario 4*/ retain _first_id _first_month; if first.id and month ne 1 then _first_month = month; if first.id and month = 1 then _first_month = .; if first.id then _first_id = age; if last.id then _last_id = age; if month = 12 and not missing(_first_month) then Flag = 'Research'; end; /*Roles up birth_month and research to the id level*/ do until(last.id); set have; by id age; if flag = 'Research' or not missing(birth_month) then output want; /*Scenario 3*/ else output other; end; drop _:; run;   ... View more

In that case I think you want to use the solution I provided earlier.  Run that with a subset and see if you get the desired results. ... View more

I'm not sure if you are looking for the word February or the number 2, here's an examle that has both:   data have; input ID       MONTH        AGE; cards; 1         1                  0 1         2                  0 1         3                  1 1         4                  1 1         5                  1 1         6                  1 1         7                  1 1         8                  1 1         9                  1 1        10                  1 1        11                  1 1        12                  1 ; proc format;  value new   1 = 'January'               2 = 'February'              3 = 'March'              4 = 'April'              5 = 'May'              6 = 'June'              7 = 'July'              8 = 'August'              9 = 'September'             10 = 'October'             11 = 'November'             12 = 'December'     ; data want; set have; by id age; if last.age and age = 0 then do; Birth_Month = month; Month_Birth = month; format birth_month new.; end; run; ... View more

There's a few ways to do this, it's best to give an example of the data you have and what you want to see.  Here's one solution:   data have; input variable; cards; 1 1 1 2 3 4 5 ; data dup nodup; do until(last.variable); set have; by variable; count + 1; if first.variable then count = 1; if count > 1 then dup = 'Y'; end; do until(last.variable); set have; by variable; if dup = 'Y' then output dup; else output nodup; end; run; ... View more

Transpose will work:   data have; input var1 var2 var3; cards; 3165 73 309 ; proc transpose data=have out=want;var var:;   If the variables are numeric you do not need the var statement.  ... View more

I would write the same thing like this to prevent error in syntax:   data new_eligible; merge work.eligible (in=new)             reference1    (in=ref keep=PRAMSFileNo); by PRAMSFileNo; if new and not ref;    run;    BUT, I think you would be better off giving example data and an example of the desired output.  You can possibly learn a completely different and possibly better way to get what you are looking for. ... View more