cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
undercover_247
‎11-02-2023
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Make new variables using if statements in proc sql

by Fluorite | Level 6 in SAS Programming
‎10-31-2023 01:49 PM
‎10-31-2023 01:49 PM
I have a dataset that looks like this ID users_2016 users_2017 users_2018 users_2019 users_2020 jjones 1 1 0 0 0 asmith 0 1 1 1 0   I want a table that looks like this Year count_users_year 2016 1 2017 2   I want to do this in proc sql but I don't understand how to create a variable using a combination of if/then logic and creating a new variable. A users could be involved in this program for multiple years so I couldn't really do this in a datstep without multiple steps. Any advice?      ... View more

Estimate statement in proc glm for two continuous variable interaction...

by Fluorite | Level 6 in Statistical Procedures
‎05-20-2023 02:57 PM
‎05-20-2023 02:57 PM
I have a negative binomial model where the outcome is the number of complications and my main predictors are three different continuous factor scores that relate to where a disease is found in the body. I found an interaction between one of the factor scores (factor3) and how long, in year, there was a delay from first experiencing symptoms and subsequently receiving surgery. I tried to make an estimate statement but all the mean estimates come back as zero and there's no exp findings. I am looking at this using the mean factor score of each quartile of the variable (so the mean of quartile 1 of factor3 is -1.18, mean of q2 is -0.33, etc) and for diagnostic delay I want to know the difference between people with no diagnostic delay because their disease was found incidentially (diagnostic delay of 0) and those who have an average diagnostic delay in my population (9.8 years). I am using sas 9.4. Any help is greatly appreciated. My simplified code is below   proc genmod data =data; model num_complications = factor1 factor2 factor3 white BMI diagnosticdelay alcohol_use smoking factor3*diagnosticdelay /type3 dist=negbin; estimate 'average q1 by incidential findings' intercept 1 diagnosticdelay 0 factor3 -1.18 diagnosticdelay*factor3 0/ exp; estimate 'average q2 by incidential findings' intercept 1 diagnosticdelay 0 factor3 -0.33 diagnosticdelay*factor3 0/ exp; estimate 'average q3 by incidential findings' intercept 1 diagnosticdelay 0 factor3 0.17 diagnosticdelay*factor3 0/ exp; estimate 'average q4 by incidential findings' intercept 1 diagnosticdelay 0 factor3 1.30 diagnosticdelay*factor3 0/ exp; estimate 'average q1 by average delay' intercept 1 diagnosticdelay 9.8 factor3 -1.18 diagnosticdelay*factor3 -113.3272/ exp; estimate 'average q2 by average delay' intercept 1 diagnosticdelay 9.8 factor3 -0.33 diagnosticdelay*factor3 -3.234/ exp; estimate 'average q3 by average delay' intercept 1 diagnosticdelay 9.8 factor3 0.17 diagnosticdelay*factor3 1.66/ exp; estimate 'average q4 by average delay' intercept 1 diagnosticdelay 9.8 factor3 1.30 diagnosticdelay*factor3 12.74/ exp; run; ... View more

Re: proc mianalyze not running - what am I missing?

by Fluorite | Level 6 in Statistical Procedures
‎02-27-2023 03:09 PM
‎02-27-2023 03:09 PM
Thank you! Please see attached for the gm_fcs dataset created by the parameter estimates command and used in the mianalyze  ... View more

Re: proc mianalyze not running - what am I missing?

by Fluorite | Level 6 in Statistical Procedures
‎02-25-2023 10:01 PM
‎02-25-2023 10:01 PM
I took it out and it is still freezing unfortunately.  ... View more

Re: proc mianalyze not running - what am I missing?

by Fluorite | Level 6 in Statistical Procedures
‎02-24-2023 03:53 PM
‎02-24-2023 03:53 PM
I have made the following edits and still can't get it to run. I removed the (classvar=level) and it ran but I don't believe I should take that out. What do you think? @Rick_SAS    proc mi data= spite.MIaim1 nimpute=5 out=mi_fcs ; class race_collapsed alcohol_use breastfeed rural year_diagnosis sexuality_dich smoking; fcs plots=trace(mean std); var race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay smoking alcohol_use rural age_firstperiod preg3 breastfeed year_diagnosis; fcs discrim(race_collapsed sexuality_dich alcohol_use breastfeed rural year_diagnosis smoking/classeffects=include) nbiter =100 ; run; proc freq data = spite.miaim1; table income2 race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay employment2 education2 smoking alcohol_use rural age_firstperiod preg3 breastfeed num_comorbidities year_diagnosis; run; proc genmod data=mi_fcs; class race_collapsed (ref = 'White') sexuality_dich (ref = 'Straight') smoking (ref = "Never Smoker") alcohol_use (ref = "Non-drinker") rural (ref = "Never rural") income2 (ref = "60k +") employment2 (ref = "Employed FT") education2 (ref = "Undergrad and higher") breastfeed (ref = "Ever Breastfed") ; model factor1 = race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay income2 employment2 education2 smoking alcohol_use rural age_firstperiod preg3 breastfeed num_comorbidities year_diagnosis/dist=normal ; by _imputation_; ods output ParameterEstimates=gm_fcs; run; PROC MIANALYZE parms(classvar=level)=gm_fcs; class race_collapsed alcohol_use breastfeed rural year_diagnosis sexuality_dich smoking; MODELEFFECTS INTERCEPT factor1 race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay income2 employment2 education2 smoking alcohol_use rural age_firstperiod preg3 breastfeed num_comorbidities year_diagnosis; RUN; ... View more

Re: proc mianalyze not running - what am I missing?

by Fluorite | Level 6 in Statistical Procedures
‎02-20-2023 04:08 PM
‎02-20-2023 04:08 PM
I'm trying this and for some reason I get this error: ERROR: The parameter Prm5 in the PARMINFO= data set is not in the COVB= data set.    It just seems to skip over 5 and I can't figure out why yet ... View more

proc mianalyze not running - what am I missing?

by Fluorite | Level 6 in Statistical Procedures
‎02-18-2023 10:26 PM
‎02-18-2023 10:26 PM
I am using proc mianalyze and it won't finish running. It just freezes but I'm not sure what's going wrong. I tried different numbers of imputations to see if that was the issue but no luck   Here is the code. Any advice? proc mi data= spite.MIaim1 nimpute=5 /*20*/ out=mi_fcs ; class race_collapsed alcohol_use breastfeed rural year_diagnosis sexuality_dich smoking; fcs plots=trace(mean std); var race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay smoking alcohol_use rural age_firstperiod preg3 breastfeed year_diagnosis; fcs discrim(race_collapsed sexuality_dich alcohol_use breastfeed rural year_diagnosis /classeffects=include) nbiter =100 ; run;   proc genmod data=mi_fcs; class race_collapsed (ref = 'White') sexuality_dich (ref = 'Straight') smoking (ref = "Never Smoker") alcohol_use (ref = "Non-drinker") rural (ref = "Never rural") income2 (ref = "60k +") employment2 (ref = "Employed FT") education2 (ref = "Undergrad and higher") breastfeed (ref = "Ever Breastfed") ; model factor1 = race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay income2 employment2 education2 smoking alcohol_use rural age_firstperiod preg3 breastfeed num_comorbidities year_diagnosis/dist=normal ; by _imputation_; ods output ParameterEstimates=gm_fcs; run; PROC MIANALYZE parms(classvar=level)=gm_fcs; class race_collapsed alcohol_use breastfeed rural year_diagnosis sexuality_dich smoking; MODELEFFECTS INTERCEPT factor1 race_collapsed BMI sexuality_dich age2 agediagnosed diagnosticdelay income2 employment2 education2 smoking alcohol_use rural age_firstperiod preg3 breastfeed num_comorbidities year_diagnosis; RUN;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-02-2023 01:48 PM
Likes from
View All
Quick links