I have 2 datasets one has subject with start_date and other with subject with few missing first drug date.
I want to get the start_date of first dataset if my second dataset first drug date is missing(only if missing), else use the same one.
can any one help me in this. i am using the below code but not wiorking
proc sql; create table subj_dose2 as select distinct trl_id , subj_id ,src_start_dt from ddm.subj_comp_dos where topic_cd in ("BIASP") and dose > 0 order by trl_id , subj_id ,src_start_dt; quit;
proc sort data=ddm.subj out=subj_tmp; by trl_id subj_id; run;
***Update exposed flag in ddm.subj***; data subj(drop=src_start_dt); merge subj_tmp(in=subj) subj_dose2(in=dose2); by trl_id subj_id; if subj; if fdrg_dt ne . then do; rename src_start_dt=fdrg; end; run;
... View more
I have a variable which has format $TDRUG41. and informat $41.
i want to filter
data ind; set girdata; if drug_id="DRUG 2"; run;
Somehow this is not working. Can anyone help me.
... View more
I want to create a line which should say if i do not have a record named 'Missing variable ' i need to create it and assign values as 0 and if present leave as it is.
Can anyone help me in this.
... View more
I am sorry for confusing you.
I had written the following code but it is not working.-
proc sql; create table stat102 as select b.trialtrt, "Missing" as descr2 length=40, count(distinct a.subj_id) as cou, "MDRD eGFR" as descr1 length=40, 10 as sort1, 2 as mdrdsort, "Y" as calcpct from egfr08 a full outer join egfr03 b on a.subj_id = b.subj_id group by b.trialtrt ;quit;
... View more
Output should have
TRT1 TRT2
Missing N (number) N(number)
one dataset has 54 subjects and other has 55.
I want to get missing as 1 for trt1(for suppose)
... View more
I have 2 datasets A and B.
I want to calculate number of missing observations per treatment which are present in B and not A.
I am using
proc sql; create table stat102 as select b.trialtrt, "Missing" as descr2 length=40, count(distinct a.subj_id) as cou, "MDRD eGFR" as descr1 length=40, 10 as sort1, 2 as mdrdsort, "Y" as calcpct from egfr08 a full outer join egfr03 b on a.subj_id = b.subj_id group by b.trialtrt ;quit;
... View more
m sorry as i am new to sas i am still finding it difficult.
what will the above program do and what does deom mean?
I want 2 counts
1)Subjects tested positive at least once during treatment period - N(%)
2) Subjects tested negative at visit 3, but positive during treatment - N(%)
... View more
Hi,
I am sorry. I may be confusing you.
I need Subjects whose values are in negative(ex: -1.334) at visit 3, but positive(ex: 1.23) during treatment and Subjects tested positive(ex: positive values at least once) at least once during treatment period
... View more
I need N (%) for Subjects tested negative at visit 3, but positive during treatment and N (%) Subjects tested positive at least once during treatment period
... View more
I have a dataset which has values from negative and positive.
ex:
subj value visit trt
101 -1.3 3 A
102 2.1 3 A
103 -1.2 3 B
101 3 4 A
102 1 4 B
I want to have number of subjects and percentage who have negative(value) as visit 3 and positive value after visit3. Also another count and percentage of subjects who are postive atleast ones .
Can anyone help me
... View more
