/* Simple example with PROC SQL */

data hospital;
INPUT patient date date9.  pulse temp bps;
cards;
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 */

PROC SQL;
SELECT *
FROM hospital;
QUIT;

/* Selecting some variables from a data set and 
creating a table using PROC SQL */

PROC SQL;
CREATE TABLE BLOODP AS
SELECT patient, date, bps
FROM hospital;
QUIT;


/*Doing the same thing by dropping variables */

PROC SQL;
CREATE TABLE BLOODP AS
SELECT *
FROM hospital(DROP= pulse temp);
QUIT;

/*Selecting unique values and sorting */

PROC SQL;
CREATE TABLE PATIDS AS
SELECT DISTINCT patient
FROM hospital;
QUIT;


PROC SQL;
CREATE TABLE VISITS AS
SELECT patient, date
FROM hospital
ORDER BY patient, date DESCENDING;
QUIT;