About michtka

michtka · ‎01-30-2013

Many thanks Anca tilea for your help.

michtka · ‎01-30-2013

freq (2nd column) I want to add: 2, 5, 7, 9, 10 , 11, 12, 13, 14, 15, 16, 17, 18, 19 ...but not manually, I would like to add in general the freqs that have missing values for both treatments _1 and _2. Thanks.

michtka · ‎01-30-2013

Hi all, I am trying to run this code, and the idea is adding the rest of frequencies that are not appearing in my final output *. I try with completypes but it does not work for this example. Any help? data new; input freq count treat; datalines; 1 2 1 3 4 1 4 2 1 6 3 1 20 1 1 1 2 2 4 3 2 8 4 2 21 2 2 ; run; proc sort data=new out=news; by freq; run; proc transpose data=news out=newt (drop=_name_); by freq; id treat; var count; run; proc summary data=newt nway completetypes; class freq; output out=want (drop=_type_ _freq_) idgroup(out(_1 _2)=); run; proc print data=want; run; *output: Obs freq _1 _2 1 1 2 2 2 3 4 . 3 4 2 3 4 6 3 . 5 8 . 4 6 20 1 . 7 21 . 2 Thanks, V

michtka · ‎01-30-2013

Brilliant, Thanks!

michtka · ‎01-25-2013

Thank you Jagadishkatam!

michtka · ‎01-15-2013

I guys, I would like to only keep the VISIT record 14JAN2009 as record imputed to the Adverse Event (START: 07JAN2009, STOP: 07JAN2009) because is the record after the STOP of this Adverse Event , but i am not interested in keep any more days, i.e VISIT day 22FEB2009...because only I am interested in the record after the STOP date of the Adverse Event. Any help? Thanks. Please find the code below: data AE; informat START date9. STOP date9.; input SUBJID START STOP; format START STOP date9.; cards; 1 7JAN2009 07JAN2009 run; data ASSIGNED; informat VISIT date9.; input SUBJID VISIT; format VISIT date9.; cards; 1 02APR2008 1 07APR2008 1 12MAY2008 1 30JUN2008 1 20OCT2008 1 01DEC2008 1 22FEB2009 1 14JAN2009 2 27NOV2008 2 08DEC2008 2 22DEC2008 2 30JAN2009 *I start assigned the possibles VISITS to to this Adverse Event; run; PROC SQL; CREATE table temp AS SELECT a.SUBJID, ae.START, ae.STOP, a.visit , case when a.VISIT BETWEEN ae.START AND ae.STOP then 1 else 0 end as flag FROM ae LEFT join ASSIGNED a ON ae.SUBJID=a.SUBJID ORDER BY a.SUBJID,a.visit ; QUIT; *I start selecting the only visits after the Stop of adverse events...now I get stuck after this point...; *Thanks in advance; data tempFILTER; set temp; LAGSTOP=LAG(STOP); LAGVISIT=LAG(VISIT); if (flag=1) or (subjid=lag(subjid) and START=STOP and VISIT GT STOP ) then output=1; else output=0; run;

michtka · ‎01-11-2013

...adding extra variables (x1 x2) using LAG function is an option. data have2; set have; x1=lag(start); x2=lag(stop); output; run; data want; set have2; if visit > stop and (x1 or x2) ne . then do; start=x1; stop=x2; end; run;

michtka · ‎01-11-2013

Hi everyone, I need to imputed the next VISIT record (only the next one) using LOCF when the AE stop, i.e VISIT 01DEC2008 for subject1 and VISIT 30JAN2009 for subject 2, tha at the moment are missing. data have; informat VISIT date9. START date9. STOP date9.; input SUBJID VISIT START STOP; format VISIT date9. START date9. STOP date9.; cards; 1 02APR2008 07NOV2008 26NOV2008 1 07APR2008 07NOV2008 26NOV2008 1 12MAY2008 07NOV2008 26NOV2008 1 19MAY2008 07NOV2008 26NOV2008 1 30JUN2008 07NOV2008 26NOV2008 1 01JUL2008 07NOV2008 26NOV2008 1 07JUL2008 07NOV2008 26NOV2008 1 07AUG2008 07NOV2008 26NOV2008 1 29SEP2008 07NOV2008 26NOV2008 1 13OCT2008 07NOV2008 26NOV2008 1 20OCT2008 07NOV2008 26NOV2008 1 01DEC2008 . . 1 22FEB2009 . . 2 27NOV2008 06DEC2008 01JAN2009 2 08DEC2008 06DEC2008 01JAN2009 2 22DEC2008 06DEC2008 01JAN2009 2 30JAN2009 . . 2 30MAR2009 . . ; run; Thanks, Vi. . .

michtka · ‎01-11-2013

adding a LAG period of 30 to the ae.STOP can help, but is not like i really want, I only want to get the next visit. Any ideas? Thanks. PROC SQL; CREATE table want AS SELECT ae.SUBJID, ae.START, ae.STOP, ASSIGNED.visit FROM ae LEFT join ASSIGNED a ON ae.SUBJID=a.SUBJID AND a.VISIT BETWEEN ae.START AND ae.STOP + 30; QUIT;

michtka · ‎01-10-2013

Hi guys, i've got the next problem, I need to assigned the AE of subjects 1 and 2 given by the dataset AE, with the VISIT records given by the dataset ASSIGNED. I am doing PROC SQL to assigned most of the VISITS, but there are two specific VISITS that I want to include in the AE that I cant get and I need too. fist one (01DEC2008): I explain why... The last VISIT in my final dataset SORTWANT (see final result obtained using PROC PRINT) is 20OCT2008, but because the AE for this subject stop the 26NOV2008, I would like extend this AE until the next record 01DEC2008. second one (20JAN2009):...the same history... The last VISIT in my final dataset is 22DEC2008, but because the AE for this subject 2 stop the 01JAN2009, I would like extend this AE until the next record 20JAN2009. Then, the question is: Anyway to get this two extra imputed VISITS: (01DEC2008) and (20JAN2009) in my final dataset SORTWANT? Thnaks, V. data AE; informat START date9. STOP date9.; input SUBJID START STOP; format START STOP date9.; cards; 1 07APR2008 26NOV2008 2 06DEC2008 01JAN2009 run; data ASSIGNED; informat VISIT date9.; input SUBJID VISIT; format VISIT date9.; cards; 1 02APR2008 1 07APR2008 1 12MAY2008 1 19MAY2008 1 30JUN2008 1 01JUL2008 1 07JUL2008 1 07AUG2008 1 29SEP2008 1 13OCT2008 1 20OCT2008 1 01DEC2008 *IMPUTED VISIT THAT I AM INTERESTED TO INCLUDED IN MY FINAL DATASET SORTWANT; 1 22FEB2009 2 27NOV2008 2 08DEC2008 2 22DEC2008 2 20JAN2009 *IMPUTED VISIT THAT I AM INTERESTED TO INCLUDED IN MY FINAL DATASET SORTWANT; run; PROC SQL; CREATE table want AS SELECT ae.SUBJID, ae.START, ae.STOP, ASSIGNED.visit FROM ae LEFT join ASSIGNED a ON ae.SUBJID=a.SUBJID AND a.VISIT BETWEEN ae.START AND ae.STOP; QUIT; PROC SORT data=want out=sortwant; by SUBJID VISIT; RUN; PROC PRINT data=sortwant NOOBS; RUN; The Result obtained is: SUBJID START STOP VISIT 1 07APR2008 26NOV2008 07APR2008 1 07APR2008 26NOV2008 12MAY2008 1 07APR2008 26NOV2008 19MAY2008 1 07APR2008 26NOV2008 30JUN2008 1 07APR2008 26NOV2008 01JUL2008 1 07APR2008 26NOV2008 07JUL2008 1 07APR2008 26NOV2008 07AUG2008 1 07APR2008 26NOV2008 29SEP2008 1 07APR2008 26NOV2008 13OCT2008 1 07APR2008 26NOV2008 20OCT2008 *last visit subject 1; 2 06DEC2008 01JAN2009 08DEC2008 2 06DEC2008 01JAN2009 22DEC2008 *last visit subject 2;

michtka · ‎01-10-2013

Hi guys, I got the next problem: *Because I dont have AE collected by day (colldate) in the dataset ae, we need to assign AE to the collection date (colldate) from a dataset called drugs; 1) in the below code I can assign the AE: start AE (aefdate) <= colldate and stop AE (aetdate) <= colldate proc sql noprint; create table symptomx as select ae.pid, ae.aefdate,ae.aetdate, ae.prefcode, ae.preftext, ae.aercaus,ae.aecaus, a.colldate, a.factdat,a.lactdat,a.cpevent,a.visit from ae left join drugs a on ae.pid=a.pid and ae.aefdate le a.colldate le ae.aetdate; quit; 2) My problem is that I need to assign also AEs that stop before the colldate, i.e the condition ae.aetdate le a.colldate Is possible to add this extra condition to the above proc sql code, or I need to create another proc sql table? Thnaks. V.

michtka · ‎01-03-2013

Yes, Carla Wilson your inference was right, my real problem was a bigger data set. My apologize Sr. Arthur for being simplistic in my post. Anyway, Thanks for your help guys.

michtka · ‎01-03-2013

Thanks cwilson, nice one.

michtka · ‎01-03-2013

Genius! Thanks.

michtka · ‎01-03-2013

Hi everyone, and happy new year! They are some ways to add the records var=0 in visit=2 and visit=4 when order=1 is missing to my have dataset? data have; input visit order var; datalines; 0 1 1 0 2 3 1 1 3 1 2 4 2 2 2 3 1 4 3 2 5 4 2 6 ; run; Cheers V.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

HR interpretation for 3 different scenarios

get then minimum value when you have missing values

Re: macro (Warning:apparent symbol not resolved)

Re: macro (Warning:apparent symbol not resolved)

macro (Warning:apparent symbol not resolved)

Re: show row with missing data in a summary table

Re: code more efficient

Re: removing leading zeros of a character variable

Index where if

Re: multimacrovariables in sql

Re: sorting dataset descending frequency

Re: proc sql instead of proc sort nodupkey

Re: adding categories to the variable frequency (completetypes)

Re: adding categories to the variable frequency (completetypes)

adding categories to the variable frequency (completetypes)

Re: Imputed days after an adverse event stop

Re: Imputed days after an adverse event stop

Imputed days after an adverse event stop

Re: Imputing next visit using LOCF

Imputing next visit using LOCF

Re: ASSIGNING ADVERSE EVENTS TO VISITS (ADDING 2 IMPUTED DAYS)

ASSIGNING ADVERSE EVENTS TO VISITS (ADDING 2 IMPUTED DAYS)

add two conditions in proc sql

Re: add missing records to the dataset

Re: add missing records to the dataset

Re: add missing records to the dataset

add missing records to the dataset