SAS Learning Hub

                                FORMAT | WHERE STATEMENTS PROC FORMAT;   VALUE  $COUNT   'AU' = 'AUSTRALIA'                   'US' = 'UNITED STATES'   'UK' = 'UNITED KINGDOM'; RUN; PROC FORMAT LIBRARY=WORK FMTLIB;; RUN; OUTPUT:                                                                       The SAS System DATA WORK.SALES;   SET PROG1.SALES;   WHERE COUNTRY IN ('AU');   FORMAT COUNTRY $COUNT.; RUN; PROC PRINT; RUN; OUTPUT:                                                         ...

           CONCATENATING THE VARIABLES | IF THEN DO STATEMENT DATA CLASS; SET PROG1.CLASS; Student_Name=First_Name||Last_Name; DROP First_Name Last_Name; PROC PRINT; VAR Employee_ID Student_Name Gender Salary Job_Title Country Birth_Date Hire_Date; RUN; OUTPUT:                                                                                                                                 The SAS System Obs Employee_ID Student_Name Gender Salary Job_Title Country Birth_Date Hire_Date 1 120102 Tom Zhou M 108255 Sales Manager AU 11AUG1969 06/01/1989 2 120103 Wilson Dawes M 87975 Sales Manager AU 22JAN...

                              CREATING DATASET | IF THEN DELETE DATA TEMP;  INPUT ID NAME $ SALARY DEPARTMENT $14.;  LABEL ID = 'Employee ID'; DATALINES; 1 Rick 623.3 IT 2 Dan 515.2 Operations  3 Michelle 611 IT 4 Ryan 729 HR 5 Gary 843.25 Finance 6 Nina 578 IT 7 Simon 632.8 Operations 8 Guru 722.5 Finance 9 Rajiv 920 HR 10 Sarika 740 HR ;  RUN; PROC PRINT;RUN; OUTPUT:                                                                       The SAS System Obs ID NAME SALARY DEPARTMENT 1 1 Rick 623.30 IT 2 2 Dan 515.20 Operations 3 3 Michelle 611.00 IT 4 4 Ryan 729.00 HR 5 5 Gary 843.25 Finance 6 6 Nina 578.00 IT 7 7 Simon 632.80 Operations 8 8 Guru 722.50 Fi...

        CREATING MULTIPLE DATASETS | IF THEN OUTPUT STATEMENT    DATA TEMP;  INPUT ID NAME $ SALARY DEPARTMENT $14.;  LABEL ID = 'Employee ID'; DATALINES; 1 Rick 623.3 IT 2 Dan 515.2 Operations  3 Michelle 611 IT 4 Ryan 729 HR 5 Gary 843.25 Finance 6 Nina 578 IT 7 Simon 632.8 Operations 8 Guru 722.5 Finance 9 Rajiv 920 HR 10 Sarika 740 HR ;  RUN; PROC PRINT;RUN; OUTPUT:                                                                The SAS System Obs ID NAME SALARY DEPARTMENT 1 1 Rick 623.30 IT 2 2 Dan 515.20 Operations 3 3 Michelle 611.00 IT 4 4 Ryan 729.00 HR 5 5 Gary 843.25 Finance 6 6 Nina 578.00 IT 7 7 Simon 632.80 Operations 8 8 Guru 722.50 Finance 9 9 Rajiv 920.00 HR 10 10 Sarika 740.00 HR DATA ...

            MISSING DATA | INPUT STATEMENT | IF THEN DO STATEMENT DATA MISSING_DATA;  INPUT NAME : $15. AGE : $3. DEPARTMENT : $30. SALARY : $5.;  CARDS;  SAISRI 16 PHYSICS 10000  SMITHARAI 20 CHEMISTRY 20000  MAAYA 23 . 30000  RAZIA . MATHEMATICS 40000  KUSHALSINGH 25 GEOGRAPHY 50000  RAMSINGH 26 . 75000  HARISHROY . . 60000  ; RUN; PROC PRINT;RUN; OUTPUT:                                                               The SAS System Obs NAME AGE DEPARTMENT SALARY 1 SAISRI 16 PHYSICS 10000 2 SMITHARAI 20 CHEMISTRY 20000 3 MAAYA 23   30000 4 RAZIA   MATHEMATICS 40000 5 KUSHALSINGH 25 GEOGRAPHY 50000 6 RAMSINGH 26   75000 7 HARISHROY     60000 DATA INPUT(DROP=AGE);  SE...

                        MULTIPLE DATASETS | SET STATEMENT DATA BUS450            MATH400            HIST100     SCI400   FRENCH100; SET PROG2.GRADE; IF Course='BUS450' THEN OUTPUT BUS450; ELSE IF Course='MATH400' THEN OUTPUT MATH400; ELSE IF Course='HIST100' THEN OUTPUT HIST100; ELSE IF Course='SCI400' THEN OUTPUT SCI400; ELSE IF Course='FRENCH100' THEN OUTPUT FRENCH100; RUN; PROC PRINT; RUN; LOG: NOTE: There were 19 observations read from the data set PROG2.GRADE. NOTE: The data set WORK.BUS450 has 5 observations and 6 variables. NOTE: The data set WORK.MATH400 has 5 observations and 6 variables. NOTE: The data set WORK.HIST100 has 3 observations and 6 variables. NOTE: The data set WORK.SCI400 has 3 observations and 6 variables. NOTE: The data set WORK.FRENCH100 has 2 observations and 6 variables. NOTE: DATA statement used (Total process time):...