need to decrypt proc compare return code 3072.

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

need to decrypt proc compare return code 3072.

Hi All,

while doing proc compare with two sas dataset, i got error with proc compare return code 3072. I tried to decrypt it to binary but not able to understand the exact reason and respective code. i tried from below pdf link.

http://support.sas.com/resources/papers/proceedings12/063-2012.pdf

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146743.htm

Also the binary code of 3072 is 00110011 00110000 00110111 00110010

Please help me to provide the proper reason or to understand the logic behind this.

Regards,

Tushar J.


Accepted Solutions
Solution
‎10-28-2013 05:59 AM
Frequent Contributor
Posts: 88

Re: need to decrypt proc compare return code 3072.

Hi All,

sorry guys it was my mistake, i was doing ascii to binary and not Decimal to binary. Return code always come in decimal. So if i convert my decimal value to binary then it is 110000000000. so 11th and 12th digit showing true that is value 1. so as per below table cause of my return code is

1) Base data set has variable not in comparison and  2) Comparison data set has variable not in base.

BitConditionCodeHexDescription
1DSLABEL10001XData set labels differ
2DSTYPE20002XData set types differ
3INFORMAT40004XVariable has different informat
4FORMAT80008XVariable has different format
5LENGTH160010XVariable has different length
6LABEL320020XVariable has different label
7BASEOBS640040XBase data set has observation not in comparison
8COMPOBS1280080XComparison data set has observation not in base
9BASEBY2560100XBase data set has BY group not in comparison
10COMPBY5120200XComparison data set has BY group not in base
11BASEVAR10240400XBase data set has variable not in comparison
12COMPVAR20480800XComparison data set has variable not in base
13VALUE40961000XA value comparison was unequal
14TYPE81922000XConflicting variable types
15BYVAR163844000XBY variables do not match
16ERROR327688000XFatal error: comparison not done

Regards,

Tushar J.

View solution in original post


All Replies
Solution
‎10-28-2013 05:59 AM
Frequent Contributor
Posts: 88

Re: need to decrypt proc compare return code 3072.

Hi All,

sorry guys it was my mistake, i was doing ascii to binary and not Decimal to binary. Return code always come in decimal. So if i convert my decimal value to binary then it is 110000000000. so 11th and 12th digit showing true that is value 1. so as per below table cause of my return code is

1) Base data set has variable not in comparison and  2) Comparison data set has variable not in base.

BitConditionCodeHexDescription
1DSLABEL10001XData set labels differ
2DSTYPE20002XData set types differ
3INFORMAT40004XVariable has different informat
4FORMAT80008XVariable has different format
5LENGTH160010XVariable has different length
6LABEL320020XVariable has different label
7BASEOBS640040XBase data set has observation not in comparison
8COMPOBS1280080XComparison data set has observation not in base
9BASEBY2560100XBase data set has BY group not in comparison
10COMPBY5120200XComparison data set has BY group not in base
11BASEVAR10240400XBase data set has variable not in comparison
12COMPVAR20480800XComparison data set has variable not in base
13VALUE40961000XA value comparison was unequal
14TYPE81922000XConflicting variable types
15BYVAR163844000XBY variables do not match
16ERROR327688000XFatal error: comparison not done

Regards,

Tushar J.

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 226 views
  • 0 likes
  • 1 in conversation