Hello, I'm trying to count total aspirin dosages per patient in a dataset for which each patient has one entry per day.  Code is below. As you can probably gather, I'm getting counts of 1 in each "count' cell rather than an incremental total for each patient. Any help you might provide would be appreciated. Thanks.   DATA Count; SET Medications; BY Patient; IF First.Patient THEN DO; IF Medication = 'Aspirin' THEN DO; Count = 0; Count + 1; IF LAST.SubjectNumber; END; END; RUN; ... View more

To begin with, I understand the basics of 1/1/1960 as the 'base' for all dates in SAS programming, so no need to elaborate on that. What I don't understand is what my code is doing to change the dates back to that date from what I'm trying to input. Any guidance you may provide is greatly apprecated.   DATA study; SET chart; IF Sequence_No_ = 'A01-02' THEN DO; Best = 2; Best_Date = 09/11/2017; Prog_Date = 09/11/2017; END; ELSE IF Sequence_No_ = 'A01-03' THEN DO; Best = 2; Best_Date = 11/28/2017; Prog_Date = 11/28/2017; END; FORMAT Best_Date MMDDYY.10 Prog_Date MMDDYY10. RUN;   What I get back is: Sequence_No         Best_Date        Prog_Date A01-02                    01-01-1960       01-01-1960 A01-03                    01-01-1960       01-01-1960   Again, I get the significance of 1-1-1960. All I need is the correct code so that I get the dates I want. Thanks! ... View more