The problem is 'if level = 2 or 3'  The answer to this is always yes. data chk_10; input sno name $ level; if level = . then exp = 'unknown'; else if level = 1 then exp = 'low'; else if level = 2 or level = 3 then exp = 'medium'; else exp = 'high'; datalines; 1 Frank 1 2 John 2 3 sui 2 4 sose 1 5 burt 4 6 kelly . 7 juan 1 ; run; Another way would be to put if level > 3 then exp = 'high'; ... View more

DATA have; informat minute time.; format minute time.; infile cards dsd; input Minute value; cards; 12:14,1 12:15,7 12:18,9 12:19,4 ; run; proc expand data=have out=want from=minute to=minute observed=end method=none;     id minute; run; ... View more

Because you are generating the variable address in this same step your where clause will not work, you should use having instead.  I made some other minor changes that I think will help as well: DATA have; infile cards dsd; length addr1 addr2 $10.; input addr1$ addr2$ name1$ name2$ dob phone phone2; cards; po box 935,lola park,bob,smith,20051201,412,5551212 ; run; proc sql; create table want as select catx(' ',addr1,addr2) as address,name1,name2,dob,phone,phone2 from have having upcase(address) like '%PO BOX 935 LOLA PARK%'; ... View more

Here is a solution for user C. data have; infile cards; informat user $1. stdate enddate visit6dt visit9dt yymmdd10.; format user $1. stdate enddate visit6dt visit9dt mmddyy10.; input User$ stdate enddate visit6dt visit9dt; cards; A               2013-10-25                      2013-11-16                 2013-10-25                    2014-01-25 B               2013-02-01                      2013-04-21                 2013-03-10                    2013-06-10 C               2013-09-01                      2013-09                    2013-09-10                    2013-12-01 ; data prep; set have; output; if missing(enddate) then do;     enddate = visit6dt-1;output;     enddate = visit6dt;output;     enddate = intnx('month',stdate,0,'e');output;     enddate = visit9dt;output; end; run; data want; set prep; if missing(enddate) then delete; run; ... View more

I do not know Rstudio but if you give a sample of data you have and what you are trying to do I can try to help. ... View more