topic clear in SAS Programming

clear

HannaZhang — Mon, 24 May 2021 08:21:29 GMT

Re: Display of group variables in report process by defining

ChrisNZ — Tue, 20 Aug 2019 23:36:22 GMT

We can't quite make out the structure from the screenshot and the code, which seem to only be vaguely related. but this looks like a job for proc tabulate. What is the report structure you want?

Re: Display of group variables in report process by defining

HannaZhang — Wed, 21 Aug 2019 07:13:57 GMT

I don't know if the following picture can help you understand the report structure

Re: Display of group variables in report process by defining

ChrisNZ — Thu, 22 Aug 2019 04:15:40 GMT

I can't be bothered to try and guess what you need if you can't be bothered to explain and show usage examples.

I suggest you study this and modify as needed:

data HAVE;
  retain SOC PRO COL_T A_TR B_TR C_TR COL_R A_RT B_RT C_RT COL A_TOT B_TOT C_TOT 'A';
  output; output;
run;
proc tabulate missing;
  class SOC PRO COL_T A_TR B_TR C_TR COL_R A_RT B_RT C_RT COL A_TOT B_TOT C_TOT ;
  table PRO*n=' ',COL_T * ( A_TR  B_TR  C_TR  )
                  COL_R * ( A_RT  B_RT  C_RT  )
                  COL   * ( A_TOT B_TOT C_TOT ) ;
run;

		COL_T			COL_R			COL
		A			A			A
		A_TR	B_TR	C_TR	A_RT	B_RT	C_RT	A_TOT	B_TOT	C_TOT
		A	A	A	A	A	A	A	A	A
SOC	PRO	2	2	2	2	2	2	2	2	2
A	A	2	2	2	2	2	2	2	2	2

Re: Display of group variables in report process by defining

HannaZhang — Thu, 22 Aug 2019 07:52:21 GMT

Thanks，It helps a lot！