Handbook of SAS DATA Step Programming

162 Handbook of SAS

®

DATA Step Programming

title 'The use of SCAN, SUBSTR(right of =) andINDEXfunctions';

proc print data = ex9_9;

var name fname lname id newid gender comments;

run;

Output from Program 9.9:

The use of SCAN, SUBSTR(right of =) and INDEX functions

Obs name fname lname

1 DANIEL THOMAS DANIEL THOMAS

2 WILLIAM BROWN WILLIAM BROWN

3 MICHAEL JONES MICHAEL JONES

4 CHARLES WILSON CHARLES WILSON

5 BETTY YOUNG BETTY YOUNG

6 DOROTHY LEE DOROTHY LEE

7 DEBORAH HILL DEBORAH HILL

8 MARK WHITE MARK WHITE

9 MARIA CLARK MARIA CLARK

10 LINDA MILLER LINDA MILLER

11 SANDRA KING SANDRA KING

Obs id newid gender comments

1 135M 135 M sleep OK

2 478M 478 M Booming; sleep OK

3 511M 511 ...