SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
BrahmanandaRao
Lapis Lazuli | Level 10
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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
data aadhar ;
input aadhar $ 28.;
datalines ;
1727-8514-4648
;
run;


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

View solution in original post

4 REPLIES 4
Ksharp
Super User
data aadhar ;
input aadhar $ 28.;
datalines ;
1727-8514-4648
;
run;


data mask;
set aadhar;
new=prxchange('s/\d+/xxxx/',2,aadhar);
run;
BrahmanandaRao
Lapis Lazuli | Level 10

Hi 

Sharp

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

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

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1101 views
  • 0 likes
  • 3 in conversation