ods tagsets excelxp - want output of only one datasets

[jeetendersinghc]

Hi,

I want the output of of only second datasets "test2" in excel file. However i am getting the output of test as well as test 2 also. Can you please suggest me what changes i need to have in my program to have the correct output. 

proc sort data=diagnosis out=diag;
by patid;
run;


ods tagsets.excelxp file="location of excel file\test.xml" style=sasweb;

ods tagsets.excelxp options (sheet_name="less threshold count"
								embedded_titles="yes"
								sheet_interval="none");
proc freq data=diag;
tables patid/out= test list missing;
run;

data test2;
set test;
if count le 5 then count = .t ;
run;



ods tagsets.excelxp close;

The reason for getting output of "test2" is that i want to replace the count of population with T which has less than 10 count.

Thanks,

Jeetender

[SuryaKiran]

What you print in the ODS destination will be in your result.

Change to this:

proc sort data=diagnosis out=diag;
by patid;
run;
proc freq data=diag;
tables patid/out= test list missing;
run;

data test2;
set test;
if count le 5 then count = .t ;
run;

ods tagsets.excelxp file="location of excel file\test.xml" style=sasweb;

ods tagsets.excelxp options (sheet_name="less threshold count"
								embedded_titles="yes"
								sheet_interval="none");
proc print data=test2 noobs;
run;

ods tagsets.excelxp close;

[jeetendersinghc]

Got it !!

Thanks,
Jeetender