113.SET | ASSIGNMENT | UPCASE | LOWCASE | DROP | LENGTH | IF THEN OUTPUT

DATA NEW;

SET PROG1.SALES;

NAME=UPCASE(FIRST_NAME||""||LAST_NAME);

DROP FIRST_NAME LAST_NAME;

RUN;

PROC PRINT;

VAR Employee_ID NAME Gender Salary;

RUN;

OUTPUT:

Obs	Employee_ID	NAME	Gender	Salary
1	120167	KIMIKO TILLEY	F	25185
2	120168	SELINA BARCOE	F	25275
3	121101	BURNETTA BUCKNER	F	25390
4	121092	GYNELL PRITT	F	25680
5	120138	SHANI DUCKETT	F	25795
6	121047	KAREN GRZEBIEN	F	25820
7	.	LIBBY LEVI	F	25930
8	121036	TERESA MESLEY	F	25965
9	121051	GLORINA MYERS	F	26025
10	.	PATRICIA CAPRISTO-ABRAMCZYK	F	26080

NOTE: DUE TO OVER SPACE ONLY 10 OBSERVATIONS ARE DISPLAYED HERE..

DATA NEW01;

LENGTH GENDER $8;

SET NEW;

IF EMPLOYEE_ID="" THEN OUTPUT;

RUN;

PROC PRINT;

VAR Employee_ID NAME Gender Salary ;

RUN;

OUTPUT:

Obs	Employee_ID	NAME	GENDER	Salary
1	.	LIBBY LEVI	F	25930
2	.	PATRICIA CAPRISTO-ABRAMCZYK	F	26080
3	.	JUDY CHANTHARASY	F	26390
4	.	JULIANNA PHAIYAKOUNH	F	26520
5	.	WILLETA CHERNEGA	F	26830
6	.	PERRIOR BATAINEH	F	26930

DATA NEW02;

SET NEW01;

WHERE NAME LIKE 'J%';

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	GENDER	Employee_ID	Salary	Job_Title	Country	Birth_Date	Hire_Date	NAME
1	F	.	26390	Sales Rep. I	AU	5438	12054	JUDY CHANTHARASY
2	F	.	26520	Sales Rep. II	AU	-5519	5114	JULIANNA PHAIYAKOUNH

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

Sas All