Question

14. Write a SAS program to do the following tasks in order. You must label each question in the program by using comment statement like /* Q14a */ on the line where your answers to Q14a begin.

a.   Define the Library Q14A using LIBNAME statement to connect to the SASData folder inside STA575 folder on the U-drive.

b.   Define the Library Q14B using LIBNAME statement to connect to a new folder Q14DATA inside STA575 folder on the U-drive. Create a new folder ‘NDATA’ inside ‘STA575’ folder on U-drive.

c.   Write a data step to read the SAS data set ‘Credit’ from the library Q14A into the library Q14B using the data set name CreditAS1. Make sure the SAS data set is properly read into the library Q14B.

d.   Use PROC CONTENTS to see the descriptor portion of the data set CreditAS1.

e.   By including the option VARNUM, use PROC DATASETS to see the descriptor portion of the data set CreditAS1.

f.    Print the entire data set CreditAS1. [Note that the data is in the Q14B library.]

NOTE: After the program runs correctly, clear the SAS Log (go to SAS Log window, right click, Edit, Clear All), and run the entire program once. Then, organize your report all in one file as follows:

This is in SAS 9.4 preferably

ans format

Q14: Results must be included on the Answer Sheet

Part 1: Your SAS program

Part 2: The SAS LOG

Part 3: The output.

Answer 1

/* To define library */
** In quotes you have to mention the exact path of the folder;
/*Part a*/
libname Q14A "U:/STA575";
/* To define new library Q14B */
/*Part b*/
libname Q14A "U:/STA575/Q14DATA";
/*Part c*/
/* Create data set credit from Q14A into the library Q14B using Dataset name creditAS1 */
data Q14B.credit; /** Output dataset credit in library Q14B */
	set Q14A.creditAS1; /** Read dtaaset creditAS1 from library Q14A */
run;
/* Part D */
/* To see the descriptor prtion of dataset */
proc contents data = Q14A.CreditAS1 order = varnum ;
run;
/* Part E */
/* Varnum option Print a list of the variables by their position in the data set.
By default, the CONTENTS statement lists the variables alphabetically.*/
proc contents data = Q14A.creditAS1 order = varnum ;
run;
proc datasets memtype=Q14A.creditAS1;
contents data=_all_ order = varnum ;
run;
/* Part F */
/* Print dataset creditAS1 (dataset is in library QS14B) */
/* Right now data is in library QS14A , so read it in library QS14B then print the dataset */
data qs14B.creditAS1;
	set QS14A.creditAS1;
run;
proc print data = qs14B.creditAS1 ;
run;