topic how to work with %tablen () to do the analyze of the survey faster? in Statistical Procedures

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

bhr-q — Thu, 29 Aug 2024 00:40:03 GMT

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

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

ballardw — Thu, 29 Aug 2024 01:02:09 GMT

You will find links to the code here: https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-TABLEN/ta-p/634030 (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.

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

bhr-q — Thu, 12 Sep 2024 11:51:17 GMT

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, ....)

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

PaigeMiller — Thu, 12 Sep 2024 12:26:06 GMT

Go to your favorite internet search engine and type this:

TABLEN macro SAS

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

bhr-q — Thu, 12 Sep 2024 12:30:02 GMT

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

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

PaigeMiller — Thu, 12 Sep 2024 12:39:36 GMT

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.