ex2answer.sas

本书详细讲解了sas的使用基础以及编程基础

/*//////////////////////////////////////////
//                                       //
//              Baokun Li                //
//      Exercise 2: Reading in Data      //                   
//            July 1st, 2007             //
//             Swufe, Chengdu            //
//                                       //
//////////////////////////////////////////*/ 


******************************************
*             Baokun Li                  *
*      Exercise 2: Reading in Data       *                   
*            July 1st, 2007              *
*             Swufe, Chengdu             *
*                                        *
******************************************;

/******************************************
*             Baokun Li                  *
*      Exercise 2: Reading in Data       *                   
*            July 1st, 2007              *
*             Swufe, Chengdu             *
*                                        *
******************************************/

DATA class;
   INFILE 'D:\data\students.csv'  DSD 	    	       
          FIRSTOBS = 2;
   INPUT gender $ age marstat$ credits state$; 
         
TITLE 'Reading in Data from an External File';

PROC PRINT DATA=class;
run;

DATA class;
   INFILE 'D:\data\students.txt' dlm='09'x DSD 	    	       
          FIRSTOBS = 2;
   INPUT gender $ age marstat$ credits state$; 
         
TITLE 'Reading in Data from an External File';

PROC PRINT DATA=class;
run;

PROC IMPORT DATAFILE='D:\data\students.xls' 
        OUT = class1
	    DBMS = excel2000
	    REPLACE ;
	    GETNAMES = yes;
TITLE 'Reading in Data from excel';
PROC PRINT DATA=class1;
run;
quit;