IF/WHERE condition to subset dataset, ex. RETAIN COUNT2 COUNT2=SUM(COUNT2 + 1) or COUNT2 + 1 Calculations based on differences between one or more variables across rows Calculations based on differences between one or more variables (MAX(), RETAIN)ĥ. values with multiple BY variables ( SAS Syntax)Ĥ. Merging Datasets / Lookup Techniques (1:1, 1:M)ģ. SET options ( SAS Syntax), Dataset options ( SAS Syntax)Ģ. ĭata Management Techniques (DATA Step Programming)ġ. See also on-line reference one and two.Īssigning Special Character Values to Character Variables See also DATA Step SAS examples, Common FAQ and Training Videos on selected SAS topics. See also Access to External files, SAS Certification, SAS Functions/Informats and Formats, SAS Dates and Proc SQL. For customized reports, there is a section on DATA _NULL_ reporting.īelow is a collection of SAS ® papers categorized by General, Data Management, Arrays, and Merging Datasets. For example in the pharmaceutical industry, the DATA step is used to post-process RTF files. What's In a Variable Name? ( Data Step/Merge Blog )Īlong with converting text files to SAS ® datasets, the DATA step has the power to create and manage variables. Lost without SAS Indexes? ( SAS Options Blog)įive Habits of Highly Effective SAS Programmers ( Compare and Conquer SAS Programming Blog) Reading and Writing to Excel files ( Excel Blog) Which comes first PUT() or the INPUT()? (SAS Functions Blog Summary Sheet) IF Statements: Knowing the Difference in How and When to Apply Best of Both Worlds: Data Step and Proc SQL Joins ( Proc SQL Blog)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |