BookmarkSubscribeRSS Feed
saskapa
Quartz | Level 8

Hi,

 

I a m facing a strange issue with some of my data sets, that I am QCing.

 

Both me and an external users are working on those input data sets. Surprisingly, some  special character ( that are printable), that is $...are displayed in my sas system but it is not show by the external user. For example,  values like 1+,3+,>100 are displayed as $ in my   data sets, while in the external user, those $ signs are not shown. Example, like for instance >100 appears as $$100.

 

I have added a screenshot that show the difference in character display between me and external user of the same data set.

 

Following things to consider/observed:

 

1.the data sets were created in Linux environment

2. My environment is X64_R

3. External user's host is SunOS

4. In the screenshot, you can see that the external's  translated $ have an unusual bigger font size, and even a different font.

5. I have contacted the external user, and  they are  not aware of any issue; they don't  see the $ sings

6. both are on UTF-8 ( don't think its relevant here)

 

My question is  hence :

 

What can I do, in order to unmask/recover the true character hidden by $$ ? If ever it is possible to recover...

 

 

 

Thanks

 

Kapa

 

2 REPLIES 2
ballardw
Super User

Some of this type of content may have to go back to how the data is originally brought into SAS. Details like source file encoding, SAS session encoding and instructions on reading the data can have pretty big impact on the content of variables in this world of ASCII, UTF-8, UTF-16 and use of single or double byte character sets.

 

Another is what SAS Format(s) are associated with the variables?

 

This may mean providing an example of data that shows this behavior (need not be sensitive real data, just demonstrate the behavior) and how the data is read. If this is brought into SAS from an external database system then options on both the DBMS and SAS may need to be shared.

 

Also, you may want to describe how the "external user" is accessing this data. Are they reading reports or files created by exporting data, using a file viewer or what.

 

And my organization policies don't allow opening ZIP files from unknown parties. So posting images as @Kurt_Bremser indicates is the way to go. You should also describe what is making those images and which application is the source of the image.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 293 views
  • 0 likes
  • 3 in conversation