- 16
- 7 708
Arthur's SAS Notes
United States
เข้าร่วมเมื่อ 4 เม.ย. 2022
Hello everyone, Welcome to my channel. In this channel, we will learn how to program in SAS language.
I plan to present topics on DATA step programming, and SAS macro language, as well as other interesting topics in SAS
If there are some specific topics that you would like to learn, please leave a comment.
For SAS DATA step programming, the course-related data sets, exercise solutions can be downloaded at www.routledge.com/Handbook-of-SAS-DATA-Step-Programming/Li/p/book/9781466552388
If you are interested in learning R language, please visit my Channel on learning R:
th-cam.com/channels/6ZmtTyvOsojaJ3P1bQaQeA.html
I plan to present topics on DATA step programming, and SAS macro language, as well as other interesting topics in SAS
If there are some specific topics that you would like to learn, please leave a comment.
For SAS DATA step programming, the course-related data sets, exercise solutions can be downloaded at www.routledge.com/Handbook-of-SAS-DATA-Step-Programming/Li/p/book/9781466552388
If you are interested in learning R language, please visit my Channel on learning R:
th-cam.com/channels/6ZmtTyvOsojaJ3P1bQaQeA.html
Loop (part-2) | Direct Access Mode | Creating Samples | Reading Multiple Files | FILEVAR=
Direct Access Mode
NOBS=
POINT=
Creating Systematic Samples
Creating Random Samples
Reading Multiple External Files
FILEVAR=
NOBS=
POINT=
Creating Systematic Samples
Creating Random Samples
Reading Multiple External Files
FILEVAR=
มุมมอง: 130
วีดีโอ
PROC TRANSPOSE | Transposing an Entire Data | Transposing Data By-Group
มุมมอง 3352 ปีที่แล้ว
Understanding 6 statements & 8 options in PROC TRANSPOSE. Transposing an Entire Data Set Transposing a Data Set By-Group Transposing Data More Than Once Reference Paper: www.lexjansen.com/wuss/2017/208_Final_Paper_PDF.pdf
Combining Data | Concatenating | Interleaving | 1-to-1 Reading/Merging | Match-Merging | Updating
มุมมอง 4812 ปีที่แล้ว
Vertically Combining Data Sets: - Concatenating Data Sets - Interleaving Data Sets Horizontally Combining Data Sets: - One-to-One Reading - One-to-One Merging - Match-Merging - Updating Data Sets
Array (part-2) | Array Functions | Creating Variables by Using Arrays | Transposing Data
มุมมอง 1472 ปีที่แล้ว
The DIM, HBOUND, and LBOUND Functions Using the IN and OF Operator with an Array Creating a Group of Variables by Using Arrays Calculating Products of Multiple Variables Transposing Data Sets
Array (part-1) | Array Statement | Situations for Utilizing Array Processing
มุมมอง 1652 ปีที่แล้ว
- Situations for Utilizing Array Processing - Defining and Referencing One-dimensional Arrays - Compilation and Execution Phases for Array Processing
Loop (part-1) | Implicit vs Explicit Loops | Iterative DO loop | DO WHILE | DO UNTIL
มุมมอง 2692 ปีที่แล้ว
Review implicit loop Iterative DO loop DO WHILE loop DO UNTIL loop
BY-Group Processing (part-2) | Transforming DATA | Obtaining the Most Recent Non-Missing Data
มุมมอง 1782 ปีที่แล้ว
Applications of Using BY-Group Processing Calculating Mean Scores of Each BY-Group Creating Data with Duplicate and Non-Duplicate Observations Obtaining the Most Recent Non-Missing Data Within Each By-Group Restructuring Data Sets from Long Format to Wide Format
BY-Group Processing (part-1) | FIRST.VARIABLE | LAST.VARIABLE
มุมมอง 4132 ปีที่แล้ว
Creating FIRST.VARIABLE & LAST.VARIABLE BY group BY value By variable Calculating sum score for each subject
Program Data Vector (part-3) | Conditional Processing
มุมมอง 2872 ปีที่แล้ว
The subsetting IF statement IF expression THEN DELETE; SET SAS-data-set END=variable; Restructuring datasets (wide to long)
Program Data Vector (part-2) | The RETAIN Statement | The SUM Statement
มุมมอง 9242 ปีที่แล้ว
Retaining the Value of Newly-Created Variables. The RETAIN Statement. The SUM Statement. How DATA Step Processes by Using the RETAIN Statement
Program Data Vector (part-1) | DATA Step Processing
มุมมอง 1.9K2 ปีที่แล้ว
Data Step Compilation and Execution Phases. Declarative/Executable Statements. Program Data Vector (PDV). Automatic Variables: _N_ and _ERROR_. The OUTPUT Statement. The Difference Between Reading a Raw Data Set and a SAS Data Set
Create Variables (part-2) | Multiple IF-THEN | Modify IF-THEN Statement to Assignment Statement.
มุมมอง 1592 ปีที่แล้ว
Multiple IF-THEN/ELSE statements. The SELECT group. Modifying the IF-THEN/ELSE Statement with the Assignment Statement.
Create Variables (part-1) | The IF-THEN/ELSE statement.
มุมมอง 2072 ปีที่แล้ว
- Steps for Creating a Variable. - The IF-THEN/ELSE statement. - Handling Missing Values. - The MISSING Function. - TRUE/FALSE Value. - The LENGTH Statement. - DO Group Video Links for SAS Procedures: th-cam.com/video/yKqn1Ckyk1A/w-d-xo.html
Intro to SAS (part-3) | Subsetting Data | Labeling variable names | Formatting variables
มุมมอง 4702 ปีที่แล้ว
SAS variable list notation KEEP=/DROP= option The KEEP/DROP statements The LABEL statement The FORMAT statement SAS formats
Intro to SAS (part-2) | Base SAS Procedures
มุมมอง 3852 ปีที่แล้ว
Common Statements in SAS Procedures The CONTENTS Procedure The SORT Procedure The PRINT Procedure The MEANS Procedure The FREQ Procedure
Intro to SAS (part-1) | Understanding the SAS program | Reading data | Creating/modifying variables
มุมมอง 1.3K2 ปีที่แล้ว
Intro to SAS (part-1) | Understanding the SAS program | Reading data | Creating/modifying variables
Plz do more videos about sas
Nice explaination do more videos 😊
Lectures are very clear. Could you please upload more lectures on procedures.
Very clear explanation, Thank you!
Could you explain control flow(compile and execution)of proc step and also macros
I'll plan to write some notes on macros in the future, but not on procs. I personally don't know how it works on procs, and each procedure will probably run differently behind the scene.
Very nice video. I can suggest for your channel promotion G E T 4 V I E W S, its really help
Hello, Sir, what software did you use to make these nice slides
MS PowerPoint + Speechelo (recording)
@@SAS_ArthurLi Thank you! They are the best slides I have seen.
Your videos are so good!
Excellent explanation please create more information on Macro's thank you.
hi Arthur, . As retain is declarative statement and will be skipped during execution phase. So how program knows to initialize retained variable with some value in execution phase and how it knows that it has to retain this particular variable value in next iterations. Where does this information regarding initializing and retaining is stored?
The information about the initialization to the variable from the Retain statement is happened during the compilation phase. This information is stored in descriptor portion of the data.
it is very simple and informative, keep going!
Thank you!