WEIGHT - NTEE1 -> NTEESOI - name, city, state, start and end yr ">Knowledgebase -
Community Platform


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 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
Regions & Topics
Geographic regions: United States
Number of "Likes":0
Number of Views:462
Posting Details
Publication date: 0000-00-00
Added 2002-09-18 by tpollak, Modified 2011-09-27 by kuttkeUI


No comments.