Hello,    I am attempting to count a variable up until a certain point. I have attached the code I have been trying to use below and have attached the table I have gotten thus far. Whenever I run this code, it will continue running and creating way more observations that I have.    DATA DisProj.Count; SET WORK.Loop; BY Person; LENGTH count 8; RETAIN count; DO UNTIL (Outpatient_MOUD = 1); IF FIRST.Person THEN count = 1; ELSE count = count+1; END; RUN;   For example, I would like to count the outpatient_MOUD variable UNTIL it reaches zero, and then stop counting. I only want the sum up to the first zero.    Any help is greatly appreciated! Thank you.    ... View more

Hello,    I am trying to create a SAS output table using PROC FREQ, and I only want the Test, DF, Value, and Prob columns. However, I need to rename the prob column to P-Value. Whenever I run the code below, I receive an error saying that the variable Prob does not exist.    ODS OUTPUT ChiSq = ChiSqResults (DROP = Table WHERE = (Statistic = 'Chi-Square') RENAME = (Prob = P-Value); PROC FREQ DATA = HypAnalysis2; TABLES HypRelDeathInd*StateCd / NOCUM NOCOL NOROW NOPERCENT CHISQ; RUN; PROC PRINT DATA = ChiSqResults NOOBS; RUN;   I would appreciate any help! Thank you.  ... View more

Hello,    I am attempting to convert this character variable called PriorWeight to a numeric variable called PriorWeight2. I have a range of weight for 292 observations, and am not sure how to include those within the If/Then statements. The range of weights include numbers from 87 to 319, with the last 4 observations having a ? as their PriorWeight, which is why I included the ELSE PriorWeight2 = .;   Here is my code:    /* Convert PriorWeight to a numeric variable */ IF PriorWeight = 87 - 319 THEN PriorWeight2 = INPUT(PriorWeight,3.); ELSE PriorWeight2 = . ; RUN;   I have also already tried (87:319), '87' - '319'.    Please let me know what you think!    ... View more