Solved: SAS Base Query - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Obsidian | Level 7

Obsidian | Level 7

SAS Base Query

Posted 02-27-2017 04:53 AM (1110 views)

CustNo

12345671819

17289201010

May I know how to disguise the 5th to 8th digit of the CustNo from number to XXXX? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Diamond | Level 26

Diamond | Level 26

Re: SAS Base Query

Posted 02-27-2017 05:15 AM (1226 views) | In reply to scb

data want;
 custno="12345671819";
 substr(custno,5,4)="XXXX";
run;

Typo updated.

View solution in original post

1 REPLY 1

Diamond | Level 26

Diamond | Level 26

Re: SAS Base Query

Posted 02-27-2017 05:15 AM (1227 views) | In reply to scb

data want;
 custno="12345671819";
 substr(custno,5,4)="XXXX";
run;

Typo updated.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!