求教：如何将一个excel表格里的多个sheet导入到sas当中呢？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

当然了每个sheet当中的表格的格式是相同的，谢谢赐教

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：excel表格 Excel表 EXCEL sheet xcel EXCEL SAS 求教 表格 sheet

自己解决一下，与大家讨论，这个是调用的一段命令，不知道有没有更好的

%EXDDE(Rawdir=&rawdir,
File=devtest,
Sheet=Sheet1,
StartR=2,
StartC=4,
EndR=5,
EndC=1,
Outdata=test);

proc import datafile='c:\project\prj.xls' dbms=excel2000 out=one replace;

sheet='FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

import datafile='c:\project\prj.xls' dbms=excel2000 out=one replace;

sheet='FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

'FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

'A12:C3012';

mixed=yes;

getnames=yes;

run;

;

proc import datafile='c:\project\prj.xls' dbms=excel2000 out=two replace;

sheet='HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

import datafile='c:\project\prj.xls' dbms=excel2000 out=two replace;

sheet='HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

'HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

'A1:C3001';

mixed=yes;

getnames=yes;

run;

;

proc import datafile='c:\project\BaseAn.xls' dbms=excel2000 out=three replace;

sheet='ANBASE';

Range='A1:B751';

mixed=yes;

getnames=yes;

import datafile='c:\project\BaseAn.xls' dbms=excel2000 out=three replace;

sheet='ANBASE';

Range='A1:B751';

mixed=yes;

getnames=yes;

'ANBASE';

Range='A1:B751';

mixed=yes;

getnames=yes;

'A1:B751';

mixed=yes;

getnames=yes;

run;

then do whatever you like! hopefully this is what you want!

proc import datafile='c:\project\prj.xls' dbms=excel2000 out=one replace;

sheet='FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

import datafile='c:\project\prj.xls' dbms=excel2000 out=one replace;

sheet='FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

'FPG';

range='A12:C3012';

mixed=yes;

getnames=yes;

'A12:C3012';

mixed=yes;

getnames=yes;

run;

;

proc import datafile='c:\project\prj.xls' dbms=excel2000 out=two replace;

sheet='HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

import datafile='c:\project\prj.xls' dbms=excel2000 out=two replace;

sheet='HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

'HBA1C';

Range='A1:C3001';

mixed=yes;

getnames=yes;

'A1:C3001';

mixed=yes;

getnames=yes;

run;

;

proc import datafile='c:\project\prj.xls' dbms=excel2000 out=one replace;

sheet='HBA1C';

RANGE='A1:C3001';

MIXED=YES;

GETNAMES=YES;

RUN;

THEN DO THE SAME THING FOR THE REST SHEETS,