I figured it out, thank you ... View more

This makes a lot more sense now, yes I was using ODS OUTPUT to create that particular dataset and I named the datasets TABLEONE TABLETWO AND TABLETHREE as part of the work library because I wanted to not confuse myself, but I guess I confused SAS communities. so that table that I presented has 4 observations so only the last one will be presented when I run that code you provided?   That's interesting and I appreciate the explanation because now it's becoming clear to me what I need to do. I may be overthinking how to get the end result but that is extremely helpful! ... View more

Yes, here is my code to get that table that I presented:   ODS TRACE ON; PROC GLM DATA=ANOVA; CLASS Quartiles; MODEL riskfactors_quartiles = Marijuana_Use Education_Status Poverty_Percent Frequent_Mental_Dist; RUN; QUIT; ODS TRACE OFF; ODS OUTPUT ModelANOVA=TableTwo; PROC GLM DATA=ANOVA; CLASS Quartiles; MODEL riskfactors_quartiles = Marijuana_Use Education_Status Poverty_Percent Frequent_Mental_Dist; RUN; QUIT; Then I cleaned up the table and merged it with my first table which has the means and standard deviations that was presented, but I mostly used ODS OUTPUT to manipulate my tables so it has the p value.     ... View more

My code is: OPTIONS VALIDVARNAME=ANY; PROC REG DATA=WORK.FIGURE (RENAME = outcomes_adults_mental_distr = Frequent_Mental_Distress) PLOTS(ONLY) = FITPLOT; LABEL Marijuana_Use = 'Percent of People Who Used Marijuana 1+ Days out of 30 Days'; 'Linear Regression'n: MODEL Frequent_Mental_Distress = Marijuana_Use / CLM CLI ALPHA=0.05; TITLE "Linear Regression of Frequent Mental Distress and Marijuana Use"; ODS SELECT FitPlot; RUN; TITLE; Thank you so much! I thought there was only like two procedures but good to know that there are more! ... View more

Thank you everyone, it appears that it is working again.   Thank you for all the solutions! ... View more

  1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 69 70 ODS RTF FILE = "/home/u63558208/Project One/CDPHE Data/5_Results/FinalProject.rtf" 71 STYLE=BARRETTSBLUE; NOTE: Writing RTF Body file: /home/u63558208/Project One/CDPHE Data/5_Results/FinalProject.rtf 72 73 74 TITLE1'Means and Standard Deviations of Demographics, Risk Factors, and Outcomes'; 75 PROC PRINT DATA=COLANLYS.TABLEONE LABEL NOOBS; 76 RUN;   NOTE: There were 4 observations read from the data set COLANLYS.TABLEONE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1568.40k OS Memory 27812.00k Timestamp 12/06/2023 04:15:29 PM Step Count 533 Switch Count 0 Page Faults 0 Page Reclaims 88 Page Swaps 0 Voluntary Context Switches 5 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0     77 TITLE; 78 79 80 TITLE1'ANOVA of Demographics, Risk Factors, and Outcomes'; 81 PROC PRINT DATA = COLANLYS.TABLETWO LABEL NOOBS; 82 RUN;   NOTE: There were 4 observations read from the data set COLANLYS.TABLETWO. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 766.15k OS Memory 27812.00k Timestamp 12/06/2023 04:15:29 PM Step Count 534 Switch Count 0 Page Faults 0 Page Reclaims 64 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0     83 TITLE; 84 FOOTNOTE "p-values > .05"; 85 FOOTNOTE; 86 87 88 TITLE1"Pearson's Correlation Between Demographics, Risk Factors, and the Outcome"; 89 PROC PRINT DATA=COLANLYS.TABLETHREE LABEL NOOBS; 90 RUN;   NOTE: There were 4 observations read from the data set COLANLYS.TABLETHREE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 687.53k OS Memory 27812.00k Timestamp 12/06/2023 04:15:29 PM Step Count 535 Switch Count 0 Page Faults 0 Page Reclaims 71 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0     91 TITLE; 92 93 ODS GRAPHICS ON; 94 ODS NOPROCTITLE; 95 PROC SGPLOT DATA=WORK.FIGURE; 96 VBOX outcomes_adults_mental_distr / CATEGORY=Quartiles FILLATTRS=(COLOR=LIGHTBLUE) BOXWIDTH=0.5; 97 TITLE BOLD "Boxplot of Quartiles of Marijuana Use and Frequent Mental Distress"; 98 XAXIS LABEL="Quartiles of Marijuana Use" VALUEATTRS=(WEIGHT=BOLD); 99 YAXIS LABEL="Frequent Mental Distress" VALUES=(0 TO 100 BY 10) OFFSETMIN=0; 100 REFLINE 70 / AXIS=Y LINEATTRS=(COLOR=BLUE); 101 REFLINE 90 / AXIS=Y LINEATTRS=(COLOR=BLUE) LABEL="HYPERTENSION THRESHOLD" LABELPOS=max; 102 YAXIS GRID; 103 INSET "Data Source: Colorado Study Data"/ POSITION=NW BORDER; 104 RUN;   NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.13 seconds user cpu time 0.06 seconds system cpu time 0.02 seconds memory 15736.25k OS Memory 40616.00k Timestamp 12/06/2023 04:15:29 PM Step Count 536 Switch Count 2 Page Faults 0 Page Reclaims 3677 Page Swaps 0 Voluntary Context Switches 466 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 768   NOTE: There were 64 observations read from the data set WORK.FIGURE.   105 TITLE; 106 107 108 ODS NOPROCTITLE; 109 OPTIONS VALIDVARNAME=ANY; 110 PROC REG DATA=WORK.FIGURE (RENAME = outcomes_adults_mental_distr = Frequent_Mental_Distress) 111 PLOTS(ONLY) = FITPLOT; 112 LABEL Marijuana_Use = 'Percent of People Who Used Marijuana 1+ Days out of 30 Days'; 113 'Linear Regression'n: 114 MODEL Frequent_Mental_Distress = Marijuana_Use / 115 CLM 116 CLI 117 ALPHA=0.05; 118 119 TITLE "Linear Regression of Frequent Mental Distress and Marijuana Use"; 120 ODS SELECT FitPlot; 121 RUN;   122 TITLE; 123 124 ODS GRAPHICS OFF; 125 ODS RTF CLOSE; 126 127 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;   ... View more

That would make so much sense, thank you! ... View more

Would that also be an alias variable or the original variable that I am looking at? ... View more