topic Re: Mask the numbers in SAS Programming

Mask the numbers

BrahmanandaRao — Mon, 09 May 2022 08:18:22 GMT

data aadhar ;
input aadhar $ 28.;
datalines ;
1727-8514-4648
;
run;


data mask;
set aadhar;
new=substr(aadhar,length(aadhar)-1,9)='xxxx';
run;

I want to mask the first 8 numbers

required output

xxxx-xxxx-4648

Kurt_Bremser — Mon, 09 May 2022 09:35:46 GMT

Will all values have the format of <4 digits><hyphen><4 digits><hyphen><4 digits>?

Ksharp — Mon, 09 May 2022 10:23:38 GMT

data aadhar ;
input aadhar $ 28.;
datalines ;
1727-8514-4648
;
run;


data mask;
set aadhar;
new=prxchange('s/\d+/xxxx/',2,aadhar);
run;

BrahmanandaRao — Mon, 09 May 2022 10:32:03 GMT

Sharp

Thank you for your solution I am not good at regular expressions

Ksharp — Mon, 09 May 2022 10:41:12 GMT

Then check documentation and learn it . It is a must-have skill for sas programmer .