Please enable JavaScript.

Coggle requires JavaScript to display documents.

SAS - Coggle Diagram

- - - - Permanently
        
        specify LIBNAME
        
        PROC FORMAT LIBRARY=<name>
      - Temporarily
        
        Work.Formats
- - - - PROC CONTENTS
    - - PROC PRINT
      - PROC CONTENTS
        for descriptor view
  - - - DO start TO stop/ BY / WHILE / UNTIL
        ... ... ...
        END;
        
        DO var-index = 5 TO 1 BY -1
        ...
        END
        
        once for each item in series
        DO var-index= 2,5,9,13,27
        ...
        END;
        
        NESTING DO-LOOPS
        
        DO i = 1 TO 20
        ....
        DO j= 1 to 10
        ...
        END
        END
        
        loop exe at least once
        DO UNTIL(condition)
        ....
        END
    - - For Print/Display Only
        FORMAT
        
        SAS Defined
        
        NOTE: Must count the space for $, , , . for w and d
        
        COMMAw.d -- comma8.2
        
        DOLLARw.d -- dollar6.2
        
        MMDDYYw. mmddyy10.
        
        w. integer of w space -- 7.
        
        w.d integer w, decimal d -- 8.2
        
        $w. character in w space -- $12.
        
        DATEw. values as date -- date9.
        
        User-defined
      - For reading and storing as SAS dataset
        INFORMAT
        
        DATE, TIME, DATETIME
        
        MMDDYY or DATEw.
        
        MMDDYY6. (101517)
        
        MMDDYY8. (10/15/17 or 10 15 17)
        
        MMDDYY10. (10-15-2017)
        
        ..............................................
        
        DATE7. (30May17)
        
        DATE9. (30May2017)
        
        DATE11. (30-May-2017)
        
        TIMEw.
        
        TIME11. (17:00:01.34)
        
        TIME5. (17:00)
        
        DATETIMEw.
        
        DATETIME20. (30May2017:10:03:17.2)
        
        DATETIME18. (30May17 10:03:17.2)
        
        DATETIME15. (30May2017/10:03)
        
        WEEKDATEw.
        
        WEEKDATE3. (Tue)
        
        WEEKDATE10. (Tuesday)
        
        WEEKDATE17. (Tue, Apr 3, 2018)
        
        WEEKDATE31. (Tuesday, Apr 3, 2018)
        
        WORDDATEw.
        
        WORDDATE3. (Apr)
        
        WORDDATE9. (April)
        
        WORDDATE14. (April 3, 2018)
    - - Convert Character to Numeric
        
        INPUT(source, informat)
      - Convert Numeric to Character
        
        PUT(source, format)
      - Modifying Numeric Values
        
        CEIL
        
        ceil(2.1) = 3
        
        FLOOR
        
        FLOOR(2.1) = 2
        
        INT
        
        INT(57.69) = 57
        
        ROUND
        
        ROUND(6246.34, 1) = 6246.00
        
        ROUND(6246.34, 0.1) = 6246.30
        
        ROUND(6246.34, 0.02) = 6246.34
      - Modifying Character Values
        
        SCAN
        
        scan('Farr, Sue', 1, ',') = 'Farr'
        
        SUBSTR
        
        var = substr('MARIE',1,1) extract
        
        substr('S7381K2',4,2) = '92' {='81' --> '92'}
        
        substr('6224541',1,3) = '433' replace
        
        LEFT
        
        RIGHT
        
        || (concatenate)
        
        TRIM
        
        CATX
        
        INDEX
        
        FIND
        
        UPCASE
        
        LOWCASE
        
        COMPBL
        
        COMPRESS
        
        TRANWRD
      - Modifying SAS Date values
        
        MDY()
        
        mdy(6,17,2018) = 06/17/2018
        
        TODAY() / DATE()
        
        TIME()
        
        DAY()
        
        day(19NOV2017) = 19
        
        QTR()
        
        qtr(19NOV2017) = 4
        
        WEEKDAY()
        
        weekday(19NOV2017) = 1 (Sunday)
        
        MONTH()
        
        month(19NOV2017) = 11
        
        YEAR()
        
        year(19NOV2017) = 2017
        
        INTCK()
        
        intck('week', '31dec2017'd,'01jan2018'd) =0
        
        intck('month', '31dec2017'd,'01jan2018'd) =1
        
        intck('year', '31dec2017'd,'01jan2018'd) =1
        
        intck('year', '01jan2018'd,'31dec2018'd) =0
        
        INTNX()
        
        intnx('month', '01jan2018'd,5,'b') = 21336 (June 1, 2018)
        
        intnx('month', '01jan2018'd,5,'m') = 21350 (June 15, 2018)
        
        intnx('month', '01jan2018'd,5,'e') = 21365 (June 30, 2018)
        
        DATDIF()
        
        YRDIF()
        
        yrdif('16feb2016'd,'16jun2018'd, '30/360') = 2.33333
        
        yrdif('16feb2016'd,'16jun2018'd, 'ACT/ACT') = 2.329111
        
        yrdif('16feb2016'd,'16jun2018'd, 'ACT/360') = 2.363888
        
        yrdif('16feb2016'd,'16jun2018'd, 'ACT/365') = 2.331506
    - - Continuous variables
        
        PROC MEANS <DATA = ><stat-keyword><options>
        
        Specifying Variables
        ....................................
        PROC MEANS data = cert.survey mean stderr maxdec=2;
        var age height weight; // or, var item1-item5;
        END
        
        Group Processing
        ..................................
        PROC MEANS DATA = cert.heart maxdec = 1;
        VAR arterial heart cardiac;
        CLASS survive sex;
        run;
        ..................................
        PROC SORT ....OUT = Y;
        PROC MEANS DATA= Y maxdec = ;
        VAR arterial heart cardiac;
        BY survive sex;
        RUN;
      - Categorical Variables
        
        PROC FREQ DATA =... <options>
        ............................................................
        Specifying variables
        ^^^^^^^^^^^^^^^^^^^^^^
        PROC FREQ DATA =cert.diabetes;
        TABLES sex; or, TABLES sex NOCUM;
        RUN;*
        
        One-way Table
        .........................
        PROC FREQ DATA=cert.usa;
        RUN;
        
        Two-way Table
        .........................
        PROC FREQ DATA = ...;
        **TABLES row_var''col_var;*
        RUN;
        
        N-way Table (series of two-way tables)
        .....................
        PROC FREQ DATA = ...;
        **TABLES var1''var2''var3; // TABLES var1''var2''var3 /LIST or, CROSSLIST/ NOFREQ NOPERCENT NOROW NOCOL**
        RUN;