Help using Base SAS procedures

porc print groups

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

porc print groups

Hi!

 

I am trying to make a table printed listing few variables (numeric and character). I know how to use one of the variable in the "by" statement so I have 5 different tables (example: in the variable 1, I have 5 different values, so I seperate my 5 tables by grouping them in these 5 values).

 

My question is: in each of the 5 tables, I want an other variable (TEST)  to be the group indicator in the first column. I dont want any math to be done with the values, I only want to make a list (Proc tabulate makes a sum and I don't want that!). Se the picture.

 

Can you help me please?

 

Thanks a lot!!

 


Accepted Solutions
Solution
‎08-21-2017 09:52 AM
Super User
Super User
Posts: 9,599

Re: porc print groups

Its a good idea to post test data in the form of a datastep, and show in the post what you want to the output to look like.  It looks to me like a simple group statement in proc report:

proc report data=have nowd;
  by test_var;
  columns test_var a b;
  define test_var / group " ";
  define a...
run;

View solution in original post


All Replies
Solution
‎08-21-2017 09:52 AM
Super User
Super User
Posts: 9,599

Re: porc print groups

Its a good idea to post test data in the form of a datastep, and show in the post what you want to the output to look like.  It looks to me like a simple group statement in proc report:

proc report data=have nowd;
  by test_var;
  columns test_var a b;
  define test_var / group " ";
  define a...
run;
Trusted Advisor
Posts: 1,837

Re: porc print groups

According to your docx picture, try to use PROC REPORT.

 

It will be usefull if you provide some test data.

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 193 views
  • 1 like
  • 3 in conversation