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: Using SAS: Modify the program to sort (alphabetically) first name within

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!