topic Re: ignore header in SAS Programming

ignore header

Caro17 — Sat, 07 Nov 2020 06:23:14 GMT

Hey,

I am using this code:

data want;

set order;

length order_no_str $100;

order_no_str = cats(put(lngorder_no, 8.),',');

run;

ods excel file='\\abc\agency\…\order2020.xlsx’;

proc print data=want;

run;

ods excel close;

How can I "delete" the header?

Do I really need proc print? It is not necessary to see it in SAS again. Can I suppress it?

Thanx!

Caro

Re: ignore header

Kurt_Bremser — Sat, 07 Nov 2020 06:53:41 GMT

If, by "header", y

Re: ignore header

Kurt_Bremser — Sat, 07 Nov 2020 06:56:44 GMT

If, by "header", you mean the page title, you can remove it by issuing an empty TITLE statement.

If you just want to bring your raw data to Excel, use PROC EXPORT with DBMS=XLSX, or LIBNAME XLSX instead of ODS EXCEL. ODS EXCEL is good mainly for "prettying up" the Excel spreadsheet.

Re: ignore header

Ksharp — Sat, 07 Nov 2020 10:43:26 GMT

1)
proc print data=want split='*' ;
run;

2)
proc report data=want nowd noheader ;
run;

Re: ignore header

Caro17 — Mon, 09 Nov 2020 06:31:36 GMT

"header" is the title of the column.

What do you mean by "empty TITLE statement"? Do you mean TITLE ''?

I still have the title of the column.

Re: ignore header

Caro17 — Mon, 09 Nov 2020 06:32:29 GMT

Neither 1) nor 2) leads to the wished result. I still have the title of the column.

Re: ignore header

andreas_lds — Mon, 09 Nov 2020 07:01:26 GMT

@Caro17 wrote:
Neither 1) nor 2) leads to the wished result. I still have the title of the column.

Please post the code you have used, because when i execute the following code the result is as expected:

ods excel file="dummy.xlsx";

proc report data=sashelp.class noheader;
run;

ods excel close;

Re: ignore header

Kurt_Bremser — Mon, 09 Nov 2020 07:04:25 GMT

So what you meant are the column headers. Title has, in SAS, a different connotation, meaning the page headers created through the TITLE statements.

As @Ksharp suggested, you can suppress the column headers in PROC REPORT with the NOHEADER option.

This code

ods excel file='/folders/myfolders/class.xlsx';

proc report data=sashelp.class noheader;
run;

ods excel close;

created a sheet like this: