Unable to read SAS report file

[Rose]

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...

[Cynthia_sas]

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

[Ksharp]

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

[Rose]

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..