编了一个用 sql的。没有标记,新的数据集是finally—4 原数据集是 finally—3
- proc sql ;
- create table work.finally_4 as
- select * from finally_3 ;
- delete from work.finally_4
- where item="Mean" and item="STD" ;
- quit ;
- 444 proc sql ;
- 445 create table work.finally_4 as
- 446 select * from finally_3 ;
- NOTE: Table WORK.FINALLY_4 created, with 13 rows and 4 columns.
- 447 delete from work.finally_4
- 448 where item="Mean" and item="STD" ;
- NOTE: No rows were deleted from WORK.FINALLY_4.
- 449 quit ;
- NOTE: PROCEDURE SQL used (Total process time):
- real time 0.01 seconds
- cpu time 0.01 seconds
- data finally_4 ;
- set finally_3 ;
- obs=_n_ ;
- run ;
obs 在最后一列,这个不算标记上吧
把上面程序的 where item="Mean" and item="STD" ; 换成 where obs=7 有error
之前编写过一个其他的code
- data Age_sum2_ ;
- set Age_sum2 (rename=( _STAT_=item colA=GroupA colB=GroupB colC=GroupC)) ;
- if item="MEAN" then delete ;
- if item="STD" then delete ;
可以删除行
为什么用sql的删除语句
delete from 《表名》
《where语句》
删不了呢