12. LABELS AND FORMATS
1.LABELS::: IT CHANGE THE APPEARANCE OF VARIABLES
EG:: STRTDT=====START DATE GENDER=====SEX
2.FORMATS::: TO "WRITE" THE DATA
3.INFORMATS::: TO "READ" THE DATA
2. SAS FORMATS:- ARE IN CHARACTER $,
NUMERIC &
DATE
CHARACTER: FIRST_NAME $2.
NUMERIC: SALARY 15.2
SALARY 12.2(25185.00)
COMMA12.2 (25,185.00)
COMMAX12.2 (25.185,00)
DOLLER12.2 ($25,185.00)
EURO12.2 (e25,185.00)
EUROX12.2
3.DATE FORMATS:-
12-03-2023
DDMMYY6. 8. 10.(120323,12-03-23,12-03-2023)
MMDDYY6. 8. 10.
WORDDATE. MARCH 12 2023
WEEKDATE. MONDAT MARCH 12 2023
DATE7. 12MAR23
DATE9. 12MAR2023
YEAR. 2023
QTR. 1........4:1 qtr
MONYY. MAR2023
DAY: 1 - 31 DAYS
MONTH: 1 - 12(4MONTHS --1 QTR(4 QTR)) 1234--1 5678--2 9101112--3
YEAR-1996
WEEKDAY: MONDAY-SUNDAY
QUARTERS: 1 - 4
DATA WEW;
SET SASHELP.CLASS;
LABEL NAME='STUDENT NAME'
SEX='GENDER'
AGE='STUDENT AGE';
RUN;
PROC PRINT DATA=WEW LABEL;
RUN;
PROC PRINT DATA=SASHELP.CLASS LABEL;
LABEL NAME='STUDENT NAME'
AGE='STUDENT AGE';
RUN;
DATA SAS12;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT FIRST_NAME $3. SALARY COMMA13.2;
RUN;
PROC PRINT DATA=SAS12 LABEL;
RUN;
DATA SAS1;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT FIRST_NAME $4. SALARY COMMAX13.2;
RUN;
PROC PRINT DATA=SAS1 LABEL;
RUN;
DATA SAS22;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT FIRST_NAME $4. SALARY DOLLAR13.2;
RUN;
PROC PRINT DATA=SAS22 LABEL;
RUN;
DATA SAS4;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT FIRST_NAME $2. SALARY EUROX13.3;
RUN;
PROC PRINT DATA=SAS4 LABEL;
RUN;
DATA SAS5;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE DDMMYY6.;
RUN;
PROC PRINT DATA=SAS5 LABEL;
RUN;
DATA SAS6;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE DDMMYY8.;
RUN;
PROC PRINT DATA=SAS6 LABEL;
RUN;
DATA SAS7;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT FIRST_NAME $4. SALARY DOLLAR13.2 HIRE_DATE DDMMYY10.;
RUN;
PROC PRINT DATA=SAS7 LABEL;
RUN;
DATA SAS8;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE BIRTH_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT BIRTH_DATE HIRE_DATE WORDDATE.;
RUN;
PROC PRINT DATA=SAS8 LABEL;
RUN;
DATA SAS9;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE BIRTH_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT SALARY DOLLAR12.3 BIRTH_DATE HIRE_DATE WEEKDATE.;
RUN;
PROC PRINT DATA=SAS9 LABEL;
RUN;
DATA SAS33;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE BIRTH_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT BIRTH_DATE HIRE_DATE DATE7.;
RUN;
PROC PRINT DATA=SAS33 LABEL;
RUN;
DATA SAS44;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE BIRTH_DATE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT BIRTH_DATE HIRE_DATE DATE9.;
RUN;
PROC PRINT DATA=SAS44 LABEL;
RUN;
DATA SAS44;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE BIRTH_DATE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT BIRTH_DATE HIRE_DATE DATE11.;
RUN;
PROC PRINT DATA=SAS44 LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE QTR.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT SALARY COMMAX10.2 HIRE_DATE DDMMYY10.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT SALARY EUROX12.5 HIRE_DATE DATE7.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
WHERE COUNTRY='AU' AND JOB_TITLE CONTAINS 'Rep';
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE DATE9.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE WEEKDATE.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE WORDDATE.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
DATA SAS;
SET PROG1.SALES;
KEEP FIRST_NAME LAST_NAME SALARY JOB_TITLE HIRE_DATE;
LABEL JOB_TITLE='SALES EMP TITILE'
HIRE_DATE='HAIRED DATE EMP'
SALARY='EMP SALARY';
FORMAT HIRE_DATE MONYY.;
RUN;
PROC PRINT DATA=SAS LABEL;
RUN;
PROC PRINT DATA=PROG1.SALES LABEL;
LABEL JOB_TITLE='SALE TITLE';
FORMAT BIRTH_DATE WEEKDATE.;
RUN;
PLEASE FOLLOW THE BLOG AND ENCOURAGE TO POST MORE ......
Comments
Post a Comment