ods excel output

Anita_n — Sat, 06 Feb 2021 13:12:41 GMT

Dear all,

I have two SAS tables. The first table contains data for early patient records

and second the data for late stages of patient records.

I want to output the data from both tables in one excel sheet as below:

I tried using 2 proc print statements, the result is written quiet in one excel table but in two different sheets. I want the output one below the other as in this example. Here my SAS code. I will appreciate any help

ods excel file='mypath\myexcelfile.xlsx';

proc print data= data_early;
run;

proc print data= data_late;
run;
ods excel close;

	Stage I	Stage II	Stage III	Stage IV
early	34	6	9	134

	metas (IV)	leg (I-III)
late	12	L_III	D_I_II
		6	1

Re: ods excel output

tarheel13 — Sat, 06 Feb 2021 20:19:32 GMT

Ods excel options(sheet_interval=“None”).

This will put them on the same sheet.

Re: ods excel output

Anita_n — Sun, 07 Feb 2021 09:35:16 GMT

Thanks it worked

topic ods excel output in SAS Programming

ods excel output

Re: ods excel output

Re: ods excel output