/* Simple example with PROC SQL */ data hospital; INPUT patient date date9. pulse temp bps; dataline; 2004101 03NOV2005 73 98.3 88 2004101 10NOV2005 77 98.5 82 2004101 17NOV2005 75 98.2 85 2004102 03NOV2005 83 98.0 98 2004102 10NOV2005 81 98.5 94 2004103 27OCT2005 77 99.3 78 2004103 03NOV2005 76 98.5 79 2004103 17NOV2005 79 99.2 75 2004104 10NOV2005 72 98.9 83 ; run; proc print data=hospital; format date date9.; title; run; /* Selecting all data values from a data set and printing to output window using PROC SQL */ /* The following examples all create tables with DATE in a */ /* Julian format. See later step for changing the format */ /* Selecting some variables from a data set and creating a table using PROC SQL. The table will not be printed */ PROC SQL; CREATE TABLE BLOODP AS SELECT patient, date , bps FROM hospital; QUIT; PROC SQL; SELECT * FROM BLOODP; QUIT; PROC SQL; CREATE TABLE BLOODP AS SELECT patient label="Patient", date format date7. label="Date", bps label="Systolic Blood Pressure" FROM hospital; QUIT; PROC SQL; SELECT * FROM BLOODP; QUIT; /*Doing the same thing by dropping variables */ PROC SQL; CREATE TABLE BLOODP AS SELECT * FROM hospital(DROP= pulse temp); QUIT; PROC SQL; SELECT * FROM BLOODP; QUIT; /*Selecting unique values and sorting */ PROC SQL; CREATE TABLE PATIDS AS SELECT DISTINCT patient FROM hospital; QUIT; PROC SQL; SELECT * FROM PATIDS; QUIT; PROC SQL; CREATE TABLE VISITS AS SELECT patient, date format mmddyy10. FROM hospital ORDER BY patient, date DESCENDING; QUIT; PROC SQL; SELECT * FROM VISITS; QUIT;