data mysas.test;
input region $ state $ month monyy5. headcnt expenses revenue;
format month monyy5.;
cards;
EASTERN VA FEB78 10 7800 15500
SOUTHERN FL MAR78 9 9800 13500
SOUTHERN GA JAN78 5 2000 8000
NORTHERN MA MAR78 3 1500 1000
SOUTHERN FL FEB78 10 8500 11000
NORTHERN NY MAR78 5 6000 5000
EASTERN VA MAR78 11 8200 16600
PLAINS NM MAR78 2 1350 500
SOUTHERN FL JAN78 10 8000 10000
NORTHERN NY FEB78 4 3000 4000
SOUTHERN GA FEB78 7 1200 6000
;
run;
以上这样输入数据是可以的~~~
但是下面这种方式:
proc sql;
create table newtable (region char(8),state char(2),month num informat=monyy5. format=monyy5.,
headcnt num,expenses num,revenue num);
quit;
*用VALUES子句插入行;
proc sql;
insert into newtable
values ('EASTERN','VA',FEB78,10,7800,15500)
values ('PLAINS','NM',MAR78,2,1350,500);
select region,state,month,revenue from newtable;
quit;
values子句报错,FEB78格式不对,还试过'FEB78','FEB78'd都不对,那么此时要显示FEB78在values里面该如何写呢??各位大侠多多指教~~~