Thanks so much @Shmuel for helping to explain the function of each code. ... View more

Hi @Kurt_Bremser.   I am trying to learn by following your code. Could you tell me about total_patients? There was no mention of the variable earlier in the code... Does total create a command implicitly, just like sum?   Thanks! ... View more

Thank you @Kurt_Bremser! I will try to re-work my code to make it more ideal -- still learning at this point. Do you have any good sources on how to create macros and how to line everything up to see typos easily? ... View more

That fixed the problem. Thank you @Shmuel! ... View more

Thanks @DarthPathos, @Shmuel, and @Kurt_Bremser! SAS can be a stressful experience to say the least.   Best, David ... View more

I tried to use your code, but received the following error:   244 data le.leDxTest2 (keep=id hasdiag visitcount diag YEAR eupide DISCHNO ADMDT DISDT ADMWK 244! DISCHWK ADMHR DISHR AGE1 AGE DOB SEX ETHNIC Insurance RACE_M RACE DISP REIMB HOSPCO 244! FACNAME PATST PATCO PATCITY RESIND 245 SDDISCH HSA REG ZIP OPER OPTIME1 OPTIME TOTCHG TOTANCHG TOTCHG1 TOTANCHG1 245! SEQ CNT DX01 DX02 DX03 DX04 DX05 DX06 DX07 DX08 DX09 DX10 HCPCCD1 HCPCCD2 HCPCCD3 246 HCPCCD4 HCPCCD5 HCPCCD6 HCPCCD7 HCPCM1 HCPCM2 HCPCM3 HCPCM4 HCPCM5 HCPCM6 246! HCPCM7 HCPC2M1 HCPC2M2 HCPC2M3 HCPC2M4 HCPC2M5 HCPC2M6 HCPC2M7 DISCHNO1 HCPCCD8 247 HCPCCD9 HCPCCD10 HCPCCD11 HCPCCD12 HCPCCD13 HCPCCD14 HCPCCD15 HCPCCD16 247! HCPCCD17 HCPCCD18 HCPCM8 HCPCM9 HCPCM10 HCPCM11 HCPCM12 HCPCM13 HCPCM14 HCPCM15 HCPCM16 248 HCPCM17 HCPCM18 HCPC2M8 HCPC2M9 HCPC2M10 HCPC2M11 HCPC2M12 HCPC2M13 248! HCPC2M14 HCPC2M15 HCPC2M16 HCPC2M17 HCPC2M18 Side Discharge Died CPI visit) totalcount 248! (keep=total_patients); 249 set le.leDxTest1 end=done; 250 retain total_patients 0 visitcount hasdiag; 251 if first.eupide 252 then do; 253 visitcount = 0; 254 hasdiag = 0; 255 end; 256 if diag then do; 257 visitcount + 1; 258 hasdiag = 1; 259 end; 260 if last.eupide then do; 261 output result; ------ 455 ERROR 455-185: Data set was not specified on the DATA statement. 262 total_patients + hasdiag; 263 end; 264 if done then output totalcount; 265 run; WARNING: The variable id in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set LE.LEDXTEST2 may be incomplete. When this step was stopped there were 0 observations and 111 variables. WARNING: Data set LE.LEDXTEST2 was not replaced because this step was stopped. WARNING: The data set WORK.TOTALCOUNT may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.TOTALCOUNT was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.01 seconds   Do you know why this may be a problem? Thank you! ... View more

Fantastic! The problem was the diagnoses codes were character, not number variables as there are some codes starting with letters. Putting the codes in quotations allowed it to work. Thank you so much! This helped to answer #1 and #3 of my output. ... View more