topic Re: proc report combine columns or add an item in SAS Programming

proc report combine columns or add an item

Andrea_Peng — Tue, 21 Jan 2020 07:36:07 GMT

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

Re: proc report combine columns or add an item

JeanDo — Tue, 21 Jan 2020 16:22:11 GMT

Hi,

Could you provide a sample of you input table please?

Regards,

Re: proc report combine columns or add an item

ballardw — Tue, 21 Jan 2020 18:36:57 GMT

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 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.

Re: proc report combine columns or add an item

PaigeMiller — Tue, 21 Jan 2020 18:49:51 GMT

@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.