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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- extracting cases with a given string from sas
- converting spss to sas system files
- importing an excel worksheet into sas
- finance division california courts
- once the data has been entered and verified it can be
- converting spss data to excel data and then to sas
- a project report on sas technology
- confirmatory factor analysis with amos
- an introductory look at statistical text mining for health
Related searches
- has been vs have been grammar
- has and has been difference
- have been or has been grammar rule
- difference between has been and had been
- has been and had been difference
- how has the stock market been doing
- have been and has been grammar
- has been and have been usage
- has been and have been difference
- it has been a while
- when has the elastic clause been used
- it has been a year