About dkcundiffMD

dkcundiffMD · ‎12-19-2020

Thanks for the suggestion about proc PLS. At issue with my statistician colleague is whether the formatting of the 20 dietary variables into a single compound variable in our model means the compound dietary variable should be the one considered for VIF or PLS as I contend. The 20 individual dietary variables will not appear in the Multiple regression formula--only the combination variable. Attached are the SAS codes and results of the multiple regression analysis. Should the variable at issue be the combination one or all 20 dietary variables? We will also do the PLS analysis. Thanks.

dkcundiffMD · ‎12-19-2020

In a worldwide Global Burden of Disease database of 195 countries, my co-author and I are modeling body mass index (BMI dependent variable) with 20 dietary variables, total kilocalories available, physical activity, sex, discontinuation of breast feeding, and severe underweight in infancy. We are revising our published preprint (https://www.medrxiv.org/content/10.1101/2020.07.27.20162487v1) With SAS Studio 9.4, we formatted 20 dietary variables into a single composite variable (BMI17f1) based on the worldwide mean kilocalories/day of each of the dietary variables times the R2 of the univariate correlation with BMI (dependent variable). See code attached. In a VIF analysis, the 20 dietary variables and total kilocalories available all had VIF <10 (the cutoff for significant variable inflation). See attached code VIF testing pdf and the VIF testing results pdf. When the four other variables are added in the VIF analysis, milk (11.38) and child severe underweight (11.32) are >10. When the 20 dietary variables are formatted into BMI17f1 (a composite variable) and VIF tested with the other variables, VIF for all variables was < 10 (see code and results pdfs). Is there any reason to delete any of the variables from the multiple regression analysis?

dkcundiffMD · ‎06-11-2020

That did it. Many thanks, Jennifer

dkcundiffMD · ‎06-11-2020

On trying to launch SAS Studio 9.4, I got the error below: Failed to open a session for the virtual machine SAS University Edition. The VM session was closed before any attempt to power it on. Result Code: E_FAIL (0x80004005) Component: SessionMachine Interface: ISession {7844aa05-b02e-4cdd-a04f-ade4a762e6b7} The last few weeks, i had been getting notices to get the latest Oracle Virtual Box version. I tried to download it but it failed. I got no such notice this time. What next? Thanks.

dkcundiffMD · ‎06-05-2020

You called it right. It was the old router. Thanks

dkcundiffMD · ‎03-24-2020

Very helpful. Thanks. I'll get working on these suggestions.

dkcundiffMD · ‎03-23-2020

While running code or while editing code, my Spectrum wifi often loses connection. This requires a click to reconnect and a click to close the dialogue. Sometimes I have to sign off and start over. At times the frequency might be up to twice in 5 minutes. A wifi speed test showed download 27 Mbps and upload 9 Mbps. What might be causing this and what questions should I ask Spectrum, the wifi provider located in Monterrey Park, CA. I have SAS 9.4 with SAS Studio. Thanks. David K Cundiff

dkcundiffMD · ‎03-13-2020

No. I'm not using Arabic, Hebrew, or other foreign language. Thanks.

dkcundiffMD · ‎03-13-2020

I removed the non displaying code that you pointed out and it worked! Thank you very much.

dkcundiffMD · ‎03-13-2020

639 640 BMI17f6s= 641 +pmeat17KCs *0.0257616*0.59026594*100 642 +rmeat17KCs *0.28559643606‬*0.59026594*100 ___ 22 ERROR: The name ‬ is not a valid SAS name. ERROR: The name ‬ is not a valid SAS name. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. 643 +fish17KCs *0.001355444*0.59026594*100 644 +milk17KCs *0.152948*0.59026594*100 645 +poultry16KCs *0.32966*0.59026594*100 646 +eggs16KCs *0.076896*0.59026594*100 647 648 - fruits17KCs *0.022533*0.59026594*100 649 -vegetables17KCs *0.0311578*0.59026594*100 650 -nutsseeds17KCs *0.0029001*0.59026594*100 651 - wgrains17KCs *0.0032282*0.59026594*100 652 -legumes17KCs *0.010995*0.59026594*100 653 -corn16KCs*0.00005218*0.59026594*100 654 -potatoes16KCs*0.00021426*0.59026594*100 655 -rice16KCs *0.075717*0.59026594*100 656 -swtpot16KCs *0.001059*0.59026594*100 657 658 -PAMets17ms*0.21541 *0.59026594*100 659 ; It happened again. Is this what you mean? Thanks.

dkcundiffMD · ‎03-12-2020

So I just put {I} in front of anything I'm coding? Or wait till is get a bogus syntax error and then redo with {I}? Thanks. David K. Cundiff

dkcundiffMD · ‎03-12-2020

The ";" at the end of the equation was the spot with the ___ 22 However, when I did some further unrelated work on the code and when back, it worked. That has occasionally happened before. I'm still puzzled why. Thanks.

dkcundiffMD · ‎03-12-2020

Coding with SAS Studio 9.4, I got the following error message: BMI17fNS1= 743 pmeat17KCAj 744 +rmeat17KCAj 745 +fish17KCAj 746 +milk17KCAj 747 +poultry16KCAj 748 +eggs16KCAj 749 ; 750 751 BMI17fNS2= 752 fruits17KCAj 753 +vegetables17KCAj 754 +nutsseeds17KCAj 755 +potatoes16KCAj 756 +wgrains17KCAj 757 +legumes17KCAj 758 +rice16KCAj 759 +swtpot16KCAj; 760 761 BMI17fNS3=BMI17fNS1/BMI17fNS2; 762 763 BMI17fNS4= 764 (BMI17fNS3*3.04491 765 -PAMETs17m*0.00039009) /1.25398; 766 767 BMI17fNS5=BMI17fNS4 +22.20829‬; ___ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 768 * ERROR: The name ‬ is not a valid SAS name. ERROR: The name ‬ is not a valid SAS name. I first tried to add the 22.20829 in the BMI17fNS4 expression and got the same syntax error. Other times the same simple addition of a constant does not throw an error message. What is my problem? Thanks. David K. Cundiff

dkcundiffMD · ‎02-12-2020

Getting rid of "run; quit;" did the trick. Thanks ballardw. David Cundiff

dkcundiffMD · ‎02-12-2020

You were right Dr. Miller!... An easy fix. Thanks. David Cundiff

Online Status	Offline
Date Last Visited	‎02-04-2024 09:45 PM

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Risk factors combined variable in a multiple regression was not workin...

Re: ERROR: Libref PRODUCTS is not assigned.

ERROR: Libref PRODUCTS is not assigned.

Re: Lost variables between proc reg and proc corr

Re: Lost variables between proc reg and proc corr

Re: Lost variables between proc reg and proc corr

Lost variables between proc reg and proc corr

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: ERROR: Libref PRODUCTS is not assigned.

Re: ERROR: Libref PRODUCTS is not assigned.

Re: The proper use of variance inflation factor (VIF) test in multiple...

The proper use of variance inflation factor (VIF) test in multiple reg...

Re: Oracle Virtual Box failed to launch SAS Studio

Oracle Virtual Box failed to launch SAS Studio

Re: SAS Studio loses wifi connectivity momentarily repeatedly: causes ...

Re: SAS Studio loses wifi connectivity momentarily repeatedly: causes ...

SAS Studio loses wifi connectivity momentarily repeatedly: causes and ...

Re: Syntax error for no reason

Re: Syntax error for no reason

Re: Syntax error for no reason

Re: Syntax error for no reason

Re: Syntax error for no reason

Syntax error for no reason

Re: ERROR 180: Statement is not valid or it is used out of proper orde...

Re: ERROR 180: Statement is not valid or it is used out of proper orde...

SAS Analytics Explorers