下面有具体的样本，我以前没遇过这样的，请教一下该怎么处理。因为有将近100万个观察值，所以效率还是要考虑的。

最后在SAS输出的数据要有编号，公司名字，类别（director or officer)，名字，年龄，头衔，时间，和酬劳。其中编号，公司名字和类别都不是很规范的在同一行里面。附件里面有一个样本数据。如果我没有说清楚的，我再解释。非常感谢！！

  1 of 11441 Directors and Officers
  A & A INTERNATIONAL INDUSTRIES INC
  OFFICERS (NAME/AGE/TITLE/REMUNERATION): (SOURCE: 10K)
  CAMPORESE, GIOVANNI/ NA/  CHIEF EXECUTIVE OFFICER, PRESIDENT (20-F 06-30-96) /
$31,200
  BROWN, LORNE/ NA/  CONTROLLER (20-F 06-30-96) / $46,008
  CAMPORESE, JULIE/ NA/  SECRETARY (20-F 06-30-96) / $21,141
  DIRECTORS (NAME/AGE/TITLE/REMUNERATION): (SOURCE PROXY NA    )
  CAMPORESE, GIOVANNI/ NA/  CHIEF EXECUTIVE OFFICER, PRESIDENT (20-F 06-30-96) /
$31,200
  CAMPORESE, MONICA/ NA/ (20-F 06-30-96) / $10,624
  BROWN, LORNE/ NA/  CONTROLLER (20-F 06-30-96) / $46,008
  BORCHERS, IISE/ NA/ (20-F 06-30-96) / NA
  OLSEN, LAURENCE/ NA/ (20-F 06-30-96) / NA
  SANFORD, JAMES/ NA/ (20-F 06-30-96) / NA

  2 of 11441 Directors and Officers
  A C MOORE ARTS & CRAFTS INC
  OFFICERS (NAME/AGE/TITLE/REMUNERATION): (SOURCE: 10K)
  PARKER, JOHN E./ 56/  PRESIDENT, CHIEF EXECUTIVE OFFICER / NA
  RAMBO, REX A./ 56/  EXECUTIVE VICE PRESIDENT, CHIEF OPERATING OFFICER / NA
  PARKER, PATRICIA A./ 56/  EXECUTIVE VICE PRESIDENT / NA
  GORDON, LESLIE H./ 54/  SENIOR VICE PRESIDENT, TREASURER, CHIEF FINANCIAL OFFICER /
NA
  PARKER-VANDENBERG, JANET/ 35/  SENIOR VICE PRESIDENT / NA
  DIRECTORS (NAME/AGE/TITLE/REMUNERATION): (SOURCE PROXY NA    )
  PARKER, JOHN E./ 56/  PRESIDENT, CHIEF EXECUTIVE OFFICER (10-K 12-31-97) /NA
  PARKER, PATRICIA A./ 55/  EXECUTIVE VICE PRESIDENT (10-K 12-31-97) / NA

  3 of 11441 Directors and Officers
  A C S ELECTRONICS LTD
  OFFICERS (NAME/AGE/TITLE/REMUNERATION): (SOURCE: 10K)
  KIRSHENBOIM, ZE'EV/ 44/  CHAIRMAN OF THE BOARD, PRESIDENT, CHIEF EXECUTIVE OFFICER,
MANAGING DIRECTOR / NA
  BEN-BLIEZER, AMATSIA/ 44/  EXECUTIVE OFFICER, CHIEF FINANCIAL OFFICER, VICE
PRESIDENT, MANAGING DIRECTOR / NA
  KRAIZER, MARK/ 37/  MANAGER / NA
  DIRECTORS (NAME/AGE/TITLE/REMUNERATION): (SOURCE PROXY:) NA

  4 of 11441 Directors and Officers
  A EDWARDS BANK
  OFFICERS (NAME/AGE/TITLE/REMUNERATION): (SOURCE: 10K)
  DE CASTRO SPIKULA, SERGIO/ NA/  CHAIRMAN OF THE BOARD / NA
  ERGAS ERGAS, JACOB/ NA/  VICE CHAIRMAN OF THE BOARD / NA
  FEVRE DOMINGUEZ, GUSTAVO/ NA/  GENERAL MANAGER / NA
  AMUNATEGHI COUSINO, DOMINGO/ NA/  MANAGER / NA
  ERGAS ALVO, ISAAC/ NA/  MANAGER / NA
  GUZMAN HERRERA, JULIO/ NA/  MANAGER / NA
  MENCHACA OLIVARES, FERNANDO/ NA/  MANAGER / NA
  MORALES ARACENA, RICARDO/ NA/  MANAGER / NA
  ROJAS PRETER, NELSON/ NA/  MANAGER / NA
  SILVA ESCOBAR, GUIDO/ NA/  MANAGER / NA
  VILAJUANA RIGAU. JUAN ENRIQUE / NA/  MANAGER / NA
  VILLOUTA BENIMELIS, FERMAN/ NA/  MANAGER / NA
  DIRECTORS (NAME/AGE/TITLE/REMUNERATION): (SOURCE PROXY NA    )
  DE CASTRO SPIKULA, SERGIO/ NA/  CHAIRMAN OF THE BOARD  (20-F 12-31-96)/ NA
  ERGAS ERGAS, JACOB/ NA/  VICE CHAIRMAN OF THE BOARD  (20-F 12-31-96)/ NA
  MELNIK ISRAEL, SERGIO/ NA/  (20-F 12-31-96)/ NA
  CASANOVA DEMARCHI, MANUEL/ NA/  (20-F 12-31-96)/ NA
  ERGAS WEISNER, EDUARDO/ NA/  (20-F 12-31-96)/ NA
  EDWARDS DEL RIO, AGUSTIN/ NA/  (20-F 12-31-96)/ NA
  PRIETO BAFALLUY, ALFREDO/ NA/  (20-F 12-31-96)/ NA
  LARRAGUIBEL HOLMAN, VICTOR/ NA/  (20-F 12-31-96)/ NA
  ORTIZ QUIROGA, LUIS/ NA/  (20-F 12-31-96)/ NA