Join Jordan Bakerman for an in-depth discussion in this video Using SAS functions on character data, part of SAS Programming for R Users, Part 1.
- [Instructor] Previously I was just creating…and manipulating numeric data.…Let's move on now to manipulating some character values.…In here I'm going to be using some built in functions…like substring, length, prop case, scan and so forth…and again I'm going to be using these all in a data step.…So here I've listed the function…and I've just cherry picked these functions.…These are some of my favorite from the online doc page,…but there are a ton of built in functions that you can use…and in just a few minutes I'll actually show you…how to get to these functions on the doc page…and I've also provided the description here in the table,…but this is really more for a reference.…
Let's actually look at using these functions.…The substring function allows us to…extract a certain part of a string.…So imagine I'm working with a data table…and one of my variables is a count code.…I want to create a new variable called organization code…and I just want to pull out the last character…of the account code variable.…In this case you can see that it's the number two.…
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.