Stat Computing > SAS > Topics

SAS Topics
Data Management

These pages contain links from all parts of our web site and others web sites on data management.  The topics will vary from introductory to advanced.

• SAS Class Notes
  • Entering Data
  • Modifying Data
  • Exploring Data
  • Managing Data
• SAS Learning Modules
  • Reading Raw Data into SAS
    • Inputting raw data into SAS
    • Reading dates into SAS and using date variables
  • Basic Data Management in SAS
    • Creating and recoding variables
    • Using SAS functions for making/recoding variables
    • Subsetting Variables and observations
    • Missing Values in SAS
    • Labeling data, variables, and values
    • Using PROC SORT and the BY statement
    • Making and Using Permanent SAS Data Files (version 8)
    • Making and Using Permanent SAS Data Files (version 6)
  • Classic Data Management Problems
    • Merging Data Files via Data Step, Proc SQL
    • Concatenating (stacking) SAS Data Files
    • Working Across Variables
    • Collapsing Across Observations in SAS via Proc Means, Proc SQL , Data Step I , Data Step II 
    • Reshaping Data from Wide to Long via Proc Transpose , Data Step
    • Reshaping Data from Long to Wide via Proc Transpose , Data Step
• SAS Frequently Asked Questions
  • Converting among SAS, SPSS and Stata
    • How do I convert among SAS, SPSS and Stata data files?
    • How do I move SAS files from Unix to Windows?
  • Reading/Writing SAS Data Files in SAS Version 8
    • How do a read/convert a version 6 SAS files/format using SAS Version 8?
      How do I convert a SAS version 8 file to a SAS version 6 file?
  • Reading/Writing Data Files
    • How do I read a file that uses commas, tabs or spaces as delimiters to separate variables?
    • How do I read a delimited file with missing values?
    • How do I read a delimited file that has delimiters embedded in the data?
    • What are some common infile options for reading a raw data file?
    • How do I read raw data files compressed with gzip (.gz files) in SAS?
    • How do I read raw data via FTP in SAS?
    • How can I read multiple raw data files in SAS?
    • How do I write a data file that uses commas, tabs or spaces as delimiters between variables?
    • How do I read/write Excel files in SAS version 8?
    • How do I create an ASCII file from a sas data set using put statement?
    • How do I read multiple raw data files with the same structure in one data step?
  • Transferring Files to/from other Computer Platforms
    • How do I transfer SAS data files from a PC to Unix? 
    • How do I transfer SAS data files from UNIX to a PC?  
  • Reading/Writing SAS Files with Formats
    • How do I use a SAS data file with a format library?
    • How do I use a SAS data file when I don't have its format library?
  • Data Management
    • How do I make unique anonymous ID variables for my data?
    • How can I create an enumeration variable by groups?
    • How do I use keep and drop efficiently?
    • How can I see the number of missing values and patterns of missing values in my data file?
    • How can I count the number of missing values for a character variable?
    • How can I increment dates in SAS?
    • How can I find things in a character variable in SAS?
    • How do I standardize variables (make them have a mean of 0 and sd of 1)?
    • Is there a quick way to create dummy variables?  
    • How can I create different kinds of centered variables in SAS?
    • How do I specify types of missing values?
    • How do I check that the same data input by two people are consistently entered?
    • How do I read in a character variable with varying length in a space delimited dataset?
    • How do I display information for all the SAS datasets in a directory?
    • How can I get rid of extra spaces in a string variable?
• SAS Library
  • Reading Data/Data Transformation/Data Management
    • Reading Data into SAS adapted from materials created by Professor Oliver Schabenberger of Virgina Tech .
    • The Input Statement: Where It's @(PDF) by Ronald Cody, courtesy of NESUG
    • Data Transformations and Manipulation in SAS adapted from materials created by Professor Oliver Schabenberger of Virgina Tech .
    • Working with SAS Date and Time Functions(PDF) by Andrew H. Karp, courtesy of NESUG  
    • Creative Uses of Functions(PDF) by Steven A. Wright, courtesy of NESUG
    • Data Cleaning 101(PDF) by Ronald Cody, courtesy of NESUG
    • How MERGE Really Works(PDF) byBob Virgile, courtesy of NESUG
    • Transforming Multiple-Record Data into Single-Record Format when Number of Variables is Large(PDF) by David Izrael and David Russo, courtesy of NESUG
    • Longitudinal Data Techniques: Looking Across Observations(PDF) by Ronald Cody, Ed.D., Robert Wood Johnson, courtesy of NESUG
    • Changing the Shape of Your Data: PROC TRANSPOSE vs. Arrays(PDF) by Bob Virgile, courtesy of NESUG
    • The RETAIN Statement: One Window into the SASData Step(PDF) by Paul Gorrell, courtesy of NESUG
    • Using Dates in SAS in the Year 2000 and Beyond
  • Procedures
    • PROC MEANS More than just your average procedure(PDF) by Peter R. Welbrock, courtesy of NESUG
    • The power of PROC FORMAT(PDF) by Jonas V. Bilenas, courtesy of NESUG 
    • Ten Things You Should Know About PROC FORMAT(PDF) by Jack Shoemaker, courtesy of NESUG
    • PROC SQL for DATA Step Die-Hards(PDF) by Christianna S. Williams, courtesy of NESUG
    • An Introduction to the SQL Procedure(PDF) by Chris Yindra, courtesy of NESUG
    • Alternatives to Merging SAS Data Sets … But Be Careful(PDF) by Michael J. Wieczkowski, courtesy of NESUG
    • Handling Missing Values in the SQL Procedure(PDF) by Danbo Yi and MA Lei Zhang, courtesy of NESUG
    • Creating and using indexes in SAS
    • Creating and using formats and format libraries in SAS
    • Using multidimensional arrays
• SAS Code Fragments
  • Reading/Writing Files
    • Reading an Excel file in SAS version 8
    • Making a fixed format file
    • Making a SAS Cport file
    • Reading a SAS Cport file
    • Reading an EBCDIC file
    • Reading multiple raw data files, Version 8
    • Reading multiple raw data files (version 6.x)
    • Using a SAS macro to "set" multiple files
    • Reading hierarchical data
    • Changing tabs to spaces (if both are included as delimiters)
    • Reading an electronic codebook and writing an input statement
    • Reading a multiple-line-per-subject data file
  • Other
    • Checking for duplicate Ids
    • Changing the length of a character variable
    • Replacing strings
    • Concatenating string variables using CAT functions
    • Reading a SAS data file into PROC IML
    • Executing system level commands within SAS
    • Copying and combining SAS format libraries
    • Eliminate useless variables
    • How can I "fill down" a variable?
    • Creating a long list of variable names based on an abbreviated one
    • Filling in Missing Values Over Time
    • Matching with a wildcard using Perl regular expression

UCLA Researchers are invited to our Statistical Consulting Services
We recommend others to our list of Other Resources for Statistical Computing Help
These pages are Copyrighted (c) by UCLA Academic Technology Services