About linda0910

linda0910 · ‎12-19-2022

Hi all, I need help on SAS callable SUDAAN. Here is the example that I am currently working on. Logistic Example 3.pdf (rti.org) I will need to save the output from the risk ratio. from the the condrisk that line in a sas datafile. (print cond_rr="Risk Ratio" pred_rr="Risk Ratio"/ condrisk=default predrisk=default;) But I am not able to find the variable names. Could you please help me? My codes are the same as in Exhibit 14. Here goes the example. PROC RLOGIST DATA=samadult DESIGN=WR FILETYPE=SAS; NEST STRAT_P PSU_P; WEIGHT WTFA_SA; SUBPOPX AGE_P>24 AND MRACRPI2=1 / NAME="WHITES AGED 25+"; CLASS SEX AGE25_3 EDUC_3 REGION MARRY_3; REFLEVEL SEX=1 REGION=1 MARRY_3=1; MODEL CANTAFMEDS = SEX AGE25_3 EDUC_3 REGION MARRY_3; EFFECTS AGE25_3 = (1 -1 0) / exp name="AGE: 25-44 vs. 45-64"; CONDMARG AGE25_3 / adjrr; PREDMARG AGE25_3 / adjrr; COND_EFF AGE25_3=(1 0 -1) / NAME = "25-44 vs. 65+"; COND_EFF AGE25_3=(0 1 -1) / NAME = "45-64 vs. 65+"; COND_EFF AGE25_3=(1 -1 0) / NAME = "25-44 vs. 45-64"; PRED_EFF AGE25_3=(1 0 -1) / NAME = "25-44 vs. 65+"; PRED_EFF AGE25_3=(0 1 -1) / NAME = "45-64 vs. 65+"; PRED_EFF AGE25_3=(1 -1 0) / NAME = "25-44 vs. 45-64"; setenv labwidth=17 colspce=1; print / betas=default betafmt=f7.4 sebetafmt=f8.4 lowbetafmt=f7.4 upbetafmt=f7.4 t_betafmt=f6.2 p_betafmt=f7.4; setenv labwidth=23 colspce=4 decwidth=3; print / risk=default tests=default expcntrst=default waldpfmt=f7.4 dffmt=f7.0 loworfmt=f9.3 uporfmt=f9.3 low_cntrstfmt=f5.3 up_cntrstfmt=f5.3; setenv colspce=1 labwidth=22 decwidth=4 colwidth=9; print condmrg="CONDMARG" predmrg="PREDMARG" / cond_mrg=default cnmgcons=default pred_mrg=default prmgcons=default t_cndmrgfmt=f8.2 t_prdmrgfmt=f8.2 t_cmconfmt=f8.2 t_pmconfmt=f8.2; setenv labwidth=27 decwidth=3 colwidth=5 colspce=5; print cond_rr="Risk Ratio" pred_rr="Risk Ratio" / condrisk=default predrisk=default;

linda0910 · ‎06-24-2022

Thank you so much for your reply. Yes, I used the ODS RTF close as well, but no output in the file. I guess the ods output doesn't work for SUDAAN. I used proc descript in the program, and I tried to save the results in the dataset, so that I can manipulate the data. However, I used ODS TRACE on/off to trace all the steps, but can't find the dataset name. Do you have any idea which dataset that SUDAAN store the data temporarily?

linda0910 · ‎06-23-2022

Hello everyone, I am currently using SAS SUDAAN to generate outcome. But all the output were in SAS output window. It's very hard to read. Does anybody know how to get the final reports in word or pdf? Thank you so much. I have tried to add ods rtf before running SUDAAN, but it won't work.

linda0910 · ‎06-11-2021

I just found if some cases have all the "Yes" from the first count till last, it would be deleted in the final output.

linda0910 · ‎06-11-2021

Thanks so much. It worked on my data, but for some of the observations, it count_number from 0-1. Since there is no "Zero" in the count, I guess there is just one "Yes". I do appreciate your help.

linda0910 · ‎06-11-2021

Sorry, if I confused you. This is the dataset. But for ID=1 the final outcome would be first consecutive “yes “ starting count at “1”, and ending “3”. For ID=2, the first consecutive “yes” staring at count=3 and ending at count=5

linda0910 · ‎06-11-2021

Hi all, I am stuck by counting consecutive values in the program and wish you could help me. My data is like this: ID count keep 1 1 Yes 1 2 Yes 1 3 Yes 1 4 No 1 5 No 1 6 Yes 1 7 Yes 2 1 No 2 2 No 2 3 Yes 2 4 Yes 2 5 Yes 2 6 No I want to find the "count number" range of the first consecutive "Yes" For ID=1 count number should be "1-3" For ID=2 count number should be "3-5" Thanks a lot.

linda0910 · ‎09-21-2020

Thanks so much. It worked perfectly.

linda0910 · ‎09-18-2020

Thanks so much. It's my bad and I haven't made it clear, that I have more than 5000 obs, and when I run the codes, it only generated the first 149 obs output. ERROR: Array subscript out of range at line 549 column 20. When I tried to change the array to more than 5000, it still gave me the same ERROR, may I ask how to solve the problem? Thanks again

linda0910 · ‎09-18-2020

Thanks so much for your help. But I have more than 5000 obs, and the drive keeps warning me there is no enough space to save the temporary data.

linda0910 · ‎09-17-2020

Hi everyone, I had data like this: PIN date_1 D_VISIT 3 01/30/2013 3 06/19/2014 6/19/2014 3 01/28/2015 11/12/2015 5 02/27/2013 5 03/14/2014 3/14/2014 5 05/29/2015 5 02/05/2016 5 02/10/2017 2/10/2017 6 04/15/2013 6 04/01/2014 4/1/2014 6 10/05/2015 6 06/20/2016 6 01/31/2017 1/31/2017 I hope I could fill in the missing value by the closest date_1 PIN date_1 D_VISIT 3 01/30/2013 6/19/2014 3 06/19/2014 6/19/2014 3 01/28/2015 11/12/2015 5 02/27/2013 3/14/2014 5 03/14/2014 3/14/2014 5 05/29/2015 3/14/2014 5 02/05/2016 2/10/2017 5 02/10/2017 2/10/2017 6 04/15/2013 4/1/2014 6 04/01/2014 4/1/2014 6 10/05/2015 4/1/2014 6 06/20/2016 1/31/2017 6 01/31/2017 1/31/2017 I searched topics and tried to use some codes: data want; do _n_ = 1 by 1 until (last.pin); set original_data; by pin; if missing(first_d_visit) and not missing(d_visit) then first_d_visit = d_visit; end; prev_d_visit = first_d_visit; do _n_ = 1 by 1 until (last.pin); set original; by pin; if missing(d_visit) then d_visit = prev_d_visit; prev_d_visit = d_visit; output; end; format first_d_visit mmddyy10. prev_d_visit mmddyy10.; run; But didn't give me the closest dates, but the previous dates. Any suggestion would be really appreciated

linda0910 · ‎09-01-2020

Thanks a lot. It works perfectly.

linda0910 · ‎09-01-2020

I have a dataset with 2000 observations. It contains ID, var1, var2. Var1="11,21,43,35" or "11" or any combination of these numbers. sometimes just one number, sometimes two numbers. Var2="20,21,35,43" or or any combination of these numbers. sometimes just one number, sometimes two numbers. I would like to generate a new variable to find any overlap or matching numbers between these two variables. For example, when var1="11,21,43,25" and var2="20,21,35,43" then matching="21"; when var1="11" and var2="35" then matching=.; when var1="11,21,35" and var2="21,35,43" then matching="21,35". Data want; input ID var1 $ var2 $; datalines; 1 11,21,43,35 11 2 11,21,43,25 20,21,35,43 3 11 35 4 11,21,35 21,35 5 21 35,21,43 ; Any suggestions would be greatly appreciated.

linda0910 · ‎09-06-2017

Thanks so much. That's exactly what I want.

linda0910 · ‎09-05-2017

Could somebody help me to deal with this problem, thanks so much. Basicly, I had thousands of PIN, dates, and mark (which I pasted below). I need to subtract dates between first "new start <400" till last "keep start <400". For example, for PIN=100, I subtract last "keep start <400" 1/7/2010 - first "new start <400" 2/25/2009. Then, I will need another subtraction for the same pin between "keep start <400" 11/24/2015- "new start <400" 3/2/2011. PIN DATE_COLLECTED mark 100 2/25/2009 new START <400 100 6/8/2009 keep START <400 100 1/7/2010 keep START <400 100 3/2/2011 new START <400 100 4/26/2011 keep START <400 100 6/29/2011 keep START <400 100 12/14/2011 keep START <400 100 6/6/2012 keep START <400 100 12/12/2012 keep START <400 100 6/12/2013 keep START <400 100 12/11/2013 keep START <400 100 4/18/2014 keep START <400 100 10/7/2014 keep START <400 100 12/16/2014 keep START <400 100 3/13/2015 keep START <400 100 11/24/2015 keep START <400 Any suggestion would be appreciated.

Online Status	Offline
Date Last Visited	‎12-19-2022 09:01 PM

SAS SUDAAN rlogistic regression output saved in sas file

Re: SAS callable SUDAAN output in word

SAS callable SUDAAN output in word

Re: count consecutive occurrence of same value within group

Re: count consecutive occurrence of same value within group

Re: count consecutive occurrence of same value within group

count consecutive occurrence of same value within group

Re: filling in missing dates with closest previous or after value by g...

Re: filling in missing dates with closest previous or after value by g...

Re: filling in missing dates with closest previous or after value by g...

Re: count consecutive occurrence of same value within group

Re: filling in missing dates with closest previous or after value by g...

Re: string match between two variables

Re: count consecutive occurrence of same value within group

SAS SUDAAN rlogistic regression output saved in sas file

Re: SAS callable SUDAAN output in word

SAS callable SUDAAN output in word

Re: count consecutive occurrence of same value within group

Re: count consecutive occurrence of same value within group

Re: count consecutive occurrence of same value within group

count consecutive occurrence of same value within group

Re: filling in missing dates with closest previous or after value by g...

Re: filling in missing dates with closest previous or after value by g...

Re: filling in missing dates with closest previous or after value by g...

filling in missing dates with closest previous or after value by group

Re: string match between two variables

string match between two variables

Re: How to do a subtraction between certain rows

How to do a subtraction between certain rows