Hello,
I have question on what does "Randomly selected matched controls (matched 5:1 on age, gender, geographic region, and year)" means and how to get that data by programming?
Thank you in advance!
... View more
I want to flag the below criteria. A given day involved a diagnosis or an imaging procedure, and look for up to 10 days after the given day and search for the same body-site or type of injury. If so, we will connect the days of the two sets of records. Using the latter-day as the reference, and we will repeat the procedure until we no longer observed a subsequent day with relevant diagnosis code within a 10-day window. Thank you for the help!
... View more
Hi @usuario_estudo, I didn't followed the question fully but here is an attempt. data have;
input ID Flag;
datalines;
1000 2
1000 1
1000 9
1000 1
1000 5
1000 1
1000 1
1000 1
1000 1
2000 11
2000 12
2000 4
2000 1
2000 1
2000 3
2000 1
2000 1
2000 1
;
run;
proc sort data=have out=new;
by ID descending Flag;
run;
data want;
set new;
by ID;
if last.ID then output;
run;
... View more
Hi @Terekhin Is this what you are trying to do? data first_data;
input st $ date date9. ;
attrib date format=date9.;
datalines;
POMPLE 28FEB2017
POMPLE 28FEB2017
POMPLE 01MAR2017
POMPLE 01MAR2017
POMPLE 02MAR2017
POMPLE 02MAR2017
MINR 28FEB2017
MINR 02MAR2017
;
run;
data sec_data;
input st $ name $;
datalines;
POMPLE ANNA
MINR GERRY
;
run;
proc sort data=first_data;
by st;
run;
proc sort data=sec_data;
by st;
run;
data merges_clon;
merge first_data(in=a where=(st="POMPLE" and date<"01MAR2017"d)) sec_data(in=b);
by st;
run;
... View more
Hi @dera, Try sorting id in ascending and col1 in descending order. Check the given sas code. proc sort data=have out=new;
by id descending col1;
run;
proc transpose data=new out=want prefix=variable;
by id;
var col1;
run;
... View more
Hi @AMMAN I am not understanding what exactly you are looking for but here is an attempt. data want;
set have(drop=Items);
by Transaction;
if first.Transaction then count=0;
count+1;
if last.Transaction then output;
run;
... View more
Hi @shadab044, I agree with Reeza. You need to invoke the library you created every-time when you start you sas code in VM. Also can you please provide your code and error.
... View more
data want;
set have;
Item_combined=strip(tranwrd(catx(", ",Item1, Item2, Item3),"",""));
drop Item1-Item3;
run; Hi @altijani, Try this sas code.
... View more
I understood what you were saying. The missing part was, you created new dataset "w1" after transpose which does not included variable infusion_1-infusion_4 and I was also asked to create another output table(apart from the output I asked in the question) which contains total diag count during different number of infusions which I was unable to as dataset w1 has repeated rand_id due to transpose. But in the end I figured out. I used proc transpose method only and merged the new transposed dataset to original one by rand_id which I can use to generate different output tables with different variables. Thank you so much for your help. 🙂 Is there a way I can get in touch with you? @novinosrin
... View more
