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 (1693 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 (1809 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 (1810 views) | In reply to scb

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

Typo updated.

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →