DATA Step, Macro, Functions and more

Strange Warning Message When Accessing a Dataset Through Data Step

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Strange Warning Message When Accessing a Dataset Through Data Step

Hi!

 

I'm using SAS 9.2 and I'm curious about a particular message in the log when accessing a particular dataset through data step.

 

When the data step is run, the log gives the following warning message

 

Data Step:

data aa;
set input.dataset;
run;

 

 

Message:

"WARNING: Integrity constraints cannot be processed for file INPUT.DATASET because its encoding

does not match the session encoding or the file is in a format native to another host,

such as HP_UX_64, RS_6000_AIX_64, SOLARIS_64, HP_IA64."

 

However, when I access the dataset through PROC SQL, it gave no such message.

 

PROC SQL:

proc sql;
  create table bb as 
    select * from input.dataset;
quit;

 

 

As such, what is the message trying to say? And more importantly, when coming across such a message, is it okay to ignore it and use PROC SQL instead?

 

 

Many thanks.

Ching Wee


Accepted Solutions
Solution
‎09-16-2016 01:13 AM
Super User
Posts: 7,762

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim

Integrity constraints are defined so that operations that change the dataset adhere to specific rules. Since you do not intend to write to the dataset, but only want to read from it, you can safely ignore that WARNING.

I would not be surprised if digging deeper lets us find a SAS system option that even suppresses such WARNINGs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Super Contributor
Posts: 266

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim
PROC Star
Posts: 1,759

Re: Strange Warning Message When Accessing a Dataset Through Data Step

@RahulG I dont how that link helps.

@ching_wee_lim I can't think of a reason why reading the table one way or another should yield different behaviours. Best to ask Tech support imho.

Trusted Advisor
Posts: 1,554

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim

The message says that the dataset was created on a different platform, eg. unix vs windows.

SAS recocnize the original platform and gives warning, just in case they are not completely compatible;

Usually you can ignore it until you find some suspicious fenomena as text conversion or something else.

New Contributor
Posts: 4

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Hi Shmuel!

 

Thanks for your insights! Sorry I'm new to SAS communities. I wanted to accept your answer as well but seems like I can only accept one Smiley Sad

Solution
‎09-16-2016 01:13 AM
Super User
Posts: 7,762

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim

Integrity constraints are defined so that operations that change the dataset adhere to specific rules. Since you do not intend to write to the dataset, but only want to read from it, you can safely ignore that WARNING.

I would not be surprised if digging deeper lets us find a SAS system option that even suppresses such WARNINGs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to KurtBremser

Thanks KurtBremser!

 

So just curious, if I would want to write into the dataset, I would have to find that particular rule that is causing the issue and fix it? And what are some examples of rules to fix?

Valued Guide
Posts: 2,177

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim
New Contributor
Posts: 4

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Posted in reply to ching_wee_lim

Thanks everyone for your insights! I shall accept KurtBremser's answer.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 435 views
  • 2 likes
  • 6 in conversation