Once the data has been entered and verified, it can be ...



Instructions to convert the PRSIMS data set from ACCESS to SAS

Once the data has been entered and verified, it can be imported from ACCESS into a SAS database. We have provided a SAS program (p6data.sas) that will do this. Before it can be run, the file must be edited.

A portion of the program is copied below. You will need to replace the bold text with the name and location of the folder containing the PRISM data entry files. You can do a “search and replace” for the text to replace all 55 instances in the program. All other information in this portion of the program remains the same.

libname data 'K:\SHARE\karen\Prism6\ Prism6DataEntry';

/* Convert ACCESS tables into SAS data sets */

PROC IMPORT OUT= p00

DATATABLE= "CoverTbl"

DBMS=ACCESS97 REPLACE;

DATABASE="K:\SHARE\karen\Prism6\Prism6DataEntry\DEPrismF.mdb";

USERID="Vito";

PASSWORD="vito";

WORKGPDB=" K:\SHARE\karen\Prism6\ Prism6DataEntry \Prism.mdw";

The final section of the program merges the individual data tables for each section into a single data set named “p6data”. This data set will be stored in the same folder as the ACCESS database. (If you want the data set to be saved to another location, simply change the pathway in the LIBNAME statement to match the desired destination folder.)

Only interviewss that have been completely entered will appear in the final data set. Subjects must have a record in each data table, even if it is just the ID number and nothing else. (If you want all subjects to appear in the data set even if there are missing sections, then you can delete the three lines at the end that say “if (a and b and c … and z and aa);”)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download