SAS Corner

Reading Mixed Records

By Garvii Thomas, Research and Statistical Support Services Consultant

The following article is intended to show the average user of SAS how to import an external dataset, manipulate, and print that dataset in SAS.  The dataset used in this article is Insurance.dat and is made of 25 mixed records of patients of "my" insurance company. 

The following is the raw data stored in insurance.dat.  It contains the patients' identification code, name, health plan, blood type, allergy type, and the number of dependents they have on their plan.  Use the following SAS procedure statement to view the data:

The following program, Mixed.sas, is used to read in and manipulate the dataset to give the proceeding output.

An expansion of this and other concepts in SAS will be covered in my SAS short course series ( http://www.unt.edu/rss/ ) for the Spring Semester here at UNT.