About Woop122

Woop122 · ‎07-18-2017

Hi, This is my first time using proc glimmix and I'm trying to see the random effect of 52 different hospitals, but in my solution for random effects output table there are only 51 hospitals listed. The missing hospital does have observations and data. Is it supposed to be considered the 0 point then? %LET X = SEX RACE VLBW_YN GAWEEKS_CAT DELMOD_CAT SGAVAR CCSLEVEL_2016 NICU_BEDS_CAT COV_NEONAT_2016 HOSP_OWNER_2016 TEACHING_2014 AAP_2016 ; PROC GLIMMIX DATA=LOGIT METHOD=QUAD; CLASS &X DEIDHOSP; MODEL DCCDONE(EVENT='1')= &X./LINK=LOGIT DIST=BIN SOLUTION OR; RANDOM INT/SUBJECT = DEIDHOSP S TYPE=VC; RUN;

Woop122 · ‎06-29-2017

Hi, I'm trying to get the P-value for a list of 20+ diffent variables to export to excel. I've set it up in a round-about way, but was wondering if there's someway to simplify it to avoid 1000s of lines of code. Thank you! ODS OUTPUT MODELANOVA=OUTPUT; PROC LOGISTIC DATA=PAT_LIST_FINAL; CLASS SEX (REF = "0") ; MODEL CMV_IND = SEX; WHERE VLBW_YN = 'VLBW' AND VIRAL_YN = 1; RUN; PROC PRINT DATA=OUTPUT NOOBS; RUN; DATA SEX_P_VLBW; SET OUTPUT; RUN; ODS OUTPUT MODELANOVA=OUTPUT; PROC LOGISTIC DATA=PAT_LIST_FINAL; CLASS LOCATE (REF = "0") ; MODEL CMV_IND = LOCATE; WHERE VLBW_YN = 'VLBW' AND VIRAL_YN = 1; RUN; PROC PRINT DATA=OUTPUT NOOBS; RUN; DATA LOCATE_P_VLBW; SET OUTPUT; RUN; ODS OUTPUT MODELANOVA=OUTPUT; PROC LOGISTIC DATA=PAT_LIST_FINAL; CLASS HISP (REF = "0") ; MODEL CMV_IND = HISP; WHERE VLBW_YN = 'VLBW' AND VIRAL_YN = 1; RUN; PROC PRINT DATA=OUTPUT NOOBS; RUN; DATA HISP_P_VLBW; SET OUTPUT; RUN; DATA P_VLBW; SET SEX_P_VLBW LOCATE_P_VLBW HISP_P_VLBW ; RUN;

Woop122 · ‎06-28-2017

I am trying to create a table of counts based on each variable. @ballardw wrote: You say "create tables for each one". Each variable? Each Patient? Each combination of some thing? May I ask what you will do with those? Almost every process I have seen where people start tearing there datasets apart ends up with a a very convoluted and difficult procedure to put things back together for other purposes later. It really does help to show some starting data, fake values are okay as long as they demonstrate the behavior of your actual data, and what the final result looks like. If the idea is to get counts of patients by demographics you are doing a lot of extra work. I already have it done, but wanted to do it more efficiently. For example VLBW - Infection VLBW - No Infection. Non-VLBW - Infection Non-VLBW - No Infection Female Male Locate of Birth 1 Locate of Birth 2 Locate of Birth 3 Hispanic Non-Hispanic etc

Woop122 · ‎06-28-2017

Hi, I have a patient list w/ 20+ different variables - sex, location, ethnicity, race, etc. I want to create a loop that will create tables for each one. DATA VARIABLES; INFILE DATALINES DSD; ROW = _N_; INPUT VAR :$ 9.; DATALINES; SEX LOCATE ETHNICITY RACE ; PROC SQL NOPRINT; SELECT VAR INTO:PARAMLIST SEPARATED BY ' ' FROM VARIABLES; QUIT; PROC SQL; CREATE TABLE &PARAMLIST AS SELECT VARIABLE AS VAR ,A.VLBW_YN ,A.CMV_IND ,COUNT(*) AS COUNT FROM PAT_LIST_FINAL A WHERE A.VIRAL_YN = 1 GROUP BY 1,2,3 ; QUIT; PROC TRANSPOSE DATA=VARIABLE OUT=VARIABLE2 (DROP=_NAME_); BY VAR; ID VLBW_YN CMV_IND; VAR COUNT; RUN;

Woop122 · ‎06-28-2017

I am on sas 9.4 It can export the first time without issues, but if I re-run the exports right after it will not run. I need to be able to update my sheets if there are changes made.

Woop122 · ‎06-27-2017

Hi, I keep getting errors w/ excel export and was wondering if anyone knows an effective workaround. If I run these statements and then run it again right away, it says cannot replace sheet because it has existing formulas that reference other pages. I'm working off of a brand new excel w/o any formulas, so I'm not sure why this error occurs. I couldn't use the named range option w/ libnames since I'm accessing sas remotely. PROC EXPORT DATA=NON_VIRAL_DS DBMS=XLSX OUTFILE = "D:\UserData\chinht\CMV Trend Export.xlsx" REPLACE; SHEET = 'DS NO VIRAL'; RUN; PROC EXPORT DATA=NON_CMV_VIRAL_DS DBMS=XLSX OUTFILE = "D:\UserData\chinht\CMV Trend Export.xlsx" REPLACE; SHEET = 'DS NO CMV'; RUN; PROC EXPORT DATA=CMV_VIRAL_DS DBMS=XLSX OUTFILE = "D:\UserData\chinht\CMV Trend Export.xlsx" REPLACE; SHEET = 'DS CMV'; RUN;

Woop122 · ‎06-22-2017

PROC EXPORT DATA=ODDSRATIOS_COMBINED DBMS=XLSX OUTFILE = "FILE PATH" REPLACE; SHEET = 'ODDS RATIOS'; RUN; I keep getting an error that says cannot replace sheet because it has existing formulas that reference other pages ERROR: export unsuccessful. I know there's a hot fix available but I can't download it because of the server I'm working on. Is there any way around this problem? I need to be able to update the exported excel file w/ different iterations without deleting the sheet and re-creating the formulas each time.

Woop122 · ‎06-19-2017

Is there a way to do this without using the ODS excel? I want to export to an already existing excel file and create new tabs, rather than create a whole new file each time. thank you.

Woop122 · ‎06-15-2017

Hi, If I'm doing a chisq test or proc logistic, how do I get the results in a data table that can be exported into excel? For example, for the code below, I would like to have the odds ratio, p-value, and confidence intervals in a table for excel export. Same question for proc logistic. DATA QUESTION; INPUT GENDER $ RESPONSE $ COUNT; DATALINES; WOMEN YES 28 WOMEN NO 13 MEN YES 19 MEN NO 26 ; PROC FREQ DATA=QUESTION ORDER =DATA; WEIGHT COUNT; TABLES GENDER*RESPONSE / CHISQ RELRISK; RUN; proc logistic data = question desc; class gender; model response = gender; run;

Woop122 · ‎06-12-2017

Hi, I have a data set and I'm trying to re-create a summary table of statistics from a prior analysis. I'm able to re-create everything except for the t-test and wilcoxon p-value. When I try proc univariate or proc ttest, all the p-values I get are always <0.0001 no matter what variable I'm looking at. Any suggestions? Variable Birth Wt Nmiss Mean (std) Median IQR Range Nmiss Mean (std) Median IQR Range P_value P-value Birth Weight VLBW 0 1093.05 (284.4) 1140 846-1346 (525, 1500) 0 899.10 (277.24) 840 700-1159 (430, 1495) <.0001 <.0001 (gram) Non-VLBW 0 2830.32 (783.4) 2825 2160-3455 (1529, 4735) 0 2592.59 (764.4) 2410 1956-3118 (1505, 4224) 0.0343 0.0301 Head Circ VLBW 14 25.417 (2.561) 25.5 23-27.7 (20, 30.8) 9 24.203 (2.65) 24 22-26.3 (20, 30) 0.0068 0.0064 (cm) Non-VLBW 48 32.675 (2.675) 33 31-34.5 (23, 37.7) 12 31.83 (2.793) 32 30-34 (26, 42) 0.0559 0.0157

Woop122 · ‎06-08-2017

Hi, I want to calculate odds ratios, confidence intervals, and overall p-value given this data set and not sure how to do it in SAS. DATA RACE_TEST; INPUT RACE $ CMV_STATUS $ COUNT; DATALINES; Black CMV 10 Black NO CMV 16 White CMV 41 White NO_CMV 33 Asian CMV 20 Asian NO_CMV 5 Other CMV 16 Other NO_CMV 23 ; I would like the output to have an odds ratio (95% CI) for each race category, using white as the reference & 1 overall P-value to see if the race has no effect on CMV status. Is there a way to do all this in 1 statement? Thank you!

Woop122 · ‎06-06-2017

Hi, can you also help me change my username? I don't see the direct messenger option. Woop122

Woop122 · ‎06-06-2017

thanks for everyone's help! was using the wrong variable -__-

Woop122 · ‎06-06-2017

proc sql; create table test as select bwgt as bwvar ,gadays as gadaysvar from basedata ; quit; %MACRO sga(bwvar,gadaysvar,sgavar); IF &bwvar > . AND &gadaysvar > . THEN DO; &gadaysvar = &gadaysvar -3.5; IF 19*7 < &gadaysvar <= 20*7 THEN DO; IF &bwvar <=275 THEN &sgavar =1; ELSE IF &bwvar >=772 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 20*7 < &gadaysvar <=21*7 THEN DO; IF &bwvar <=314 THEN &sgavar =1; ELSE IF &bwvar >=790 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 21*7 < &gadaysvar <=22*7 THEN DO; IF &bwvar <=376 THEN &sgavar =1; ELSE IF &bwvar >=826 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 22*7 < &gadaysvar <=23*7 THEN DO; IF &bwvar <=440 THEN &sgavar =1; ELSE IF &bwvar >=882 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 23*7 < &gadaysvar <=24*7 THEN DO; IF &bwvar <=498 THEN &sgavar =1; ELSE IF &bwvar >=977 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 24*7 < &gadaysvar <=25*7 THEN DO; IF &bwvar <=558 THEN &sgavar =1; ELSE IF &bwvar >=1138 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 25*7 < &gadaysvar <=26*7 THEN DO; IF &bwvar <=625 THEN &sgavar =1; ELSE IF &bwvar >=1362 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 26*7 < &gadaysvar <=27*7 THEN DO; IF &bwvar <=702 THEN &sgavar =1; ELSE IF &bwvar >=1635 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 27*7 < &gadaysvar <=28*7 THEN DO; IF &bwvar <=798 THEN &sgavar =1; ELSE IF &bwvar >=1977 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 28*7 < &gadaysvar <=29*7 THEN DO; IF &bwvar <=925 THEN &sgavar =1; ELSE IF &bwvar >=2361 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 29*7 < &gadaysvar <=30*7 THEN DO; IF &bwvar <=1085 THEN &sgavar =1; ELSE IF &bwvar >=2710 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 30*7 < &gadaysvar <=31*7 THEN DO; IF &bwvar <=1278 THEN &sgavar =1; ELSE IF &bwvar >=2986 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 31*7 < &gadaysvar <=32*7 THEN DO; IF &bwvar <=1495 THEN &sgavar =1; ELSE IF &bwvar >=3200 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 32*7 < &gadaysvar <=33*7 THEN DO; IF &bwvar <=1725 THEN &sgavar =1; ELSE IF &bwvar >=3370 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 33*7 < &gadaysvar <=34*7 THEN DO; IF &bwvar <=1950 THEN &sgavar =1; ELSE IF &bwvar >=3502 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 34*7 < &gadaysvar <=35*7 THEN DO; IF &bwvar <=2159 THEN &sgavar =1; ELSE IF &bwvar >=3596 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 35*7 < &gadaysvar <=36*7 THEN DO; IF &bwvar <=2354 THEN &sgavar =1; ELSE IF &bwvar >=3668 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 36*7 < &gadaysvar <=37*7 THEN DO; IF &bwvar <=2541 THEN &sgavar =1; ELSE IF &bwvar >=3755 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 37*7 < &gadaysvar <=38*7 THEN DO; IF &bwvar <=2714 THEN &sgavar =1; ELSE IF &bwvar >=3867 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 38*7 < &gadaysvar <=39*7 THEN DO; IF &bwvar <=2852 THEN &sgavar =1; ELSE IF &bwvar >=3980 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 39*7 < &gadaysvar <=40*7 THEN DO; IF &bwvar <=2929 THEN &sgavar =1; ELSE IF &bwvar >=4060 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 40*7 < &gadaysvar <=41*7 THEN DO; IF &bwvar <=2948 THEN &sgavar =1; ELSE IF &bwvar >=4094 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 41*7 < &gadaysvar <=42*7 THEN DO; IF &bwvar <=2935 THEN &sgavar =1; ELSE IF &bwvar >=4098 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 42*7 < &gadaysvar <=43*7 THEN DO; IF &bwvar <=2907 THEN &sgavar =1; ELSE IF &bwvar >=4098 THEN &sgavar =3; ELSE &sgavar =2; END; ELSE IF 43*7 < &gadaysvar <=44*7 THEN DO; IF &bwvar <=2885 THEN &sgavar =1; ELSE IF &bwvar >=4098 THEN &sgavar =3; ELSE &sgavar =2; END; &gadaysvar = &gadaysvar +3.5; END; %MEND sga; data want; set test; %sga(bwvar,gadaysvar,sgavar); run;

Woop122 · ‎06-06-2017

I'm getting all null values for sgavar, which I know shoudn't be the case. Not sure what's going on...

Online Status	Offline
Date Last Visited	‎07-20-2017 03:56 PM

PROC Glimmix

List of P Values for Excel Export

Re: Help with Running a Do Loop with list of variables

Help with Running a Do Loop with list of variables

Re: EXCEL EXPORT

EXCEL EXPORT

EXCEL EXPORT

Re: Export Statistics

Export Statistics

T-Test Wilcoxon Test

PROC Glimmix

List of P Values for Excel Export

Re: Help with Running a Do Loop with list of variables

Help with Running a Do Loop with list of variables

Re: EXCEL EXPORT

EXCEL EXPORT

EXCEL EXPORT

Re: Export Statistics

Export Statistics

T-Test Wilcoxon Test

Chi-Sq

Re: How do you change your community UserName

Re: Invoking a macro

Re: Invoking a macro

Re: Invoking a macro