Question: Using SAS: Modify the program to sort (alphabetically) first name within last (last first) by adding FIRST to the BY variables in the PROC SORT
Using SAS:
Modify the program to sort (alphabetically) first name within last (last first) by adding FIRST to the BY variables in the PROC SORT statement. DATA MYDATA; INPUT 1 LAST $20. 21 FIRST $20. Label LASTLast Name' FIRST = 'First Name' PHONE Phone Number'; DATALINES; 45 PHONE $12.; eingold Jones Abby Smith Zoll Baker Smith Smith Jones Lucius Pam Adams Bev Tim Bob Crusty John ArnoId Jackie 201-555-0987 987-555-2948 214-555-0987 213-555-0987 303-555-2309 222-555-3212 234-555-0987 234-555-2345 456-987-8077 - Modify to sort by first name within last (by last first); PROC SORT; BY LAST; PROC PRINT LABEL TITLE ABC Company; TITLE2 'Telephone Directory'; RUN Modify the program to sort (alphabetically) first name within last (last first) by adding FIRST to the BY variables in the PROC SORT statement. DATA MYDATA; INPUT 1 LAST $20. 21 FIRST $20. Label LASTLast Name' FIRST = 'First Name' PHONE Phone Number'; DATALINES; 45 PHONE $12.; eingold Jones Abby Smith Zoll Baker Smith Smith Jones Lucius Pam Adams Bev Tim Bob Crusty John ArnoId Jackie 201-555-0987 987-555-2948 214-555-0987 213-555-0987 303-555-2309 222-555-3212 234-555-0987 234-555-2345 456-987-8077 - Modify to sort by first name within last (by last first); PROC SORT; BY LAST; PROC PRINT LABEL TITLE ABC Company; TITLE2 'Telephone Directory'; RUN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
