Hi, all
I use the EG client to read the remote SAS server's data and add a Query Builder node to the workspace. I want to select a variable's distinct value, just like this:
proc sql;
createtable work.query_for_dg_t_c_sfs_smsinf as
selectdistinct t1.returncontent1
from work.query_for_dg_t_c_sfs_smsinf_0000 t1;
quit;
When I open then output data, an error occurs!
at SAS.IDataSet.ReadRecords(Int32 Flags, Int32 BindKey, Array& PositionBookmark, Int32 NumberRowsToRead, Int32 RowsOffset, Array& CharacterValues, Array& NumericValues, Array& MissingNumericValues, Array& Bookmarks, Int32& Status)
at SAS.EG.DataAccess.DataModel.DaForSasData.CommonReadPage(Int32 record, Boolean formatted, Int32 readFlags, Int32 offset, Byte[] positionBookmark, Byte[]& bookmarks, Int32& recordsRead)
at SAS.EG.DataAccess.DataModel.DaForSasData.ReadPage(Int32 record, Boolean formatted)
at SAS.EG.DataAccess.DataModel.DaForSasData.GetCell(Int32 record, Int32 fieldIndex, Boolean formatted)
at SAS.EG.DataAccess.DataModel.DaForSasData.GetNativeValue(Int32 fieldIndex)
at SAS.EG.DataAccess.DataModel.DataAccessor.GetFormattedAndNativeCellValue(Int32 columnIndex, String& formattedValue, Object& nativeValue)
at SAS.EG.GridDataModelInterface.GridDataModelInterfaceClass.GetFormattedAndRawValue(Int32 rowIndex, Int32 columnIndex, Object& rawValue)
at SAS.EG.DataGrid.DataGridClass.getCellValue(Int32 RowIndex, Int32 ColIndex, Object& rawValue)
at SAS.EG.DataGrid.DataGridClass.OnQueryCellInfo(GridQueryCellInfoEventArgs e)
This isn't an area I'm an expert in, but I'm pretty sure the problem is that your server file contains characters that are causing problems for the SAS session initiated by Enterprise Guide.
If you google 'Failed to transcode data' you'll get a lot of hits that describe this problem. Here are a couple of links that might get you started:
http://support.sas.com/documentation/cdl/en/nlsref/61893/HTML/default/viewer.htm#a002604646.htm
http://www.sascommunity.org/wiki/Tips:Handling_Transcoding_Error
Tom
This isn't an area I'm an expert in, but I'm pretty sure the problem is that your server file contains characters that are causing problems for the SAS session initiated by Enterprise Guide.
If you google 'Failed to transcode data' you'll get a lot of hits that describe this problem. Here are a couple of links that might get you started:
http://support.sas.com/documentation/cdl/en/nlsref/61893/HTML/default/viewer.htm#a002604646.htm
http://www.sascommunity.org/wiki/Tips:Handling_Transcoding_Error
Tom
Thanks!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: