Solved: reverse concat

[Monica Perry]

Thanks to everyone for your help and ideas. This is what  I ended up
using, based on Siraj's syntax.   I was getting errors regarding the
comma placed inbetween the (SSN) sections, so I inserted substr before
each section and then it worked fine.

string ssn_r (a9).
compute ssn_r = concat
(substr(ssn,1,3),substr(ssn,5,2),substr(ssn,8,4)).
execute.

**********************************************
Siraj's Syntax:
If this is the case then use this one

STRING SSN_NEW (A9) .
COMPUTE SSN_NEW = CONCAT (SUBSTR (SSN,1,3),(SSN,5,2),(SSN,8,4))  .
EXECUTE .
**********************************************
Thanks again!
-Monica


Monica Perry
Title 1 Program Specialist
Pitt County Schools, Greenville NC
[phone]