FORMAT for State table SA27 ------------------------------------------------------------------------ spread-sheet columns column contents ------------------------------------------------------------------------ 01 - 04 A "xx" where xx = FIPS State code 05 comma 06 - 08 B "t" where t = table code: A = title record & column headings R = SA27 estimates in this record 09 comma 10 - 14 C "lll" where lll = line code (see SA27LINE.DOC for line codes and titles and SA27FOOT.DOC for appropriate table titles and footnotes) 15 comma 16 - 18 D "r" where r = BEA region code (1 through 8) 19 comma 20 - 21 E 69 = first year of data on record 22 comma 23 - ... F... Data fields. If floating format (original format), data fields are comma-delimited without any leading zeros. Record lengths will vary depending on the size of the data items. If fixed format (after running REFIX.EXE), the data fields will be 11-digits long with leading zeros as required and one space between each data field. The first datum will be in cols. 23-33, the second in cols. 35-45, etc. FORMAT.DOC