Hello Everyone, I need help trying to find the count for the multi_event column. Here is a sample code and my output. I was able to get the count for event 1-4 only. I also want to count when event is in more than 1 column. data have; input event1 event2 event3 event4; datalines; . 1 . . 1 1 . . . . 1 . 1 . . 1 1 . . . . 1 . . . . 1 . . 1 1 1 . . . 1 1 . . . . . 1 1 ; run; SAS output   Row 2 and 4 met my criteria for multi_event so they were output in multi_event.  Row 8  and 11 met the criteria but did not output. I want row 8, 11 or any other row with multiple count to be in the multi_event column.  Here is my attempted code (My coding is not classic I will appreciate learning a better way to code it) data want; set have; if event1 ne . and event2=. and event3=. and event4=. then event1only=1; if event2 ne . and event1=. and event3=. and event4=. then event2only=1; if event3 ne . and event1=. and event2=. and event4=. then event3only=1; if event4 ne . and event1=. and event2=. and event3=. then event4only=1; if event1 ne . and (event2 ne . or event3 ne . or event4 ne . ) then multi_event=1; run; This is my final desired output is to be able to count each column like this with proc tabulate or report. Event1only Event2Only Event3Only Event4Only Multi_event 2 2  2 1 3           Thanks ... View more

A nova versão do SAS Enterprise Guide 8.4 pode se conectar com Viya 4. Veja neste artigo como fazer! ... View more