Join Jordan Bakerman for an in-depth discussion in this video Importing raw data files, part of SAS Programming for R Users, Part 1.
- [Instructor] In this section,…we want to be able to import a saved raw data file…using either a data step or a proc step…to get back a new SAS data set.…In R, I like to just go ahead and use the read.csv function…and create new data frames from our CSV files.…Once I read in the data,…then I use functions like colnames…to actually change the data frame column names,…so here I have two instances reading in CSV,…one called allnames, one called baseball,…and these are actually the two datasets…we'll read in as demonstrations.…
To read in a delimited raw data file,…we're going to again use our data step.…We'll start with the data statement…to specify a new SAS data set name.…We'll use the input statement exactly the same as before.…We'll simply specify variable names…and if it is character value data,…we'll use the dollar sign.…If we do need to change the number of characters…to something larger than eight,…again we'll use the length statement.…This time instead of using the data line statement,…we're going to replace it with the infile statement.…
Note: You can visit the SAS site to obtain a copy of the software, and use the company's online data sets to do the course exercises.
- SAS University Edition
- Working in SAS Studio
- Using tasks and snippets in SAS Studio
- Determining power using simulation
- SAS procedure syntax
- Creating datasets manually in the DATA step
- Importing raw data files
- Creating new variables and conditional processing
- Match-merging data sets
Skill Level Beginner
Descriptive Healthcare Analytics in Rwith Monika Wahi4h 15m Advanced
1. Introduction and Working in SAS
2. Importing and Reporting Data
3. Creating New Variables, Functions, and Data Tables
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.