i prepared 2 different datasets have and have2. i tried they are correct. if you want you can change data formats. /* part one */ data have; INPUT comment $ 30.; DATALINES; M10/21/46CADYA F11/11/50CLINEB M11/11/52SMITHA F10/10/80OPPENHEIMERB M04/04/60JOSEA ; RUN; PROC SQL; CREATE TABLE WORK.QUERY_FOR_HAVE AS SELECT /* gender */ (SUBSTR(t1.comment, 1, 1)) AS gender, /* birthday */ (SUBSTR(t1.comment,2,8)) AS birthday, /* status */ (substr(t1.comment,(LENGTH(t1.comment)),1)) AS status, /* name */ (substr(t1.comment,10, LENGTH(t1.comment)-10)) AS name FROM WORK.HAVE t1; QUIT; /* part two */ data have2; INPUT comment2 $ 30.; DATALINES; M10/21/46CODY155 F11/11/50CLEIN166 F11/11/52SMITH185 ; run; PROC SQL; CREATE TABLE WORK.QUERY_FOR_HAVE_2 AS SELECT /* gender */ (SUBSTR(t1.comment2, 1, 1)) AS gender, /* birthday */ (SUBSTR(t1.comment2,2,8)) AS birthday, /* status */ (substr(t1.comment2,(LENGTH(t1.comment2))-2,3)) AS status, /* name */ (substr(t1.comment2,10, LENGTH(t1.comment2)-12)) AS name FROM WORK.HAVE2 t1; QUIT;
... View more