- Get link
- X
- Other Apps
SET | WHERE | KEEP STATEMENTS WITH AN EXAMPLE
Add a DATA step before the PROC PRINT step to read the data set prog1.customer_dim to
create a new data set called Work.youngadult.
Modify the PROC PRINT step to refer to the new data set.
Submit the program and confirm that Work.youngadult was created with 77 observations and
11 variables.
DATA WORK.YOUNGADULT;
SET PROG1.CUSTOMER_DIM;
RUN;
PROC PRINT;RUN;
LOG:
NOTE: The data set WORK.YOUNGADULT has 77 observations and 11 variables.
Obs | Customer_ID | Customer_Country | Customer_Gender | Customer_Name | Customer_FirstName | Customer_LastName | Customer_BirthDate | Customer_Age_Group | Customer_Type | Customer_Group | Customer_Age |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 4 | US | M | James Kvarniq | James | Kvarniq | 27JUN1974 | 31-45 years | Orion Club members low activity | Orion Club members | 33 |
2 | 5 | US | F | Sandrina Stephano | Sandrina | Stephano | 09JUL1979 | 15-30 years | Orion Club Gold members medium activity | Orion Club Gold members | 28 |
3 | 9 | DE | F | Cornelia Krahl | Cornelia | Krahl | 27FEB1974 | 31-45 years | Orion Club Gold members medium activity | Orion Club Gold members | 33 |
4 | 10 | US | F | Karen Ballinger | Karen | Ballinger | 18OCT1984 | 15-30 years | Orion Club members high activity | Orion Club members | 23 |
5 | 11 | DE | F | Elke Wallstab | Elke | Wallstab | 16AUG1974 | 31-45 years | Orion Club members high activity | Orion Club members | 33 |
Add a WHERE statement to the DATA step to subset for female customers.
Submit the program and confirm that Work.youngadult was created with 30 observations and
11 variables.
DATA WORK.YOUNGADULT;
SET PROG1.CUSTOMER_DIM;
WHERE CUSTOMER_GENDER = "F";
RUN;
PROC PRINT;RUN;
LOG:
NOTE: The data set WORK.YOUNGADULT has 30 observations and 11 variables.
Obs | Customer_ID | Customer_Country | Customer_Gender | Customer_Name | Customer_FirstName | Customer_LastName | Customer_BirthDate | Customer_Age_Group | Customer_Type | Customer_Group | Customer_Age |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 5 | US | F | Sandrina Stephano | Sandrina | Stephano | 09JUL1979 | 15-30 years | Orion Club Gold members medium activity | Orion Club Gold members | 28 |
2 | 9 | DE | F | Cornelia Krahl | Cornelia | Krahl | 27FEB1974 | 31-45 years | Orion Club Gold members medium activity | Orion Club Gold members | 33 |
3 | 10 | US | F | Karen Ballinger | Karen | Ballinger | 18OCT1984 | 15-30 years | Orion Club members high activity | Orion Club members | 23 |
4 | 11 | DE | F | Elke Wallstab | Elke | Wallstab | 16AUG1974 | 31-45 years | Orion Club members high activity | Orion Club members | 33 |
5 | 24 | US | F | Robyn Klem | Robyn | Klem | 02JUN1959 | 46-60 years | Internet/Catalog Customers | Internet/Catalog Customers | 48 |
Modify the WHERE statement to subset for female customers whose Customer_Age is
between 18 and 36.
Submit the program and confirm that Work.youngadult was created with 15 observations and
11 variables.
DATA WORK.YOUNGADULT;
SET PROG1.CUSTOMER_DIM;
WHERE CUSTOMER_GENDER = "F" AND CUSTOMER_AGE BETWEEN 18 AND 36;
RUN;
PROC PRINT;RUN;
LOG:
NOTE: The data set WORK.YOUNGADULT has 15 observations and 11 variables.
Obs | Customer_ID | Customer_Country | Customer_Gender | Customer_Name | Customer_FirstName | Customer_LastName | Customer_BirthDate | Customer_Age_Group | Customer_Type | Customer_Group | Customer_Age |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 5 | US | F | Sandrina Stephano | Sandrina | Stephano | 09JUL1979 | 15-30 years | Orion Club Gold members medium activity | Orion Club Gold members | 28 |
2 | 9 | DE | F | Cornelia Krahl | Cornelia | Krahl | 27FEB1974 | 31-45 years | Orion Club Gold members medium activity | Orion Club Gold members | 33 |
3 | 10 | US | F | Karen Ballinger | Karen | Ballinger | 18OCT1984 | 15-30 years | Orion Club members high activity | Orion Club members | 23 |
4 | 11 | DE | F | Elke Wallstab | Elke | Wallstab | 16AUG1974 | 31-45 years | Orion Club members high activity | Orion Club members | 33 |
5 | 45 | US | F | Dianne Patchin | Dianne | Patchin | 06MAY1979 | 15-30 years | Orion Club Gold members low activity | Orion Club Gold members | 28 |
Modify the WHERE statement to subset for female 18- to 36-year-old customers who have the
word Gold in their Customer_Group.
Submit the program and confirm that Work.youngadult was created with 5 observations and
11 variables.
DATA WORK.YOUNGADULT;
SET PROG1.CUSTOMER_DIM;
WHERE CUSTOMER_GENDER = "F" AND
CUSTOMER_AGE BETWEEN 18 AND 36 AND
CUSTOMER_GROUP CONTAINS 'Gold';
RUN;
PROC PRINT;RUN;
LOG:
NOTE: The data set WORK.YOUNGADULT has 5 observations and 11 variables
Obs | Customer_ID | Customer_Country | Customer_Gender | Customer_Name | Customer_FirstName | Customer_LastName | Customer_BirthDate | Customer_Age_Group | Customer_Type | Customer_Group | Customer_Age |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 5 | US | F | Sandrina Stephano | Sandrina | Stephano | 09JUL1979 | 15-30 years | Orion Club Gold members medium activity | Orion Club Gold members | 28 |
2 | 9 | DE | F | Cornelia Krahl | Cornelia | Krahl | 27FEB1974 | 31-45 years | Orion Club Gold members medium activity | Orion Club Gold members | 33 |
3 | 45 | US | F | Dianne Patchin | Dianne | Patchin | 06MAY1979 | 15-30 years | Orion Club Gold members low activity | Orion Club Gold members | 28 |
4 | 49 | US | F | Annmarie Leveille | Annmarie | Leveille | 16JUL1984 | 15-30 years | Orion Club Gold members high activity | Orion Club Gold members | 23 |
5 | 2550 | ZA | F | Sanelisiwe Collier | Sanelisiwe | Collier | 07JUL1988 | 15-30 years | Orion Club Gold members low activity | Orion Club Gold members | 19 |
Modify the DATA step so that Work.youngadult contains only Customer_Name,Customer_Age, Customer_BirthDate, Customer_Gender, and Customer_Group.
Submit the program and confirm that Work.youngadult was created with 5 observations and 5
variables.
DATA WORK.YOUNGADULT;
SET PROG1.CUSTOMER_DIM;
WHERE CUSTOMER_GENDER = "F" AND
CUSTOMER_AGE BETWEEN 18 AND 36 AND
CUSTOMER_GROUP CONTAINS 'Gold';
KEEP CUSTOMER_NAME CUSTOMER_AGE CUSTOMER_BIRTHDATE CUSTOMER_GENDER CUSTOMER_GROUP;
RUN;
PROC PRINT;RUN;
LOG:
NOTE: The data set WORK.YOUNGADULT has 5 observations and 5 variables.
Obs | Customer_Gender | Customer_Name | Customer_BirthDate | Customer_Group | Customer_Age |
---|---|---|---|---|---|
1 | F | Sandrina Stephano | 09JUL1979 | Orion Club Gold members | 28 |
2 | F | Cornelia Krahl | 27FEB1974 | Orion Club Gold members | 33 |
3 | F | Dianne Patchin | 06MAY1979 | Orion Club Gold members | 28 |
4 | F | Annmarie Leveille | 16JUL1984 | Orion Club Gold members | 23 |
5 | F | Sanelisiwe Collier | 07JUL1988 | Orion Club Gold members | 19 |
COMMENT AND SHARE YOUR SYNTAX...
--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...
--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...
--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES
CLICK HERE : https://t.me/SasAll4You
- Get link
- X
- Other Apps
Comments
Post a Comment