115.SET | WHERE | KEEP STATEMENTS WITH AN EXAMPLE

             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.


OUTPUT:
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.


OUTPUT:
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.


OUTPUT:
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


OUTPUT:
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.


OUTPUT:
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 READ AND COMMENT THE BLOG...

--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



Comments