Questions

1. What is the XPT format for?

2. What does the GUESSINGROWS option in PROC IMPORT do?

3. How can PROC IMPORT help the analyst develop infile code, even if the procedure hits an error?

4. Why is data from fixed-width datasets challenging to read into SAS without documentation?

5. Imagine you have a *.csv file that you want to convert to a *.SAS7bdat dataset to transfer to a coworker using static media. How would you use LIBNAME statements in your code?

6. Imagine your company assembles a large dataset once per year using SAS and analyzes it in SAS for their annual report. The company rarely uses the dataset once the report is generated, and therefore, it can be kept in archives. What is the optimal format for storing these yearly datasets? State your rationale.

7. Imagine you are a developer at a SAS data warehouse. A data provider for your warehouse asks you in what format you would like to receive the data. You have the choice between *.csv, *.txt, or *.SAS7bdat...