117.INPUT | FORMAT | PROC FORMAT | LENGTH | SELECT STATEMENTS

    INPUT | FORMAT | PROC FORMAT | LENGTH | SELECT  STATEMENTS

DATA EMPLOYEES;

    INPUT Name $ Age Salary HireDate :date9.;

    FORMAT HireDate date9.;

    DATALINES;

        Alice 30 55000 15JAN2020

        Bob 28 48000 22FEB2019

        Carol 35 62000 10MAR2018

John 37 65000 12JAN2018

Emma 27 46000 20Jan2019

    ;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	Name	Age	Salary	HireDate
1	Alice	30	55000	15JAN2020
2	Bob	28	48000	22FEB2019
3	Carol	35	62000	10MAR2018
4	JohN	37	65000	12JAN2018
5	Emma	27	46000	20JAN2019

PROC FORMAT;

 VALUE SALFMT

        LOW - <55000 = "LOW"

55000 - <60000 = "MEDIUM"

60000 - HIGH   = "HIGH";

RUN;

OUTPUT:

DATA EMPLOYEES;

 SET EMPLOYEES;

 FORMAT SALARY SALFMT.;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	Name	Age	Salary	HireDate
1	Alice	30	MEDIUM	15JAN2020
2	Bob	28	LOW	22FEB2019
3	Carol	35	HIGH	10MAR2018
4	JohN	37	HIGH	12JAN2018
5	Emma	27	LOW	20JAN2019

DATA EMPLOYEES;

 LENGTH AgeGroup $8.;

 SET EMPLOYEES;

  SELECT;

   WHEN (AGE < 30) AgeGroup = "YOUNG";

   WHEN (AGE >=30 AND AGE > 40) AgeGroup = "MID-AGE";

   OTHERWISE AgeGroup = "SENIOR";

  END;

RUN;

PROC PRINT;

 VAR Name Age Salary HireDate AgeGroup;

RUN;

OUTPUT:

Obs	Name	Age	Salary	HireDate	AgeGroup
1	Alice	30	MEDIUM	15JAN2020	SENIOR
2	Bob	28	LOW	22FEB2019	YOUNG
3	Carol	35	HIGH	10MAR2018	SENIOR
4	JohN	37	HIGH	12JAN2018	SENIOR
5	Emma	27	LOW	20JAN2019	YOUNG

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