Good day I would like assistance in transforming this SQL code into a code suitable for SAS.   I am trying to identify email addresses that do not conform to the validation rules set out for a valid email address.   CASE  WHEN [EMAIL_ADRES_X] LIKE '%_@__%.__%' AND PATINDEX('\b[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,6}\b', [EMAIL_ADRES_X]) = 0 THEN 1 ELSE 0 END AS email_conformity FROM #T2    ... View more

Hello    I want to join multiple columns that have the same type of data, into 1 column so that I'm able to conduct analysis on just 1 column instead of multiple columns with the same type of data.   Below is an example of how the data is currently structured   item cat1  cat2  cat3  cat4  cat5  A    111   222   333   444   555    B    666   777   888   999   101              C    112   212   313   414   515  D    123   234   567   890   145        I want the data to look like this:   item cat1 A    111 A    222 A    333 B    666 B    777 B    888 C    999 C    555 C    101 D    789 D    456   Data Want; set Have ; cat 1 = cat 2; keep cat 1 ; run;   I would also like to know how to get the data back to the original structure once I've completed my analysis please ?     ... View more