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
GE
vomiting 3 6 40
nausea 30 20 26
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?
GE
nausea
vomiting
Thanks for your time. What you said is acceptable. Please provide the code(an example) I will try to get the output.
Thank you
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.