Hi All - The SHA256 function seems to work if I pass it a value directly - output from below is: 43E7361624A78AE87E9F8F36D1E2E88D92C861DFDE61672FA301952A1DE044D9 It is 100% correct SHA256 value. data hashingtest;
length hash $ 64;
format hash $hex64.;
set HP_LEADS.lm_leads_details;
hash = SHA256('A00783126');
put hash;
run; But if I try to SHA256 an entire column of data the values are wrong and in some cases are way short of expected value length - same account number from columnar results - with code below: ED9440F53E640CD7588D92160103734E33770E5AA6158C9991B5E558686F5780 data hashingtest;
length hash $ 64;
format hash $hex64.;
set HP_LEADS.lm_leads_details;
hash = SHA256(accountnumber);
put hash;
run I am not a SAS expert by any means but would appreciate any direction on this one. I've checked my values at this website https://passwordsgenerator.net/sha256-hash-generator/ And doublecheck results using a Microsoft Access macro (no laughing :-|) So I'm confident the second code set results are not SHA256. Thanks in advance, Patrick
... View more
