topic Re: Proc report help in SAS Programming

Proc report help

knveraraju91 — Tue, 24 Jan 2017 18:07:45 GMT

Yesterday I posted this one. One of the support suggested me to look for examples. I didnot find similar one. Please help thanks.

What should I add to my code get output. Thank you.

code;

proc report data=one;
column code text ns100 ns200 ns300;
define code/order;
define text/order;
run;

data1

text NS\100 NS\200 NS\300 code

joint pains 10 20 30 Rheumatic

knee pains 5 20 25 Rheumatic

vomiting 3 6 40 GE

nausea 30 20 26 GE

headche 4 5 22 Cardiac

chest pain 20 20 30 Cardicac

Output table needed;

term NS\100 NS\200 NS\300

_________________________________________________________________

Cardiac

headche 4 5 22

chest pain 20 20 30

Rheumatic

Joint pains 10 20 30

knee pains 5 20 25

vomiting 3 6 40

nausea 30 20 26

Re: Proc report help

ballardw — Tue, 24 Jan 2017 18:53:13 GMT

If you really want two different variables to appear in the same column that is a LOT of extra work especially if the row with the code value is not supposed to have any summary. Is it acceptable to have a summary for the code group?

And is the display order within the values of Text critical? Example would this be acceptable?

nausea

vomiting

Re: Proc report help

knveraraju91 — Tue, 24 Jan 2017 19:01:11 GMT

Thanks for your time. What you said is acceptable. Please provide the code(an example) I will try to get the output.

Thank you

Re: Proc report help

Cynthia_sas — Tue, 24 Jan 2017 19:08:52 GMT

Hi:
This is something you can accomplish with PROC REPORT. You would have to define CODE as an ORDER item with the NOPRINT option and then, in the column for TEXT, you would write the CODE value before the first value for TEXT. There's an example using SASHELP.SHOES below. If you have pre-summarized data, then the same technique will work with ORDER variables as well as GROUP variables.
cynthia