About bobeng

bobeng · ‎01-12-2024

Hi below is the code and the log. I ended up removing this statement because I do not need to impute this variable. There are no missing values for this variable. TITLE " MULTIPLE IMPUTATION REGRESSION - FCS"; proc mi data=study_ds_MI seed= 347 nimpute=40 out=fcsoutput; class pref Race_eth2 /*GestWeeks2*/ agegroup PrePriorARVStatusc2 TrimesterFst2 Mat_payor2 ROS_NYC2 tot_supp2 first_sup STI hep;; *d_year taken out because its continuous; var Pref Race_eth2 d_year /*GestWeeks2*/ agegroup PrePriorARVStatusc2 ROS_NYC2 tot_supp2 first_sup sup_preg STI hep TrimesterFst2 Mat_payor2 ; fcs logistic ( Mat_payor2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg);*variables MAR with missing Mat_Payor; fcs logistic (TrimesterFst2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg STI);*variables MAR with missing TrimesterFst; fcs regpmm (d_year) plots=trace; *continuous variables are listed here; run;*127000; This is the log:

bobeng · ‎01-12-2024

Hi I was working on my multiple imputation and I see that the trace plots do not display, even though i added this option in my code below: TITLE " MULTIPLE IMPUTATION REGRESSION - FCS"; proc mi data=study_ds_MI seed= 347 nimpute=40 out=fcsoutput; class pref Race_eth2 /*GestWeeks2*/ agegroup PrePriorARVStatusc2 TrimesterFst2 Mat_payor2 ROS_NYC2 tot_supp2 first_sup STI hep;; *d_year taken out because its continuous; var Pref Race_eth2 d_year /*GestWeeks2*/ agegroup PrePriorARVStatusc2 ROS_NYC2 tot_supp2 first_sup sup_preg STI hep TrimesterFst2 Mat_payor2 ; fcs logistic ( Mat_payor2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg);*variables MAR with missing Mat_Payor; fcs logistic (TrimesterFst2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg STI);*variables MAR with missing TrimesterFst; fcs regpmm (d_year) plots=trace; *continuous variables are listed here; run;*127000; This is my output:

bobeng · ‎01-11-2024

I'm sorry but I have one more question. If I am doing backward logistic regression I was told that I could not remove both of the variables with imputed values from the model. When I did this I kept getting a variance of zero. I guess my question is with backward approach logistic regression do I have to keep both of the variables with imputed values in the model, even if the P value is the least significant? BA

bobeng · ‎01-10-2024

Thank you this makes sense. BA

bobeng · ‎01-10-2024

I created a missing variable (1= missing 0=not missing) for the two variables I imputed. I found that pref was only associated with missing trimester established. Should I still include this variable in the FCS logistic statement for both? data study_ds_MI; set study_ds; if Mat_payor2=. then n_miss_Mat_payor=1; else n_miss_Mat_payor=0; if TrimesterFst2=. then n_miss_TrimesterFst=1; else n_miss_TrimesterFst=0; run;*3175; proc logistic data = study_ds_MI descending; model n_miss_Mat_payor = pref; run; . proc logistic data = study_ds_MI descending; model n_miss_TrimesterFst = pref; run; BA

bobeng · ‎01-10-2024

if I now add pref this is what it should look like? proc mi data=study_ds_MI seed= 347 nimpute=40 out=fcsoutput; class pref Race_eth2 /*GestWeeks2*/ agegroup PrePriorARVStatusc2 TrimesterFst2 Mat_payor2 ROS_NYC2 tot_supp2 first_sup STI hep;; *d_year taken out because its continuous; var Pref Race_eth2 d_year /*GestWeeks2*/ agegroup PrePriorARVStatusc2 ROS_NYC2 tot_supp2 first_sup sup_preg STI hep TrimesterFst2 Mat_payor2 ; fcs logistic ( Mat_payor2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg);*variables MAR with missing Mat_Payor; fcs logistic (TrimesterFst2= pref d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg STI);*variables MAR with missing TrimesterFst; fcs regpmm (d_year) plots=trace; *continuous variables are listed here; run;*127000; Also, it was my understanding that we only include variables that are associated with the missing variable in the fcs logistic statement. Please correct me if I am wrong. Thank you for your continued help. BA

bobeng · ‎01-10-2024

Looking back at my code I see that this variable was included in my imputation. proc mi data=study_ds_MI seed= 347 nimpute=40 out=fcsoutput; class pref Race_eth2 /*GestWeeks2*/ agegroup PrePriorARVStatusc2 TrimesterFst2 Mat_payor2 ROS_NYC2 tot_supp2 first_sup STI hep;; *d_year taken out because its continuous; var Pref Race_eth2 d_year /*GestWeeks2*/ agegroup PrePriorARVStatusc2 ROS_NYC2 tot_supp2 first_sup sup_preg STI hep TrimesterFst2 Mat_payor2 ; fcs logistic ( Mat_payor2= d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg);*variables MAR with missing Mat_Payor; fcs logistic (TrimesterFst2= d_year PrePriorARVStatusc2 ROS_NYC2 first_sup sup_preg STI);*variables MAR with missing TrimesterFst; fcs regpmm (d_year) plots=trace; *continuous variables are listed here; run;*127000;

bobeng · ‎01-10-2024

Thank you this makes sense.

bobeng · ‎01-09-2024

Hi, I need more clarification on the response variable. My exposure of interest is the "race/eth2" variable and my outcome is "pref." Any help would be appreciated. BA

bobeng · ‎01-09-2024

I have been having trouble trying to understand multiple logistic regression with an imputed data set using the FCS method. I have explained everything in the document attached including the questions that I have

bobeng · ‎08-02-2021

Thank you for your repy. I was unable to get it to work with the you suggested solution. Instead, I found out that the code had been written with an older veersion of SAS and was able to use 9.3 to run the program succcessfully.

bobeng · ‎07-26-2021

This is the code that I am trying to run, but keep running into issues. %macro banner; ods region width=8.5in height=.75in x=0in y=0.001in; goptions cback=&purplebanner; proc gslide; run; quit; run; ods region width=3in height=.70in x=5.29in y=0.152in; goptions cback=&purplebanner; ODS PDF text="^S={just=right preimage='T:\STDGroup\Surveillance\Report\Programs\gray report\purple Logo.png'}"; ODS PDF text="^S={font=('Arial', 7pt, bold) just=right color=white} Office of Health and Epidemiology"; ods region width=11in height=.1in x=0in y=.75001in; goptions cback=&bluebanner; proc gslide; run; quit; run; %mend; %banner; This is the error message that I keep receiving: WARNING%3A REGION found but no LAYOUT open for the destination. Region will be ignored.

bobeng · ‎05-27-2021

I am trying to create more than 10 footnotes in an ods excel using proc report. I used the code below which worked the first time, but now the footnotes will no longer print in excel, but but do appear in the sas output. ods escapechar='~'; FOOTNOTE ' aaaaaaa ~n bbbbbbb ~n cccccccc ~n dddddddddd';

bobeng · ‎05-25-2021

yes, it worked! thank you!

bobeng · ‎05-25-2021

I am trying to do a print a table but the superscript will not work for one of the variables option missing='0' nodate nonumber orientation=landscape ; ods escapechar="~"; data ALL; set ALL; length outcome $61. if variablenames eq 'stall' then outcome='The Number of Reported Cases (%)'; if variablenames eq 'caseassign_per' then outcome='The Number of Cases Assigned for an Investigation (%)'; if variablenames eq 'passigned_per' then outcome='Partners assigned (%)'; if variablenames eq 'test_30_per' then outcome='Testing Among OPs (%)'; if variablenames eq 'NONMISSING_REFERAL_active' then outcome='The Number of Cases Active Referral (%)'; if variablenames eq 'NONMISSING_REFERAL_passive' then outcome='The Number of Cases Passive Referral (%)'; if variablenames eq 'part_HIV_test_per' then outcome='The Number of Partners Tested for HIV (%)'; if variablenames eq 'NONMISSING_Active_REFPart' then outcome= 'The Number of Partners Active Referral (%)'; if variablenames eq 'NONMISSING_passive_REFPart' then outcome='The Number of Partners Passive Referral (%)'; ***; if variablenames eq 'stdall' then count=1; if variablenames eq 'caseassign_per' then count=2; if variablenames eq 'passigned_per' then count=3; if variablenames eq 'test_30_per' then count=4; if variablenames eq 'NONMISSING_REFERAL_active' then count=5; if variablenames eq 'NONMISSING_REFERAL_passive' then count=6; if variablenames eq 'part_test_per' then count=7; if variablenames eq 'NONMISSING_Active_REFPart' then count=8; if variablenames eq 'NONMISSING_passive_REFPart' then count=9; if outcome='The Number of Cases Assigned for an Investigation (%)' then outcome=catx(' ',outcome,'~{super 2}'); if outcome='Testing Among OPs (%)' then outcome=catx(' ',outcome,'~{super 3}'); if outcome='The Number of Cases Active Referral (%)' then outcome=catx(' ',outcome,'~{super 4}'); if outcome='The Number of Cases Passive Referral %)' then outcome=catx(' ',outcome,'~{super 4}'); if outcome='Partners assigned (%)' then outcome=catx(' ',outcome,'~{super 5}'); if outcome='Partners assigned (%)' then outcome=catx(' ',outcome,'~{super 5}'); if outcome='The Number of Partners Tested(%)' then outcome=catx(' ',outcome,'~{super 3}'); if outcome='The Number of Partners Passive Referral (%)' then outcome=catx(' ',outcome,'~{super 4}'); if outcome='The Number of Partners Active Referral (%)' then outcome=catx(' ',outcome,'~{super 4}'); run; PROC SORT DATA=ALL2; BY descending pop diagnosis COUNT; RUN; proc print data= ALL2 noobs; run; Instead of this I get this

Online Status	Offline
Date Last Visited	‎01-26-2024 06:13 PM

Re: No trace plots with proc mi fcs

No trace plots with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

multiple logistic regression with proc mi fcs

poisson regression goodness of fit stats

Re: I am using ods excel to export two tables into one sheet%2C but th...

Re: I am using ods excel to export two tables into one sheet%2C but th...

Re: proc report mulstiple datasets into one excel sheet

Re: proc report mulstiple datasets into one excel sheet

Re: WARNING%3A REGION found but no LAYOUT open for the destination. R...

Re: Superscript will not generate in code

Re: No trace plots with proc mi fcs

No trace plots with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

Re: multiple logistic regression with proc mi fcs

multiple logistic regression with proc mi fcs

Re: WARNING%3A REGION found but no LAYOUT open for the destination. R...

WARNING%3A REGION found but no LAYOUT open for the destination. Regio...

How to provide more than 10 Footnotes for Graphs.

Re: Superscript will not generate in code

Superscript will not generate in code