I=92m pulling data from a database that is storing the date in a Date/Time
format.  I need to create a new dataset using a standard date format
(MM/DD/YYYY).  Is there a simple way to go from this 13JUL2006:00:00:00 to
this 07/13/2006 in PROC SQL?

Example Code I'm working with....

PROC SQL;
CREATE TABLE TEST AS
SELECT A.ID AS ID1, A.DOB AS DOB1, B.ID AS ID2, scan('B.DOB', -3, ':')
Format=3Dmmddyy8. AS DOB2
FROM MDSVERI.Assessment1 AS A FULL JOIN ACCESS.Table1 AS B
ON A.ID =3D B.ID;
QUIT;

I'm sure there is a simple answer I'm just not sure what it is.....
thoughts?