Hi there,
I have below conmed data which is collected on different dates and i want to calculate the total number of days taken medications from first date to last date per visit.
Subject 16-001 is collected different conmeds on multiple dates hence intermediate dates should not be consider e.g. 1st conmed taken from 17 to 21 may while 2nd 17 to 27 May so 18 to 21 already covered in 2nd record, this should not be re-calculated in number of days. 17-May to 27-May i.e. total number of days are 11 days. for subject 30-003 at WEEK 4 collected on 24 and 29 Jun only so Total number of days will be 2 as conmed not taken from 25 to 28 Jun date.
SUBJID AVISITN AVISIT ASTDT ENDT 16-001 2 BASELINE 17-May-20 21-May-20 16-001 2 BASELINE 17-May-20 27-May-20 16-001 2 BASELINE 21-May-20 21-May-20 16-001 2 BASELINE 22-May-20 22-May-20 16-001 2 BASELINE 23-May-20 23-May-20 16-001 2 BASELINE 23-May-20 27-May-20 16-001 2 BASELINE 24-May-20 24-May-20 16-001 2 BASELINE 25-May-20 26-May-20 30-003 2 BASELINE 27-May-20 27-May-20 30-003 3 WEEK 4 24-Jun-20 24-Jun-20 30-003 3 WEEK 4 29-Jun-20 29-Jun-20 40-008 2 BASELINE 13-Jan-20 13-Jan-20 40-008 2 BASELINE 15-Jan-20 15-Jan-20 40-008 2 BASELINE 17-Jan-20 17-Jan-20 40-008 2 BASELINE 17-Jan-20 17-Jan-20 40-008 2 BASELINE 18-Jan-20 18-Jan-20 40-008 2 BASELINE 19-Jan-20 19-Jan-20 40-008 3 WEEK 4 14-Feb-20 14-Feb-20
Thanks,
Rohit
... View more
If subject recieved 2 Treatment in Period 1 as A and Period as B, so my TRTSEQA should be A-B.
If subject received only 1 treatment that is only in Period 1 as A, So my TRTSEQA shoud be A only?
SUBJECT Period 1 Period 2 TRTSEQP TRTSEQA
101 A B A-B A-B
102 A A-B A
Is this senerio is correct? My TRTSEQA is correct?
Can anyone guide me about TRTSEQA in ADAM?
Require your all needfull suggestions.
Thanks in advance,
Rohit P.
... View more
Can anyone know what is the option used for Escapchar in .LST output?
Actually ODS ESCAPECHAR = "#"; is working in .RTF output, but it is not working on .LST output.
Thanks,
Rohit
... View more
Below is the macro code.......... /****** Macro to convert .XPT files to sas datasets *****************/ options mprint symbolgen mlogic; /******************* Import domain sheet **************/ %MACRO DSAT(DOMAIN=); proc import datafile = "...................../domains.xls" out=&DOMAIN Replace DBMS=xls; getnames=yes; run; /********* Domains sheet contain list of the datasets i.e. ae, dm, ds, eg...... ***********/ PROC SQL; SELECT COUNT(*) INTO :CNT FROM &DOMAIN; QUIT; %PUT &CNT.; %let CNT = %EVAL(&CNT.); PROC SQL; SELECT DISTINCT DATASETS INTO: DATASETS1-:DATASETS&CNT FROM &DOMAIN; QUIT; %DO I=1 %TO &CNT; LIBNAME DT XPORT "............./&&DATASETS&I...xpt"; /**** Path contain .XPT files which we mapped with Domains excel sheet ****/ PROC COPY IN = DT OUT=WORK; RUN; %END; %MEND; %DSAT(DOMAIN=domains); /******** Excel data contains *******/ datasets ae cm dm ds eg ex /************/ while generating the output.... For Some of the datasets the LABEL was lost in output. Can you please let me know the resolution or any other ways to retain the LABEL.
... View more
When i am converting .XPT files to SAS datasets files datasets Labels gets missing. Kindly provide the resolution. Note - Converting bunch of XPT files to SAS datasets through macro.
... View more
Wow thats great. Thank you everyone. i had already tried with Amir code but i wanted in shortest method but its wonderful. Thanks everyone. Regards, Rohit
... View more
Hi ALL, Have - DATA TEST; INPUT SUBJECT $ NUM1 NUM2 NUM3 NUM4 NUM5; DATALINES; A01 . 2 5 36 . B01 65 25 54 . 3 C01 4 . . 4 5 D01 . . 5 4 5 E01 . . . 5 4 RUN; Want - SUBJECT NUM1 NUM2 NUM3 NUM4 NUM5 SUM_NUM A01 43 2 5 36 43 43 B01 65 25 54 147 3 147 C01 4 13 13 4 5 13 D01 14 14 5 4 5 14 E01 9 9 9 5 4 9 The value of SUM_NUM has to be place where you can see ' . ' (dot) Example - For subject A01 NUM1 has dot (.) which replace the value of SUM_NUM. Kindly make sure that there are n number of NUM coloumn. Thanks in Advance. Regards, Rohit
... View more
Hi ALL, i want to split the more than 5 GB data into Excel 97-2003 cversion(67535 records per sheet) sheetwise. Even I am not able to get the count of abservation in the data as dataset size is more than 5 GB. Can anyone help me on this with the running fastest and short code ? Reragds, Rohit
... View more
Hi Ksharp, I am not able to get desire output as i want. i want output as "Average of all visits only for last three subject(group subject)". Thanks Rohit
... View more
Hi, i have tried this simple code to solve this. data have; set have; _date=input(cats(compress(date,'DK'), substr(date,1,3),'2012'), anydtdte21.); format _date mmddyy8.; run; Rohit
... View more
