topic porc print groups in SAS Procedures

porc print groups

bemariec — Mon, 21 Aug 2017 13:09:11 GMT

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!!

Re: porc print groups

RW9 — Mon, 21 Aug 2017 13:39:47 GMT

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;

Re: porc print groups

Shmuel — Mon, 21 Aug 2017 13:41:38 GMT

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

It will be usefull if you provide some test data.