topic Re: Proc print using hex8 format variable in SAS Procedures

Proc print using hex8 format variable

Jhan1 — Thu, 18 Apr 2019 14:05:28 GMT

Im sure there is a simple solution but i cant seem to figure it out and thought Id ask here.

Im working with a dataset with a numeric variable that has hex8 format. This happens to be a unique id for the data. Im simply wanting to take a look at a few observations using proc print. A tyoical id is a combination of letters and numbers hence i tried something similar to below.

Proc print dara = dataset;

Where unique_id in ("x12345z"); run;

This doesnt work as unique_id is actually a numeric variable. Any solution to work around this?

Thank you!

Re: Proc print using hex8 format variable

Astounding — Thu, 18 Apr 2019 14:11:10 GMT

The letters in a hex format are limited in scope ... you won't see an X or a Z. Presumably you know the right code to search for. Here is how you would search for A12345D:

where unique_id in (A12345Dx);

Re: Proc print using hex8 format variable

ballardw — Thu, 18 Apr 2019 14:28:53 GMT

You might show what you are seeing for the value. Hex really shouldn't have "x" or "Z". There should be no letters higher than F appearing.