WEIGHT - NTEE1 -> NTEESOI - name, city, state, start and end yr ">
Knowledgebase -
-
Sorry, there was an error processing record:
-
Please contact us at
[email protected]
. We are sorry for the inconvenience.
Back
Search
Knowledgebase
Documents, videos, websites and more.
Adding a new mysql table from SAS on the Alpha - FTP and Perl Scripts
Brief description or abstract:
From the Urban Institute Alpha: - Run export.sas to create [nccs1.export]*.dd and *.dat files. From the Dataweb: - FTP the files to the /data/tmp directory From the dataweb prompt: ftp alpha2.urban.org or 198.31.170.11 cd [.export] get xyz.dd get xyz.dat (in LOWER CASE letters; do NOT include the ";n") (gzip file first if large) - Run createTable.pl to load into mysql - Run addTable.pl to update data dictionaries and form lists - Run indexUpdate.pl to rebuild index files to speed performance - Run addFips2.pl to add FIPS, MSA info - Run ntee-update.pl to add NTEEs and related variables - Run fixQuotes.pl to remove double-quotation marks (") from key fields. ---------------------- Additional steps for SOI files: - Rename variables using add2dd.pl: - C999 -> WEIGHT - NTEE1 -> NTEESOI - name, city, state, start and end yr
Posting type(s):
Links & Files
URL:
Regions & Topics
Geographic regions:
United States
Topic(s):
Subtopic(s):
Number of "Likes":
0
-
Sorry, there was an error processing record:
-
Please contact us at
[email protected]
. We are sorry for the inconvenience.
Number of Views:
Posting Details
Publication date:
0000-00-00
Tags
Tags:
Added
2002-09-18
by tpollak, Modified
2011-09-27
by kuttkeUI
Comments
No comments.
Add your comment: