Join Jordan Bakerman for an in-depth discussion in this video Demo: Importing data, part of SAS Programming for R Users, Part 1.
- [Instructor] In this section, I'll read in…delimited raw data files with both DATA and PROC steps.…Here, I'm creating a new data set called all_names…in my sp4r library.…The names are going to be the same names as before.…First name, last name, and also,…I'm going to read in age and height.…I'll change the length of the first name…and last name variables as well…because they're a character.…In my infile statement, I'll specify the path…to the data file, and I want to read in…the allnames.csv data file.…
And the dlm= option, I'll specify the comma…for the CSV file type.…The allnames.csv file has the original five names…to be read in from the previous demonstration,…as well as 195 other names.…So of course, I wouldn't want to type those out by hand,…so I'll just save those in my CSV…and read them in with a data step.…So let's run this.…And again, we have 200 observations and the same 4 columns.…
Here are the first five names from before,…and my 195 other ones that you can scroll through.…We also have age and height as well.…
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.