cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SAScert
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to encrypt group ID with values from a dataset

by Calcite | Level 5 in SAS Health and Life Sciences
‎06-09-2011 01:35 PM
‎06-09-2011 01:35 PM
Yes, my IDs are always of the same length, and this solution worked! Thanks so much for your help! I used the following code, only thing different was, instead of cats function, I used concatenation with array values within the do loop - data want; groupid='AD245CD32'; length code: $2. j: $1. new_code $9.; retain new_code ''; array code(9) $ code1-code9; array temp(9) $ j1-j9; do i=1 to 9; temp(i)=substr(groupid, i, 1); code(i)=put(temp(i), $xwalk.); new_code=compress(new_code || code(i)); end; run; ... View more

Re: How to encrypt group ID with values from a dataset

by Calcite | Level 5 in SAS Health and Life Sciences
‎06-08-2011 07:48 PM
‎06-08-2011 07:48 PM
Thanks Reeza! This makes a lot of sense. In fact, I'd tried something similar though not same, trying to use put function for using user defined format. However, it is the part where I need to concatenate all substrings together that is throwing me off. Coz even if I use lag function to retain the last value of j or new_j, it will still give value for only last 2 characters, and not a combined string of all previous characters. Any suggestions on that one, please? Thanks again. ... View more

How to encrypt group ID with values from a dataset

by Calcite | Level 5 in SAS Health and Life Sciences
‎06-08-2011 06:29 PM
‎06-08-2011 06:29 PM
Hi, I have a task of encrypting group IDs using random values - either alphabet or number. I've created a format to map each of the 26 alphabets to a two digit random number, and each single digit number (0-9) to a two digit alpha-numeric random value, such that none of the values appear more than once. Now, the question is, how do I change the 9 digits of group ID to 18 encrypted digits based on the format values? e.g. proc format ; value $xwalk 'A' = '10' 'B' = '19' 'C' = '26' 'D' = '18' 'E' = '35' '1' = 'A0' '2' = 'B3' '3' = 'E8' '4' = 'Q9' '5' = 'I2' ; In this case, if my group ID is 'AD245', it should become '1018B3Q9I2' after encryption. I've tried using tranwrd function with do loop, but that doesn't allow me to read crosswalk values from a dataset or format. Please suggest what code I can use to get there. Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links