id date 1 01/01/2005 2 01/02/2006 3 01/01/2007   I want to delete any observation after 10/01/2006   output   id date 1 01/01/2005 2 01/02/2006 ... View more

I have multiple datasets, I want to run the same code for each and then combine them in one dataset. Can do that in one step?    data a; set dx_md_01; where name in (druga, drugb, drugc); run;    data b; set dx_md_02; where name in (druga, drugb, drugc); run;    data c; set dx_md_03; where name in (druga, drugb, drugc); run;   proc append base= a data=b;run; proc append base= a data=c;run;   ... View more

I have the following data  id start end 1 1/1/2005 2/2/2005 1 2/2/2005 3/3/2005 1 4/4/2005 5/5/2005 2 1/2/2005 2/2/2005 2 2/2/2006 3/3/2006 2 3/3/2006 4/4/2006 I want to define continuous enrollment allowing a gap of 31 days. output  id start end 1 1/1/2005 5/5/2005 2 1/2/2005 2/2/2005 2 2/2/2006 4/4/2006 ... View more

Hi, I have multiple subst statements and I want to run them all at once. Can some one help on the best way to combine all these statements in once (I have 30+ statements)    data a (drop=i); set b; array {x} dx:; ar=1=0; do i=1 to dim(x); if substrn(x{i}, 1, 5) in ('12345', '23456', '30987') then do; ar=1; leave; end; end; run;    data a (drop=i); set b; array {x} dx:; arf=1=0; do i=1 to dim(x); if substrn(x{i}, 1, 4) in ('1234', '2432', '3987') then do; arf=1; leave; end; end; run;  data a (drop=i); set b; array {x} dx:; ad=1=0; do i=1 to dim(x); if substrn(x{i}, 1, 2) in ('12', '24', '39') then do; ad=1; leave; end; end; run;  ... View more

I have the following data;   id date dx a b c d e f g 1 1/1/2005 4 1 0 0 0 0 0 0 1 2/2/2005 5 0 0 0 0 0 0 0 1 3/3/2006 3 0 1 0 0 0 0 0 2 1/2/2005 4 1 0 0 0 0 0 0 2 2/3/2008 2 0 0 0 0 0 0 0 2 3/3/2005 3 0 1 0 0 0 0 0 2 3/3/2005 6 0 0 0 0 1 0 0     Here is the output I want id a b c d e f g 1 1 1 0 0 0 0 0 2 1 1 0 0 1 0 0 so if the id has any (1) then output 1 for that variable regardless of the date if none then zero.    ... View more

i I have a dataset of 1000 observation. I want to enter a fixed date that applies to all observations id  1 2 3 4   output date id date1 1  01/01/2012 2  01/01/2012 3  01/01/2012 4  01/01/2012  ... View more