Lab2: Import Data
Please work in teams of 2 persons. At submission, indicate the name of
your team member. No team assignments should be completed with a
person you have previously worked with. Each member of the team
should submit a separate assignment. No copying of code from each
other but feel free to learn from each other. If team assignments
are completed with individual effort, then the student loses 10% of the
- Download data in three/four zipped files.You can focus on the entire data or focus on the data for patients who have at least 365 days of encounters. For password contact your instructor.
By opening this file you agree not to share the file with anyone else. Unzip the files twice, first to get to the directory and then to get to the
actual file. Link to the data into Access or read the data into Microsoft SQL server. We recommend you use SQL server. To create
the database, open SQL server and right click on the database and start a new database. Right click on the database, select "Tasks," select
"Import Data," select "Flat File Source" as the source of the data, change file type to "CSV Files," browse to where you unzipped the files, indicate
that field names are in the first row, select as destination "SQL Server
Native Client" file type.
>365 Days Data,
SQL Code to Merge Files►
Visual Guide to Read SQL►
No individual assignment should be completed in teams. Submit
your work without discussion with other students. At submission,
indicate "This work was completed without help from other students."
- Import data from the following four files into four tables. Ptid file►
- Download the attached file of ICD9 codes and descriptions
In this course we learn using the paradigm of learn one, , do one, teach one. As part of learning this content,
one or more of your peers have completed this assignment ahead of time. They will contact you and introduce themselves. You can get answers to
your questions from them. They are there to help. They also have the option to post videos to this site to
help resolve the problems you are facing. if students do not
wish to publicly post their video, they can post the video within
Blackboard. Here are some videos posted openly to the web:
No student videos are available at this time.
This page is part of the course on
taught by various instructors. It
was last edited on
Wednesday September 06, 2017 by
Farrokh Alemi, Ph.D.