Hello- this is my first post in this community and hoping for some help, if I need to adjust anything about my style of posting, please let me know and I will adjust! I am working with a healthcare dataset that involves many variables (some char, some numeric) that represent checkboxes in a database. For example, one would tick off all the applicable options to capture what outcome a patient may have ( 1 being Admitted, 2 being Discharged, etc.). I am trying to produce simple frequency counts for each option ( 406 patients were Admitted, 189 patients were Discharged etc. ) and have made formats to convert each number into the corresponding character string. However, observations that have more than one option chosen don't apply the format (if a patient was Transferred then Discharged, and both options were chosen, outputs as '2,5' not 'Transferred,Discharged'). I was thinking of using PRXMATCH to pick up instances of each number and creating secondary accumulating variables for each option, but am not sure thats most efficient . I've attached screenshots of the resulting frequency tables, and copy & pasted my code. Any guidance would be appreciated! /***************************************************/ proc format; value $status 1='Admitted' 2='Discharged' 3='Transferred' 4='Left AMA' 5='Expired' 6='Unknown' 7='Eloped'; run; proc freq data=nonfatal.final; format status_ednf_nnf1 $status.; tables status_ednf_nnf1; run; /*******************************/
... View more