About DanielQuay

DanielQuay · ‎01-24-2019

I am having a problem, for some reason, I am no longer getting the estimated regression coefficients when I run the following code: proc surveyreg data=RECODE6; strata STRATUMCR4; class anuinc urban MRAC MARRIED SEX EDUC2 Agec; model Safety_Scale = anuinc urban MRAC MARRIED SEX EDUC2 Agec ACTIV DPRSN TV_HRS3/ anova adjrsq clparm deff inverse xpx; weight WTANAL; run; I was able to run this and get the coefficients just fine, now for some reason I'm not. It stops after reporting the Tests of Model Effects and the denominator degrees of freedom. Help?

DanielQuay · ‎01-10-2019

I'm having a problem running a model using proc surveylogistic. proc surveylogistic data = source order=formatted; class ACTIV (param=ordinal) TV_HRS(param=ordinal); model BMIc = ACTIV|TV_HRS ; format BMIc BMIc. ACTIV ACTIV. TV_HRS TV_HRS.; weight WTANAL; strata Stratumcr4; run; The problem I'm having is that it is not running the Proportional Odds Assumption test. I've tried running it without the interaction variable and I still don't get this as part of my printout. Any idea why it's not running this test? After looking for a reason all day yesterday I'm stumped.

DanielQuay · ‎09-18-2018

Thank You again Reeza, And I'm sorry, I promise, I'm trying to learn how to ask questions better.

DanielQuay · ‎09-18-2018

Well, I'm afraid I'm back with another easy question, but I am stuck. Or rather, I haven't gotten this to work in a way that I am happy. I have three datasets that have been successfully combined, no problems there. The problem is when I am looking at the data, a number of variables were changed over the years the data was gathered. The question is, "how many of the last 12 months were you employed". In 2007, this variable was titled Months (which was later used for something completely different, at least I figured out how to separate that mess). Then in 2008 it was changed to PastPay, and then in 2010 it was changed again to EMP_PAY. The data is pretty straightforward, respondents answered 1-12. So it would look like: 2007 Obs1 = 1 Obs2 = 3 Obs3 = 9 Obs3 = 5 Obs4 = 11 2008 Obs1 = 2 Obs2 = 3 Obs3 = 8 Obs3 = 12 Obs4 = 7 2010 Obs1 = 9 Obs2 = 2 Obs3 = 4 Obs3 = 1 Obs4 = 8 I've tried do loops with if/then statements, tried catx, and tried an array but I haven't been able to get them combined. (largely because I'm still learning SAS). Sorry, I'm sure I'll have 8 simple answers and feel really dumb here in about 10 minutes but I'm hitting a wall right now.

DanielQuay · ‎08-31-2018

Thanks Reeza, I knew it was going to be something ridiculously simple but I was striking out.

DanielQuay · ‎08-31-2018

I am working in a multi-year data set. The problem I'm encountering is that I have the same variable name but they don't always have the same response category. So in 2013, ED_LEVEL= 1 = Less than 12th grade, no diploma ED_LEVEL= 2 = High school graduate or GED completed ED_LEVEL= 3 = Associate degree (AA, AS) ED_LEVEL= 4 = Bachelor's degree(e.g., BA, BS) ED_LEVEL= 5 = Master's degree (e.g., MA, MS) ED_LEVEL= 6 = Doctorate (e.g., Phd, EdD) or professional degree (e.g., MD, DDS) ED_LEVEL= 9 = Don't Know But in 2015 the categories changed, now: ED_LEVEL= 1 = Less than 12th grade, no diploma ED_LEVEL= 2 = High school graduate or GED completed ED_LEVEL= 3 = Technical/trade/vocational school completed ED_LEVEL= 4 = Associate degree (AA, AS) ED_LEVEL= 5 = Bachelor's degree(e.g., BA, BS) ED_LEVEL= 6 = Master's degree (e.g., MA, MS) ED_LEVEL= 7 = Professional degree (e.g., JD, MD, DDS) ED_LEVEL= 8 = Doctorate (e.g., Phd, EdD) or professional degree (e.g., MD, DDS) ED_LEVEL= 9 = Don't Know And just to spice things up a bit in 2012 the variable was: EDU_M= 1 = 8th grade or less EDU_M= 2 = 9th - 12th grade, no diploma EDU_M= 3 = High school graduate or GED completed EDU_M= 4 = Some college credit but no degree EDU_M= 5 = Associate degree (AA, AS) EDU_M= 6 = Bachelor's degree(e.g., BA, BS) EDU_M= 7 = Master's degree (e.g., MA, MS) EDU_M= 8 = Doctorate (e.g., Phd, EdD) or professional degree (e.g., MD, DDS) EDU_M= 9 = Don't Know What I am hoping to do is combine them all into a common variable: EDUCATION. What I have tried thus far is (on another variable): do; if year = '2008' or '2010' or '2011' or '2012' or '2013' then do; if HC_DEVLP = 1 then DEV_DEL = 1; else if HC_DEVLP = 2 then DEV_DEL = 2; else if HC_DEVLP = 9 then DEV_DEL = 9; else DEV_DEL='.'; end; if year = '2007' or '2014' or '2015' then do; if HC_DEVLP = 1 then DEV_DEL2=1; else if HC_DEVLP = 2 then DEV_DEL2=2; else if HC_DEVLP = 9 then DEV_DEL2=9; else if No5Developmentaldelay = 0 then DEV_DEL2 = 1; else if No5Developmentaldelay = 1 then DEV_DEL2 = 2; else DEV_DEL2='.'; end; end; but that did not work so I am reaching out for some advice because I'm not having much luck figuring it out at this point. Thanks Community.

DanielQuay · ‎06-05-2018

Alright, this time I know what I did wrong in my reply. Sorry. Column Data 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 Row Data 1 2 4 4 5 4 3 2 1 3 2

DanielQuay · ‎06-05-2018

A part of the problem is I might not be understanding what you're asking so I will try again. My data are laid out 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 When I run the frequency procedure one at a time I get this output. The FREQ Procedure FrequencyPercentRow PctCol Pct Table of PopCat by F4APopCat F4A(F4A)0 1 Total12345Total 6 5.22 26.09 18.75 17 14.78 73.91 20.48 23 20.00 8 6.96 17.78 25.00 37 32.17 82.22 44.58 45 39.13 8 6.96 38.10 25.00 13 11.30 61.90 15.66 21 18.26 4 3.48 30.77 12.50 9 7.83 69.23 10.84 13 11.30 6 5.22 46.15 18.75 7 6.09 53.85 8.43 13 11.30 32 27.83 83 72.17 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4BPopCat F4B(F4B)0 1 Total12345Total 18 15.65 78.26 18.37 5 4.35 21.74 29.41 23 20.00 42 36.52 93.33 42.86 3 2.61 6.67 17.65 45 39.13 16 13.91 76.19 16.33 5 4.35 23.81 29.41 21 18.26 11 9.57 84.62 11.22 2 1.74 15.38 11.76 13 11.30 11 9.57 84.62 11.22 2 1.74 15.38 11.76 13 11.30 98 85.22 17 14.78 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4CPopCat F4C(F4C)0 1 Total12345Total 23 20.00 100.00 22.12 0 0.00 0.00 0.00 23 20.00 40 34.78 88.89 38.46 5 4.35 11.11 45.45 45 39.13 19 16.52 90.48 18.27 2 1.74 9.52 18.18 21 18.26 11 9.57 84.62 10.58 2 1.74 15.38 18.18 13 11.30 11 9.57 84.62 10.58 2 1.74 15.38 18.18 13 11.30 104 90.43 11 9.57 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4DPopCat F4D(F4D)0 1 Total12345Total 22 19.13 95.65 19.30 1 0.87 4.35 100.00 23 20.00 45 39.13 100.00 39.47 0 0.00 0.00 0.00 45 39.13 21 18.26 100.00 18.42 0 0.00 0.00 0.00 21 18.26 13 11.30 100.00 11.40 0 0.00 0.00 0.00 13 11.30 13 11.30 100.00 11.40 0 0.00 0.00 0.00 13 11.30 114 99.13 1 0.87 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4EPopCat F4E(F4E)0 1 Total12345Total 23 20.00 100.00 20.18 0 0.00 0.00 0.00 23 20.00 45 39.13 100.00 39.47 0 0.00 0.00 0.00 45 39.13 20 17.39 95.24 17.54 1 0.87 4.76 100.00 21 18.26 13 11.30 100.00 11.40 0 0.00 0.00 0.00 13 11.30 13 11.30 100.00 11.40 0 0.00 0.00 0.00 13 11.30 114 99.13 1 0.87 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4FPopCat F4F(F4F)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4GPopCat F4G(F4G)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4HPopCat F4H(F4H)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4IPopCat F4I(F4I)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4JPopCat F4J(F4J)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4KPopCat F4K(F4K)0 Total12345Total 23 20.00 100.00 20.00 23 20.00 45 39.13 100.00 39.13 45 39.13 21 18.26 100.00 18.26 21 18.26 13 11.30 100.00 11.30 13 11.30 13 11.30 100.00 11.30 13 11.30 115 100.00 115 100.00 FrequencyPercentRow PctCol Pct Table of PopCat by F4LPopCat F4L(F4L)0 1 Total12345Total 23 20.00 100.00 20.35 0 0.00 0.00 0.00 23 20.00 45 39.13 100.00 39.82 0 0.00 0.00 0.00 45 39.13 21 18.26 100.00 18.58 0 0.00 0.00 0.00 21 18.26 13 11.30 100.00 11.50 0 0.00 0.00 0.00 13 11.30 11 9.57 84.62 9.73 2 1.74 15.38 100.00 13 11.30 113 98.26 2 1.74 115 100.00 The output I am wanting have the same information but in a single table:

DanielQuay · ‎06-05-2018

Unsure, that's where I'm trying to get to. Though in truth, I can handle having percentages and such as well as the rest of the info available in a proc freq step. I'm researching proc report now.

DanielQuay · ‎06-05-2018

Yes, all binary

DanielQuay · ‎06-05-2018

Sure. Row=1 2 3 4 5 COLA= 0 1 COLB= 0 1 COLC= 0 1 COLD= 0 1 COLE= 0 1 COLF= 0 1 Desired output: Row COLA COLB COLC COLD COLE COLF 1 27 0 0 1 0 11 2 0 1 15 27 0 11 3 10 45 0 1 0 1 4 33 0 3 1 0 6 5 20 0 0 17 0 1

DanielQuay · ‎06-05-2018

Hello, So this should be simple enough, I suspect it's a matrix, just not really good at those yet. proc freq data=dataset; tables ROW*COLA ROW*COLB ROW*COLC ROW*COLD ROW*COLE ROW*COLF ROW*COLG ROW*COLH ROW*COLI; run; this will get me an answer that I'm needing, I just have to compile all of the separate tables generated into a single table separately from SAS right now. My question is, is there a cleaner or more efficient way to do this so that I get all of the Columns displayed on a single grid rather than having to do that manually after the fact?

DanielQuay · ‎04-17-2018

That was it, thanks, I'll try to stay off the boards for a few hours now.

DanielQuay · ‎04-17-2018

So the dataset I am working on has an infants DOB listed across three variables I have a variable for Month, Day, and Year. I need to combine them into a single DOB variable, but the data I'm finding for combining variables isn't helping so far. Sorry, new to SAS and some of this hasn't sunk in yet.

DanielQuay · ‎04-17-2018

Thanks for the assistance, though I figured out how to do it without using an array. The issue I was having was a simple thing in my data statement.

Online Status	Offline
Date Last Visited	‎08-08-2023 08:26 PM

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Creating and Comparing Rates between Groups

Re: Median Days To Diagnosis

Median Days To Diagnosis

Re: Variable keeps generating with * as result

Re: Variable keeps generating with * as result

Variable keeps generating with * as result

Converting Multi-Select Variable to Multi-Variable

Re: How do I print to fewer pages with an ODS PDF

Re: Proc Surveymeans: Suppressing the kernel & normal density plot ove...

Re: Merging Variables

Re: Same Variable Name - Different responses

Re: Proc SurveyReg Output

Re: Proc SurveyReg Output

Re: Merging Variables

Proc SurveyReg Output

SURVEYLOGISTIC and Proportional Odds

Re: Merging Variables

Merging Variables

Re: Same Variable Name - Different responses

Same Variable Name - Different responses

Re: Cross Tab with multiple columns but a common row variable

Re: Cross Tab with multiple columns but a common row variable

Re: Cross Tab with multiple columns but a common row variable

Re: Cross Tab with multiple columns but a common row variable

Re: Cross Tab with multiple columns but a common row variable

Cross Tab with multiple columns but a common row variable

Re: Creating DOB variable when I have Month, Day, Year as separate var...

Creating DOB variable when I have Month, Day, Year as separate variabl...

Re: Create a variable with case when