Hello,   I have a simple question about making binary variables from an array.  Sample data and code are below. I believe my code will categorize Case 3 as 'first' and then it doesn't keep reading to SERVICE_EXTENDER2 to also include it as having a 'second.'  I tried using "else" in the code but that didn't help.  I'm sure there's an easy solution...   Case   SERVICE_EXTENDER1   SERVICE_EXTENDER2    SERVICE_EXTENDER3    SERVICE_EXTENDER4 1          first       2         second 3          first                                      second 4          first   data want; set have; array SERVICE_EXTENDER [4] $ SERVICE_EXTENDER1-SERVICE_EXTENDER4; do z=1 to 4; if SERVICE_EXTENDER [z]='first' then new_variable='first'; if SERVICE_EXTENDER [z]='second' then new_variable='second'; end; run; proc freq data=want; tables new_variable*case_control / missing; run; Thanks laura  ... View more

Hello,   I created a new variable called "Indem" that is a mean (sum/N) in proc SQL and it works. However, I'd like to get a standard deviation from this mean. I think there is a function within proc sql that is STD but I don't see sample code for it on the SAS website. Does anyone know where it goes and how to format?   Many thanks!!! Laura   proc sql; create table cpc as select Paid, Sum(Indemnity)/count(CASE_ID) as Indem, from datahave group by Paid; quit;     ... View more

Hello,   I'm really struggling to program a few arrays and would love some help!  Right now, the data looks like this:   Case ID     Comorbidity1   Comorbidity2  Comorbidity3 1               Diabetes            Heart failure     Lung disease 2               HTN       3               Diabetes            Glaucoma     data want; data have; array COMORBIDITY [3] COMORBIDITY1-COMORBIDITY3; do a=1 to 3; if COMORBIDITY [a] > ' ' then do; diagnosis = COMORBIDITY[a]; end; end; run; proc freq order=freq data=want; tables diagnosis; run;     I would like to know the frequency of diagnoses in the cohort of 3 people regardless of whether the diagnosis is sitting in column 1-3.    For example: Diabetes 2 HTN 1 Glaucoma 1 Heart failure 1 Lung Disease 1    However, I think I'm just getting the last value...   My questions are: 1) Should I make a new data file called "diagnosis" and use proc transpose to make it into a long format? 2) Should I use syntax _temp_ to make a temporary long file instead of wide? 3) How would an output statement after the "end; end;" change what I get? 4) Should I use proc sql instead of the above?   Thanks! ... View more

Hello,   I'm using SAS 9.4 full edition. I have an array LM1-LM23 in which I'd like to find the most frequent field overall (in the test data below, it's "Done". The fields in the real data are character variables.     Case  LM1            LM2          LM3         LM4....LM23 1        Done           .                 .               . 2        Not done    .                  .               . 3        Done          Finishing    Not Done  Done 4        Done          Started           .              . 5        Done          Done         Done        Done 6        Done          Done          Done       .   Goal output Done           11/15          Not Done     2/15 Finishing      1/15 Started         1/15   Will this array coding only pull the first instance of the field?  Someone is getting different numbers from me so I don't think this array is coded correctly. array Contrib [23] $ LM1-LM23; do p=1 to 23; if Contribution [p] > ' ' then do; factor = Contribution [p]; end; end; proc freq order=freq; tables factor; run;   Thanks for the help! ... View more