Arrays in SAS RWI

analyst_work — Mon, 26 Mar 2018 17:34:25 GMT

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!

Re: Arrays in SAS RWI

Cynthia_sas — Tue, 27 Mar 2018 03:01:42 GMT

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

topic Re: Arrays in SAS RWI in ODS and Base Reporting

Arrays in SAS RWI

Re: Arrays in SAS RWI