I am so sorry. The design technical specification says the following, if this explains better: Email variable: Description: Requires at least one character, @, at least one character, dot, at least one character. Space, comma, and semicolon are not permitted. Formula: Is Null OR ((Like "*? @?*.?*") AND (Not Like "*[ ,;]*")) Phone Variable: Description: Validates that the Phone number is in (999) 999-9999 format. This works by using the REGEX function to check that the number has ten digits in the (999) 999-9999 format. Formula: NOT (REGEX (Phone, "\\D*? (\\d\\D*?){10}")) Error Message: US phone numbers should be in this format: (999) 999-9999. Error Location: Phone Address Variable: Description: Validates the street address. It can have  Formula: AND ((REGEX (Address1,\d{1, 5}\s\w.\s(\b\w*\b\s){1,2}\w*\.”))) Error Message: No special characters in the last name. ... View more

Thank you, your solution works well for address values, however when it comes to phone values like +1-888-888-8888, here the + and - are not supposed to be removed or identified as special characters do to speak in this pattern which was happening when i tested it. Can you please help? ... View more

Thank you I found this code below on a random search.  The pattern below simply says "get rid of anything that isn't a letter or a number". Well this kinda removes fine, however I want to flag=1 if special characters exist, extract the special characters to assign them to Identified_Specialcharacters variable and then remove. But for phone columns, the code removes the valid '-'. and prefix '+' for values like 1-999-999-9999 data have;    input string :$20.; phone='+1-999-999-9999'; phone_check= prxchange('s/[^A-Z 0-9]//i',-1,phone);      address  = prxchange('s/[^A-Z 0-9]//i',-1,string); cards; AA5D16.6!I BETA.$$$1O CAP%^T&12.5T CONJ.*()625V1 DIGO.06_+=25T IV.D10W250 ; proc print;run; ... View more

Please mark the question as answered and award appropriate points for correct and helpful answers to Naveen and Jaap. Just courtesy! ... View more

My oh My!, missing out that one : in front of the informat was the issue and made the difference? dear o dear, jeez, what does : do here and it's functionality in general? Does that mean I will need to specify : before an informat every single time I use dsd option in the infile statement? ... View more

Ok here is an example, that is getting me rather confused: /*this code reads trxn numeric values correctly*/ data one; infile datalines dlm=',' ; /*using dlm','*/ input cust_id   date ddmmyy10. trxn nat $; cards; 1,10/01/2015,5000,dr 1,13/01/2015,2000,cr 1,15/01/2015,2000,dr 1,18/01/2015,2000,dr 1,21/01/2015,2000,cr 1,23/01/2015,2000,cr 1,24/01/2015,2000,cr 1,26/01/2015,2000,dr 1,28/01/2015,2000,dr 1,31/01/2015,2000,dr ; run; whereas the following code below with DSD incorrectly reads trxn and outputs all missing values data one; infile datalines dsd; input cust_id   date ddmmyy10. trxn nat $; cards; 1,10/01/2015,5000,dr 1,13/01/2015,2000,cr 1,15/01/2015,2000,dr 1,18/01/2015,2000,dr 1,21/01/2015,2000,cr 1,23/01/2015,2000,cr 1,24/01/2015,2000,cr 1,26/01/2015,2000,dr 1,28/01/2015,2000,dr 1,31/01/2015,2000,dr ; run; So, where did i go wrong in my understanding?Please help. I am using SAS EG 6.1 ... View more

Karun, Just like Arthur suggested, it would be best for you to research on the below link looking for SAS Functions and call routines. Ideally, a discussion on application orientated medium to complex queries is rather interestingly appreciated than merely asking answers on learning resources. Merry Christmas. Cheers from England, Andy http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212242.htm ... View more

Hi Dearest list of Gentleman-- Danielsantos, Hai kuo, Keith, RichardinOZ. I can't thank you enough for the amazingly overwhelming response. Splendid and Great approach. Simply Fantastic. Super awesome Cheers, Andy ... View more