I'm wondering what are some common approach for creating dummy ID based on known numerical ID? some of my expectations include:
dummy ID should be 1-1 mapped to real ID and no duplicate
should be reversible, meaning that knowing the dummy ID I should be able to get the real ID through some program
include some form of randomization
Can any please help provide some potential approaches I could use? thank you
here is a simple way to create a linkage to the records. But you have to keep the have dataset someplace safe that others who should not have access to it can not reach it.
data have(keep=myid name);
set sashelp.baseball;
MyID = _n_*2.5/3.67;
run;
apply some type of sort order would also assist in mixing things up.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.