topic Unable to read SAS report file in SAS Procedures

Unable to read SAS report file

Rose — Wed, 15 Dec 2010 12:43:54 GMT

I was trying to create a temperory table from a SAS dataset using proc sql.
The code was like

proc sql ;
create table t1 as
select columnA from tableA;
quit;

I got the error ERROR: CLI cursor fetch error: [SAS/ACCESS to SQL Server][ODBC SQL Server Driver]Unicode conversion failed.

Also an error message box saying Unable to read SAS report file.

Please help on this...

Re: Unable to read SAS report file

Cynthia_sas — Wed, 15 Dec 2010 19:01:34 GMT

Hi:
You may have 2 different issues. The SAS Report message is outlined in this Tech Support note (are you using EG???):
http://support.sas.com/kb/39/198.html

If you search on support.sas.com using the search string:
CLI cursor fetch error

you will come up with over 30 hits. These are a few notes from the first hits:
http://support.sas.com/kb/13/396.html
http://support.sas.com/kb/8/642.html

cynthia

Re: Unable to read SAS report file

Ksharp — Thu, 16 Dec 2010 01:43:55 GMT

From your log ,there is some illegal character for your SAS.
And I also meet this problem before.

Can you extract some first several observations from this dataset successfully? Such as

[pre]
data temp;
set tableA(obs=2);
run;
[/pre]

If It can. Then use
[pre]
proc report data=tableA nowd out=New_TableA(drop=_break_);
column coulmnA;
define coulmnA/display;
run;
[/pre]

to transfer to new SAS.

This is just a.recommendation

Ksharp

Re: Unable to read SAS report file

Rose — Thu, 16 Dec 2010 06:00:02 GMT

Thanks for the input.. I created a temperory dataset with required columns only. Then used that dataset in my query. It worked fine without the error..