I am a fairly new user to SAS and have discovered some issues I can't get my head around. I am working with a huge transactional data set. I first created a data set that included a hashed customer identifier along with a new purchase column that was sorted in descending order. I became curious with the observation that came to the top of this list. So, I was interested in revealing the rest of the variables from the original data set that went along with this top customer's purchases (SKUs, date/time of purchase, etc). Here's an example of what I entered (I'm just looking for the first entry for now since this is a huge data set and takes a long time to run.) proc sql inobs=1; select * from ben.<datasetname> where <identifier> like "3B342DC8"; run; The result every time is not an error code but a blank results page. The hashed customer identifier is of type hexadecimal and I'm wondering if that's what's causing my problems. I have also tried the contains statement as well as % and _ to solve this issue and find out if there are any wild cards that I can't see. No luck. Any ideas? Thank You! Ben
... View more