topic Re: PROC TABULATE save/export SAS report to SAS dataset in SAS Programming

PROC TABULATE save/export SAS report to SAS dataset

yp2609 — Tue, 30 May 2023 20:56:46 GMT

I want to export/save results from SAS report to a SAS dataset to further manipulate it. Please help!

Re: PROC TABULATE save/export SAS report to SAS dataset

Reeza — Tue, 30 May 2023 21:14:25 GMT

proc tabulate has an OUT= option that will pipe the data/calculations to a data set. It will not be in the format shown though.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1hpbwr9acrbmen1e2d6hxjkotm1.htm#p08ap616k1v756n15ooi1w1fv1yu

@yp2609 wrote:

I want to export/save results from SAS report to a SAS dataset to further manipulate it. Please help!

Re: PROC TABULATE save/export SAS report to SAS dataset

yp2609 — Tue, 30 May 2023 21:45:28 GMT

Reeza, thank you! I know there is OUT= option, but I really want to keep the same formatting here. Anyway, I will try to figure a way out.

Re: PROC TABULATE save/export SAS report to SAS dataset

Reeza — Tue, 30 May 2023 21:49:14 GMT

You can use transpose with the _TYPE_ and other automatic variables to reformat the data. Your data is not complicated so you can do this fairly easily.

Re: PROC TABULATE save/export SAS report to SAS dataset

Reeza — Tue, 30 May 2023 21:54:03 GMT

Please post your code as text, pain to type it out and make sure the variables are correct, so generic code is below.

In general, just use proc means and a proc transpose to get what you need.

proc means data=have noprint nway;
class var1 var2 var3;
var amount;
output out=summary sum=;
run;

proc transpose data=summary;
by var1 var2;
id var3;
var amount;
run;

Re: PROC TABULATE save/export SAS report to SAS dataset

ballardw — Tue, 30 May 2023 21:54:53 GMT

Can you provide an example of the sort of manipulation you may want?

The limits of a SAS data set means that the layout appearance can't be stored. SAS data set variables hold a value. Columns of a report, depending on the syntax of a table, can contain the statistics from multiple variables. Which doesn't go well with the tabular view of a data set.

Re: PROC TABULATE save/export SAS report to SAS dataset

yp2609 — Tue, 30 May 2023 21:55:12 GMT

I'll give it a try. Thank you!