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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.