I have a messy dataset where I have up to 16 iterations of a variable Result1-Result16. Some people in the dataset only have a few iterations, some have 16 and everywhere in between. I'm trying to create a result summary variable that takes into account each of these versions. The Result variable is in number form and I have a format for it that interprets what the numbers mean, I'm not sure if that matters for the coding. When interpreting the result options into the SummaryResult variable I'd like to create, some only match up with one interpretation but others should be grouped together since they mean essentially the same thing for the SummaryResult variable. For example: A result of 100 means UNKNOWN A result of 200 means NO But then a result of 300, 400, 500, etc means YES Many are also missing with . as the result, so the ResultSummary should be . also   To complicate matters, I can't just look at the last/highest iteration of Result because the correct/best ResultSummary may not be there, it could be the first or middle or last. The ResultSummary should be determined by a hierarchy: If there are any results that mean YES, the ResultSummary variable should be YES. If there are no YES results, but there is at least one NO, the ResultSummary variable should be NO. If there are no YES or NO results, but there is at least one UNKNOWN, the ResultSummary variable should be UNKNOWN. If . is the only result for all iterations of Result for that person, the ResultSummary should be . (missing).    Here is a fake example: Person Result1 Result2 Result3 Result4 Result5 SummaryResult 111 . . 100 . 100 UNKNOWN 112 200 200 . . 500 YES 113 . . 100 200 200 NO 114 . . . . . . 115 . 300 100 100 400 YES   I know only basics about assays from a class about 6 years ago and I just can't wrap my head around how I could get it to check each iteration while not keeping the last version instead of the best summary based on the hierarchy.    Thank you for any help!! ... View more

I'm trying to follow the code on this site Test for the equality of two proportions in SAS - The DO Loop for the section called A chi-square test for association in SAS. I basically need to compare the proportion in one area which was tested for something to the proportion in another area which was tested and see if they are significantly different proportions, but I can't get the code to work right. I get this error:     NOTE: Invalid data for N in line 79 1-6. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 79 CountyB Yes 71 Group=CountyA Seq=No N=. _ERROR_=1 _N_=2 NOTE: SAS went to a new line when INPUT statement reached past the end of a line.   My full code is:    data underfive; length Group $15 Test $3; input Group Test N; datalines; CountyA Yes 55 CountyA No 45027 CountyB Yes 71 CountyB No 311726;   Once I had that in I figured I would run this:   proc freq data=underfive order=data; weight N; tables Group*Test/chisq; run; ... View more

I am trying to transpose from wide to long because I have 30 variables (dx1-dx30) which I'd like to put into one column with a different row for each dx variable. I want all other variables in that dataset copied for each row for those dx variables. I was able to do most of this (my dx variables worked the way I want them to and it created a new row for each of them etc) but the other variables which I'd like copied into the other rows are only being filled into the first row. In the rows for dx2-dx30, it just has a period for the other variables.   This is the code I have:   Proc transpose data=totranspose2016 out=transposed2016 name=diagnosis prefix=code; By uniqueadmission; copy patientuhin cdiff primary readmit agecat died; /*want these copied to each corresponding row but only shows on first row for each uniqueadmission number, then has a period for these variables in all the other rows*/ Var dx1-dx30; /*I want these to go from being 30 different columns to one column with one row for each dx number - this part worked*/ Run;   Is it possible to change this so the variables listed in the copy statement are copied to all of the corresponding rows? ... View more