Comparison Of SAS datasets from different platforms

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Comparison Of SAS datasets from different platforms

Hi,

 

How do I compare a SAS dataset produced in mainframes environment with a SAS dataset produced in Linux environment? Can a simple PROC COMPARE do this or Do I need to convert either fo the datasets as teh operating systems are different.

 

 

Thanks.

Vijay.


Accepted Solutions
Solution
‎09-06-2016 02:25 AM
Occasional Contributor
Posts: 12

Re: Comparison Of SAS datasets from different platforms

Posted in reply to KurtBremser

Thanks Kurt....It helps...

View solution in original post


All Replies
Super User
Posts: 9,294

Re: Comparison Of SAS datasets from different platforms

Posted in reply to vijayanand

Once you have managed to move the datasets into a common environment with the proper tools (eg proc cport/cimport), the transcoding of characters should be done.

Just run the proc compare and see what happens.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 12

Re: Comparison Of SAS datasets from different platforms

Posted in reply to KurtBremser

Thanks for the answer Kurt.

 

Transcoding of Characters should be done......Didn't get what it means. Shoudl something be done before using PROC COMPARE?

Super User
Posts: 9,294

Re: Comparison Of SAS datasets from different platforms

Posted in reply to vijayanand

Transcoding is what happens when data is moved between platforms with different character sets (eg EBCDIC and ASCII). proc cport/cimport can handle that.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Solution
‎09-06-2016 02:25 AM
Occasional Contributor
Posts: 12

Re: Comparison Of SAS datasets from different platforms

Posted in reply to KurtBremser

Thanks Kurt....It helps...

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 378 views
  • 0 likes
  • 2 in conversation