another try:    proc sql; create table want as select a.ID1 as ID1, COALESCE(a.ID2,b.ID2) as ID2 from have a left join (select distinct ID1,ID2 from have where ID2 IS NOT MISSING) b ON a.ID1=b.ID1; quit; ... View more

you may use this also: data want; set have; CEO_dummy=IFN(index(upcase(role),'CEO'),1,0); INDEPENDENT_dummy=IFN(index(upcase(role),'INDEPENDENT'),1,0); run; via sql: proc sql; create table want as select role, case when index(upcase(role),'CEO') then 1 else 0 end as CEO_dummy, case when index(upcase(role),'INDEPENDENT') then 1 else 0 end as INDEPENDENT_dummy from have; quit; ... View more

try this , if your data is not already sorted then you may have to sort it: data have; input month      year      ATC      nb_remb; cards; 1             2006          1      1234 1             2006          2      3456 1             2006          3      7890 1             2006          5      9876 ; data want; set have; by atc; if dif(atc)>1 then do; month=month;year=year;atc=atc-1;nb_remb=0; output; set have point=_N_;output; end; else output; run; ... View more

data have; input name $ score; datalines; a 1 a 2 a 3 a . a 1 b 2 b . b 4 c . c 1 c 4 ; run; proc sql; select distinct name, case  when name in (select distinct name from have where score=1) then 'yes' else 'no' end as yesno  from have; quit; ... View more

data want(drop=line); infile datalines truncover; input line $1000.; obs=scan(line,1,' '); road =substr(substr(line,length(scan(line,1,' '))+1),1,index(substr(line,length(scan(line,1,' '))+1),scan(line,-2,' '))-1); paint=scan(line,-2,' '); bright=scan(line,-1,' '); datalines; 1 Center St. 1 43 2 Broadway 1 46 3 Main St. 1 47 4 Main St. 3 54 5 Elm St. 1 55 6 Station Rd. 1 56 7 Center St. 1 59 8 Center St. 4 61 9 Main St. 3 62 10 Center St. 4 62 11 Park Dr. 3 63 12 Main St. 2 64 13 Park Dr. 1 64 14 Broadway 4 64 15 Broadway 2 64 16 Broadway 3 65 17 Station Rd. 3 67 18 Station Rd. 3 67 19 Elm St. 3 68 20 Beech St. 4 71 21 Elm St. 4 72 22 Beech St. 2 75 23 Beech St. 4 75 24 Beech St. 2 76 25 Park Dr. 4 77 26 Elm St. 2 79 27 Station Rd. 2 79 28 Park Dr. 2 84 ; run; ... View more

it should be if anyalpha(zip)=1; 1 is for if zip starts with character value. ... View more

there are actually two data steps used in the code, in second datastep you can set your dataset, ignore the previous data set with datalines. ... View more

this link also serve the same purpose http://blogs.sas.com/content/sasdummy/2011/05/09/calculating-the-number-of-working-days-between-two-dates/ just few modification were needed to get your desired output. ... View more

Hi It would have been lot more simpler if you had provided this in begining, while you created the post, we were counting no of weekend days and your requirement if no of days without weekends: you might have done this with little changes to the code provided earlier: data have; input dateid orderdate date9. deliverydate :date9.; format orderdate deliverydate date9.; datalines; 1 22MAR2014      24MAR2014 2 23MAR2014      25MAR2014 3 21MAR2014      24MAR2014 4 20MAR2014      25MAR2014 5 23MAR2014      26MAR2014 ; data want(drop=i); set have; DesiredOutputTotalDays=0; CurrentTotalDays=0; do i=orderdate to deliverydate; if weekday(i) not in (1,7) then DesiredOutputTotalDays+1; CurrentTotalDays+1; end; by dateid; if last.dateid then output; put (orderdate deliverydate CurrentTotalDays DesiredOutputTotalDays)(=); run; orderdate=22MAR2014 deliverydate=24MAR2014 CurrentTotalDays=3 DesiredOutputTotalDays=1 orderdate=23MAR2014 deliverydate=25MAR2014 CurrentTotalDays=3 DesiredOutputTotalDays=2 orderdate=21MAR2014 deliverydate=24MAR2014 CurrentTotalDays=4 DesiredOutputTotalDays=2 orderdate=20MAR2014 deliverydate=25MAR2014 CurrentTotalDays=6 DesiredOutputTotalDays=4 orderdate=23MAR2014 deliverydate=26MAR2014 CurrentTotalDays=4 DesiredOutputTotalDays=3 ... View more