Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!

Arrays in SAS RWI

Reply
Contributor
Posts: 23

Arrays in SAS RWI

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!

SAS Super FREQ
Posts: 9,436

Re: Arrays in SAS RWI

Posted in reply to nehuvarma
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
Ask a Question
Discussion stats
  • 1 reply
  • 115 views
  • 0 likes
  • 2 in conversation