Desktop productivity for business analysts and programmers

Results in Enterprise Guide '???'

Reply
Occasional Contributor
Posts: 16

Results in Enterprise Guide '???'

I'm running queries across a pretty large dataset, but there seems to be an issue with the processing, so 20-30 rows of the query output come out with all columns as '???'. I've looked back to the source data, and there doesn't seem to be a problem there. Anyone have any ideas?

Super User
Super User
Posts: 9,196

Re: Results in Enterprise Guide '???'

Are those columns numerics formatted, such as dates, datetimes etc.  That is where you normally get this where the width of the column is not big enough to show the full formatted value of an underlying numeric data.  If you look at the dataset and move the column width it should show.

Occasional Contributor
Posts: 16

Re: Results in Enterprise Guide '???'

The '???' is across all columns, regardless of data type and length, and the results above and below are displaying normally. As a bit of further information, when I'm scrolling through the data, it seems to pause slightly before getting to the data with the '???'. Not sure if this helps.

Community Manager
Posts: 3,351

Re: Results in Enterprise Guide '???'

I'm guessing that this might be an encoding problem.  The original data might contain some national characters that don't fit in your SAS session encoding, so the representation of these chars is "?".  If you can, try running your SAS session with ENCODING=UTF8 (that might be an admin task to set up).

 

SAS Enterprise Guide is a full Unicode application, so virtually all character sets can be represented.  But the SAS session is often pinned to one codepage or encoding, so information is literally "lost in translation".  UTF-8 (a form of Unicode) is the best option for SAS sessions.

Occasional Contributor
Posts: 16

Re: Results in Enterprise Guide '???'

Posted in reply to ChrisHemedinger

Thanks,

 

I'm currently set up for the utf-8 encoding so that shouldn't be an issue. I've managed to isolate the column with the data that appears to be screwing things up. It occaisionally contains cyrillic characters, and seems to be imported in from the source excel files without any issues, but then has issues after querying. 

Community Manager
Posts: 3,351

Re: Results in Enterprise Guide '???'

Any user-defined formats applied to that column, by chance?  Does a small PROC PRINT to HTML produce the same output?  Or is this limited to the data grid view?  

Occasional Contributor
Posts: 16

Re: Results in Enterprise Guide '???'

Posted in reply to ChrisHemedinger

Hmm, it's really odd but even when changing the default results settings to HTML, the report will only produce the data grid.

Ask a Question
Discussion stats
  • 6 replies
  • 411 views
  • 0 likes
  • 3 in conversation