how to work with %tablen () to do the analyze of the survey faster?

[bhr-q]

Hello All,

I want to run this macro

 %tablen( DATA =tmp1, by= VV ,
VAR = histo histo_new left_para right_para tumor_clin tumor_imaging tumor_path residual doimm doi doi_new lvsi lvsi_new vag vag_new margins marg_new marg_locn marg_locn_new para para_new ln_involve total_pos total_count,
TYPE = 2 2 1 1 1 1 1 2 1 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1,
PVALS= 2 2 3 3 3 3 3 1 3 0 1 0 1 0 2 0 2 0 2 0 2 2 3 6, SHOWPVAL =1) ;

but I dont have the defined macro, any helo appreciated to figure out how to run that

Thanks

[ballardw · Accepted solution]

You will find links to the code here: https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-... (and historical versions)

I would not say it makes "analysis" go any faster. What that macro does is make report tables in a particular structure  (that personally I dislike because it places two values in single variables) but is apparently "standard" for some industry's or publications.

[bhr-q]

Hello, Thanks for your answer, I think there would be any file to include before calling %tablen, where can I find that?
for instance in this link I can see only
%tablen(data=example, by=arm, ....)

[PaigeMiller]

Go to your favorite internet search engine and type this:

TABLEN macro SAS

[bhr-q]

Thanks for your answer, I did that but wasn't sure about the right file. I wanted to get from SAS community if possible.

[PaigeMiller]

 I seriously doubt anyone here in the SAS Community knows the link to %TABLEN off the top of their head. I strongly suspect that anyone in the SAS Community who needs to get that macro will use an internet search engine to find it.