Arrays in SAS RWI

[analyst_work]

Hi,

I am trying to produce a report in SAS RWI for 10 different hospitals.

I have variables named Patient_1, Patient_2... Patient_n (n is different for each hospital). This is a numeric variable,

In the report, I am trying to create new character variables called Patient_Day_1 , Patient_Day_2 etc. The data should look like this:

Patient_1 Patient_Day_1 Patient_2 Patient_Day_2 Patient_3 Patient_Day_3

     0             Day 0                  1             Day 1              4               Day 4

Is there an easy way to do this in RWI?

If not, how can I do this without using RWI?

Thank you!

[Cynthia_sas]

Hi:
Depending on the structure of the data, you might be able to do this in PROC PRINT, PROC REPORT or RWI. Was there something about RWI that you needed in particular?

What code have you tried? What does your data structure look like. What does your final report look like? You said you have 10 different hospitals to report on. Were you going to use BY group processing?

What is the final destination of your output? HTML? PDF?

Cynthia