topic Re: ODS problem in SAS Programming

ODS problem

gyambqt — Mon, 13 Apr 2015 05:55:41 GMT

Hello experts,

I tried to run the following program to produce xml output with two tabs in the excel. But it didn't work when I included "where" statement,

ODS LISTING CLOSE;
ODS tagsets.excelxp FILE="c:\example.xls";

ods tagsets.excelxp options(sheet_name="cars");

Proc print data=sashelp.cars;
where origin="Europe";
Run;

ods tagsets.excelxp options(sheet_name="class");

Proc print data=sashelp.class;
where Sex="Male";
Run;

ods tagsets.excelxp close;
ods listing;

Thanks

Kurt_Bremser — Mon, 13 Apr 2015 06:25:30 GMT

What does the log say?

ven — Mon, 13 Apr 2015 06:39:01 GMT

It worked if you use as below

where Sex="M";

gyambqt — Mon, 13 Apr 2015 08:07:16 GMT

Hi Kurt,

There is no error in the log.

The output file produced only contain 1 tab "Cars" whereas the other tab is missing.

gyambqt — Mon, 13 Apr 2015 08:08:18 GMT

I think you are right...

RW9 — Mon, 13 Apr 2015 08:19:21 GMT

Yes, good idea to have a look at the dataset. The string withing quotes needs to match exactly the string within the variable.

Kurt_Bremser — Mon, 13 Apr 2015 08:56:34 GMT

There is a LOT more than just error message(s) to be found in the log. I guess you will find a

NOTE: No observations were selected from data set SASHELP.CLASS.

NOTE: There were 0 observations read from the data set SASHELP.CLASS.

WHERE 0 /* an obviously FALSE WHERE clause */ ;

message in the log, which will give you a clue that the where condition is the culprit and must be examined in depth.

Kurt_Bremser — Mon, 13 Apr 2015 09:09:18 GMT

And be aware when inspecting your data that SAS may show you formatted values, while the where condition needs the raw, unformatted values to work.

gyambqt — Tue, 14 Apr 2015 00:13:41 GMT

I have double checked the dataset, the value "Male" is not in the dataset SAShelp.class. It uses "M".