turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- General Programming
- /
- need to decrypt proc compare return code 3072.

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-28-2013 04:47 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Tushar

10-28-2013 05:59 AM

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.

Bit | Condition | Code | Hex | Description |
---|---|---|---|---|

1 | DSLABEL | 1 | 0001X | Data set labels differ |

2 | DSTYPE | 2 | 0002X | Data set types differ |

3 | INFORMAT | 4 | 0004X | Variable has different informat |

4 | FORMAT | 8 | 0008X | Variable has different format |

5 | LENGTH | 16 | 0010X | Variable has different length |

6 | LABEL | 32 | 0020X | Variable has different label |

7 | BASEOBS | 64 | 0040X | Base data set has observation not in comparison |

8 | COMPOBS | 128 | 0080X | Comparison data set has observation not in base |

9 | BASEBY | 256 | 0100X | Base data set has BY group not in comparison |

10 | COMPBY | 512 | 0200X | Comparison data set has BY group not in base |

11 | BASEVAR | 1024 | 0400X | Base data set has variable not in comparison |

12 | COMPVAR | 2048 | 0800X | Comparison data set has variable not in base |

13 | VALUE | 4096 | 1000X | A value comparison was unequal |

14 | TYPE | 8192 | 2000X | Conflicting variable types |

15 | BYVAR | 16384 | 4000X | BY variables do not match |

16 | ERROR | 32768 | 8000X | Fatal error: comparison not done |

Regards,

Tushar J.

All Replies

Solution

10-28-2013
05:59 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Tushar

10-28-2013 05:59 AM

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.

Bit | Condition | Code | Hex | Description |
---|---|---|---|---|

1 | DSLABEL | 1 | 0001X | Data set labels differ |

2 | DSTYPE | 2 | 0002X | Data set types differ |

3 | INFORMAT | 4 | 0004X | Variable has different informat |

4 | FORMAT | 8 | 0008X | Variable has different format |

5 | LENGTH | 16 | 0010X | Variable has different length |

6 | LABEL | 32 | 0020X | Variable has different label |

7 | BASEOBS | 64 | 0040X | Base data set has observation not in comparison |

8 | COMPOBS | 128 | 0080X | Comparison data set has observation not in base |

9 | BASEBY | 256 | 0100X | Base data set has BY group not in comparison |

10 | COMPBY | 512 | 0200X | Comparison data set has BY group not in base |

11 | BASEVAR | 1024 | 0400X | Base data set has variable not in comparison |

12 | COMPVAR | 2048 | 0800X | Comparison data set has variable not in base |

13 | VALUE | 4096 | 1000X | A value comparison was unequal |

14 | TYPE | 8192 | 2000X | Conflicting variable types |

15 | BYVAR | 16384 | 4000X | BY variables do not match |

16 | ERROR | 32768 | 8000X | Fatal error: comparison not done |

Regards,

Tushar J.