About sam369

sam369 · ‎01-13-2015

TThank you ksharp!!! now I got the relative risk and 95% ci but how to calculate ARR(absolute relative reduced)? expected result for arr: .03 (-.07,0.12) thanks sam

sam369 · ‎01-13-2015

Hi Reeza, i tried both but haven't got the solution thanks sam

sam369 · ‎01-12-2015

Hi All, I have following dataset. i want relative risk & absolute relative reduction? how can i achieve them using procedure? data have; subgrp trt coun; 1 1 72 1 0 8 2 1 74 2 0 6 Want: rr=(72/80)/(74/80)=0.97 ARR is by newcombe aprroach. Output for ARR is : 0.03(-.07,0.12) THanks Sam

sam369 · ‎12-18-2014

Hi All, i have some records with multiple data. i am looking for average for those records, i have numeric and character variables This is the sample , i kept only few records.i have more than 100 variables exampl Data have; Input sub $ cat $ val $ val2(numeric) Cards; 100 one 2.1 2.1 100 one 4.2 4.2 100 two 3.1 3.1 100 two 3.4 3.4 101 one 7.8 9 101 two 3.2 8 want: 100 one 3.15 3.15 100 two 3.25 3.25 101 one 7.8 9 101 two 3.2 8 Thanks Sam

sam369 · ‎11-30-2014

HI Sanjay, i have a question, I am facing issue with forest plot like , align issue example: Study. Odds ratio & 95 ci. OR. LCL. UCL. XXXX -------------#----------- 34.5. 30.9. 42.77 i I used following code layout lattice / column columngutter=0 columnweight=(.5 .3 .2) thanks Sam

sam369 · ‎11-24-2014

Thank you sanjay!!! I took a glance at the above link, i will try it. For Overall , how can i have diamond filled symbol? I mean to say i want only diamond symbol for Overall sub group.? Thanks Sam

sam369 · ‎11-24-2014

Hi Sanjay, Thank you for your quick response !!! this is link: http://blogs.sas.com/content/graphicallyspeaking/files/2012/02/Full-SAS-93-Code.txt this code is with GTL and proc sgplot But i would like to achieve the same plot with GTL+ proc sgrender 2)And for Overall , how do we get the symbol=diamondfilled? Thanks Sam

sam369 · ‎11-24-2014

Hi Sanjay, i am exploring more on forest plot. I am considering few examples from your forum http://blogs.sas.com/content/graphicallyspeaking/?s=forest+plot Example :Figure 12.3: SAS 9.3 Forest Plot: i would like to achieve this kind of plot by using proc template , your example using proc sgplot i am stumped with it!!! any help is greatly helpful for learner like me !!! Thanks Sam

sam369 · ‎11-20-2014

Hi all, I have an increment issue while i am checking some code, i have &trt in macro variable , i want them increment by j , But j value is not incremented in that loop. something is going wrong but unable to figure it out data want; set have; array chk[6] t1-t6;array ct[6] ct1-ct6; %let j=1; do i=1 to 6; ct=(chk/&&trt&j)*100; %let j=%eval(&j+1); end; run; Thanks Sam

sam369 · ‎11-13-2014

Hi Sanjay, Thank so much for your time. I tried with my values but i got hard to fit in it. I dont know how to get the label part fix(control group ,placebo group) find the sample code , data and layout style. Thanks Sam

sam369 · ‎11-12-2014

hi Reeza, the follwoign code is using to get odds ratio and Clopper-Pearson method for CI for response i can use logistic, but dont know how to For odds ratio: ods output RelativeRisks=rr(where=(StudyType eq 'Case-Control (Odds Ratio)')); proc freq data=have; weight count; tables trt*res/chisq relrisk; run; Clopper-Pearson method: proc freq data=ci noprint; tables grp/ binomial alpha = 0.05; by trt ; output binomial out=_ci; run; data final_ci retain ci; set _ci; by trt; lcl = round(100 * (1 - xu_bin),.1); ucl = round(100 * (1 - xl_bin),.1); ci = ' ('||put(lcl,4.1)||', '||put(ucl,4.1)||')'; run; Thanks Sam

sam369 · ‎11-12-2014

Hi all, I have 2 set of question 1) odds ratio using relrisk? have data: trt res COUNT Trt1 1 54 Trt1 2 12 Trt2 1 120 Trt 2 103 i need Odds ratio trt1 over trt2 ? how can i acheive that? 2) i am using Clopper-Pearson method(freq binomial) i got ouput 95CI% trt1 trt2 (19.7, 41.5) (27.9, 40.8) i got query back to me "trt2 group is beyond it point estimate ?, CI look not correct what does that mean Thanks Sam

sam369 · ‎11-08-2014

Hi Keshan, I Am not really familiar with hash.is it possible to have this code in data step or sql thanks sam

sam369 · ‎11-07-2014

Thank you for your Time!!! Yes i am accepting that my first original post is does not have any missing dendt but my real data does!!! In my real data dstdt is not missing but few subjid dendt is missing Thanks Sam

sam369 · ‎11-07-2014

Hi Arthur, we need to stick with the original code itself for example 101 subject dstdt is 11oct2013 and corresponding stdt & endt are "08OCT2013 14OCT2013" it falls under this condition if STDT <= temp1(i) < ENDT then do; if (temp1(i) <= temp2(i) < ENDT) or (temp2(i) >= ENDT) then flg='Y'; end; 08OCT2013<= 11oct2013< 14OCT2013 then do if 11oct2013<=.< 14OCT2013 then flg='Y' so we need to get flg eq 'Y' but we got 'N' Thanks Sam

Online Status	Offline
Date Last Visited	‎01-10-2023 02:21 PM

Re: How to delete some observations in some groups based on a conditio...

Re: retain previous missing visits

retain previous missing visits

Re: How to add duplicates in a new column

Re: flag

flag

Re: pick the closest prior date

Re: pick the closest prior date

Re: pick the closest prior date

pick the closest prior date

Re: pick the closest prior date

Re: if else macro loop

Re: pick the closet value aginst time period

Re: pick the closet value aginst time period

Re: prxmatch

Re: How to add missing data

Re: Fill in the blanks with the previous value

Re: Help with expression or subquery in an SQL JOIN

Re: identifying maximum investment among ??

Re: pick 0 and 1

Re: rel risk & ARR

Re: rel risk & ARR

rel risk & ARR

average

Re: proc template

Re: proc template

Re: proc template

Re: proc template

array macro increment

Re: proc template

Re: relrisk

relrisk

Re: Check the dates in loop

Re: Check the dates in loop

Re: Check the dates in loop