PROC TABULATE save/export SAS report to SAS dataset

[yp2609]

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

[Reeza]

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#p08ap61...

---

@yp2609 wrote:

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

---

[yp2609]

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. 

[Reeza]

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.

[Reeza · Accepted solution]

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;

[yp2609]

I'll give it a try. Thank you!

[ballardw]

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.