BookmarkSubscribeRSS Feed
ICL1986
Fluorite | Level 6

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?

6 REPLIES 6
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

ICL1986
Fluorite | Level 6

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.

ChrisHemedinger
Community Manager

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.

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
ICL1986
Fluorite | Level 6

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. 

ChrisHemedinger
Community Manager

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?  

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
ICL1986
Fluorite | Level 6

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1069 views
  • 0 likes
  • 3 in conversation