topic Re: ods tagsets excelxp - want output of only one datasets in New SAS User

ods tagsets excelxp - want output of only one datasets

jeetendersinghc — Mon, 28 Jan 2019 19:17:34 GMT

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

Re: ods tagsets excelxp - want output of only one datasets

SuryaKiran — Mon, 28 Jan 2019 19:28:51 GMT

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;

Re: ods tagsets excelxp - want output of only one datasets

jeetendersinghc — Mon, 28 Jan 2019 19:33:19 GMT

Got it !!

Thanks,
Jeetender