Creating & Reading Data Sets
SAS 9
| Beginner
- 13 Videos | 1h 2m
- Earns a Badge
Before SAS software can process data, such as data saved in an Excel worksheet, it must be in the form of a SAS data set. Discover how to create data sets from various sources.
WHAT YOU WILL LEARN
-
create a data set from an Excel sheet using the PROC step in SASread from an Excel sheet using the libname statementuse the PROC step to create an Excel sheet in SASuse the ODS to create an Excel sheet in SASuse the IMPORT wizard to import data from an Excel sheet in SASuse the EXPORT wizard to write to an Excel Sheet in SAScreate a data set from a delimited raw data file using the DATA step in SAS
-
use the LENGTH statement to define the length of a variable in SASread nonstandard data in SAS using informantsuse additional SAS statements to process nonstandard data in the DATA stepread consecutive delimiters as missing values using the DSD option in SASrecognize missing data at the end of a record with the MISSOVER optionread data from a variety of sources in SAS
IN THIS COURSE
-
1.Creating a Data Set from an Excel Sheet5m 1sUP NEXT
-
2.Reading from an Excel Sheet5m 16s
-
3.Using the PROC Step to Create an Excel Sheet2m 33s
-
4.Using the ODS to Create an Excel Sheet3m 9s
-
5.Using the IMPORT Wizard with Excel3m 9s
-
6.Using the EXPORT Wizard with Excel1m 58s
-
7.Creating a Data Set from a Delimited File4m 10s
-
8.Using the LENGTH Statement5m 3s
-
9.Reading Nonstandard Data with Informants6m 28s
-
10.Processing Nonstandard Data in the DATA Step5m 4s
-
11.Using the List Input DSD Option5m 15s
-
12.Using the MISSOVER Option6m 1s
-
13.Exercise: Read Data8m 52s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.