Help using Base SAS procedures

proc compare - Output difference with padded zero values

Reply
Occasional Contributor
Posts: 8

proc compare - Output difference with padded zero values

Hi,

 

I am trying to compare two datasets in sas using proc compare. One of the character variable is not matching and shows difference however when i actual see the record the values are correct. They are defined as below in both base and comparing data set.

 

Base dataset --VARIABLE1  ;TYPE-Char   Len-16  Format-$16.  Informat-$16.

 

Comp dataset --VARIABLE1  ;TYPE-Char   Len-23  Format-$23.  Informat-$23.

 

Also, attached is the output for couple of records.

 

Thank in advance.

 

Regards,

Super User
Posts: 10,238

Re: proc compare - Output difference with padded zero values

Posted in reply to Sunboyss30

To be sure, I'd add character variables of double length (eg 23 -> 46) and use put(...,$hex46.) format to convert the contents of your variables to hex notation. This allows detection of un-displayable characters or leading blanks.

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

Re: proc compare - Output difference with padded zero values

Posted in reply to KurtBremser

Hi,

 

Thanks for your reply. Actually the datasets are coming from two different databases Oracle and Teradata. And what if I dont want to change the format in the source datasets. Any other way of doing it.

 

Regards,

Super User
Posts: 10,238

Re: proc compare - Output difference with padded zero values

Posted in reply to Sunboyss30

I'd be MASSIVELY surprised if you could ever get a solid match in SAS when comparing ORACLE and TERADATA, as it involves three different environments.

Pull the tables into SAS, run the compare, and then investigate the differences. This might give you clues what processes are necessary (during the import into SAS) to get the tables to a "common denominator".

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 3 replies
  • 143 views
  • 0 likes
  • 2 in conversation