Exporting the data from proc means from HTML to sas7bdat and changing output name

[Phil_NZ]

Hi SAS Users!

When I use PROC MEANS, the results created by SAS EG is under HTML form, can I ask how come we change this result to sas7bdat form? 

Because when I run the code

      proc means data=argentina_ n nmiss mean p1 median p99 std min max;
      run;

It turn out a result like that

My concern is the output name HTML- 10.out macro where 10.out macro is the name of the project. Now I want to change from HTML to sas7bdat and 10.out macro to argentina__ (cats(argentina_,"_")).

Could you please give any suggestion?

Many thanks and warm regards.

[Reeza · Accepted solution]

Depends a bit on exactly how you want the data outputted, there are many options to control it. 

Assuming you just want what you see, make sure to use the STACKODS option.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=p17h6q7...

proc means data=sashelp.class STACKODSOUTPUT;
class sex;
var weight height;
ods output summary=stacked;
run;

Data is saved to a data set called STACKED.

---

@Phil_NZ wrote:

Hi SAS Users!

When I use PROC MEANS, the results created by SAS EG is under HTML form, can I ask how come we change this result to sas7bdat form? 

Because when I run the code

      proc means data=argentina_ n nmiss mean p1 median p99 std min max;
      run;

It turn out a result like that

My concern is the output name HTML- 10.out macro where 10.out macro is the name of the project. Now I want to change from HTML to sas7bdat and 10.out macro to argentina__ (cats(argentina_,"_")).

Could you please give any suggestion?

Many thanks and warm regards.

---