OPTIONS LINESIZE=88 PAGESIZE=53 NOCENTER NODATE NONUMBER NOFMTERR; *******************************************************************; * PROJECT NAME: Learning to Use SAS ; * PROGRAM NAME LOCATION DATE PROGRAMMER ; TITLE1 "Source:LEC16P7.SAS Disk 1998#1 11/2/98 EJS " ; * Description: Create access and view files for Lotus Spreadsheet ; * created from Excel file saved with WK3 format ; * Read: wtstudy1.xls saved as wtstudy1.wk3 ; * format, with data beginning in Row 2 ; * wtstudy1.sv2 View member for data set wtstudy1.xls that converts; * Excel variables and specifications to SAS data; * specifications ; *******************************************************************; LIBNAME new 'C:\temp'; ***********************************************************************; *** Create a SAS Data Set ; ***********************************************************************; DATA wtstudy2; SET new.wtstudy1; PROC CONTENTS DATA=wtstudy2; PROC PRINT DATA=wtstudy2; RUN;