107.SET | WHERE | KEEP | ASSIGNMENT STATEMENT | LIKE

      SET | WHERE | KEEP | ASSIGNMENT STATEMENT | LIKE 

DATA WORK.CUSTOMER;

         SET PROG1.CUSTOMER;

WHERE Customer_FirstName like 'M%';

KEEP CUSTOMER_ID Customer_FirstName Customer_LastName GENDER COUNTRY;

RUN;

PROC PRINT;

RUN;

OUTPUT:

Obs	Customer_ID	Country	Gender	Customer_FirstName	Customer_LastName
1	13	DE	M	Markus	Sepke
2	20	US	M	Michael	Dineley
3	75	US	M	Mikel	Spetz

DATA WORK.CUSTOMER02;

        SET PROG1.CUSTOMER;

NAME=Customer_FirstName||','||Customer_LastName;

KEEP CUSTOMER_ID Name Name GENDER COUNTRY;

RUN;

PROC PRINT;

RUN;

OUTPUT:

Obs	Customer_ID	Country	Gender	NAME
1	4	US	M	James ,Kvarniq
2	5	US	F	Sandrina ,Stephano
3	9	DE	F	Cornelia ,Krahl
4	10	US	F	Karen ,Ballinger
5	11	DE	F	Elke ,Wallstab
6	12	US	M	David ,Black
7	13	DE	M	Markus ,Sepke
8	16	DE	M	Ulrich ,Heyde
9	17	US	M	Jimmie ,Evans
10	18	US	M	Tonie ,Asmussen

NOTE: DUE TO LENGTH ISSUE I HAVE KEPT ONLY 10 OBSERVATIONS..

DATA CUSTOMER03;

        SET CUSTOMER02;

WHERE NAME LIKE '%,M%';

KEEP CUSTOMER_ID Name GENDER COUNTRY;

RUN;

PROC PRINT;

RUN;

OUTPUT:

Obs	Customer_ID	Country	Gender	NAME
1	27	US	F	Cynthia ,Mccluney
2	31	US	F	Cynthia ,Martinez
3	50	DE	M	Gert-Gunter ,Mendler
4	61	DE	M	Carsten ,Maestrini
5	54655	CA	F	Lauren ,Marx
6	70046	CA	M	Tommy ,Mcdonald

DATA CUSTOMER04;

        SET CUSTOMER;

WHERE NAME LIKE 'M%,D%';

KEEP CUSTOMER_ID Name GENDER COUNTRY;

RUN;

PROC PRINT;

RUN;

OUTPUT:

Obs	Customer_ID	Country	Gender	NAME
1	20	US	M	Michael ,Dineley

TRY AND COMMENT YOUR CODE...

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