proc report combine columns or add an item

[Andrea_Peng]

Hi,

I want to get a table like the this:

How can I put the top column ("Recruitment" and "Post-Recruitment") in the report? I used proc report to make it but did not succeed.

Thanks,

Andrea

[JeanDo]

Hi,

Could you provide a sample of you input table please?

Regards,

JD

[ballardw]

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

It would also be a good idea to show the code you have attempted so far.

[PaigeMiller · Accepted solution]

---

@Andrea_Peng wrote:

How can I put the top column ("Recruitment" and "Post-Recruitment") in the report? I used proc report to make it but did not succeed.

---

Do you mean the top ROW?

Something like this in PROC REPORT

columns group ("Recruitment" declined currently consented) 
    ("Post-Recruitment" Completed partially Pending);

where variables are assumed to be named DECLINED CURRENTLY CONSENTED etc.