Skip to content
Prev 363459 / 398502 Next

I had 1 problem with r

Hi SuBin,
This seems to work:

emp<-read.table(text="empno,ename,job,mgr,hiredate,sal,comm,deptno
 7369,SMITH,CLERK,7902,1980-12-17,800,,20
 7499,ALLEN,SALESMAN,7698,1981-02-20,1600,300,30
 7521,WARD,SALESMAN,7698,1981-02-03,1250,500,30
 7566,JONES,MANAGER,7839,1981-03-02,2975,,20
 7654,MARTIN,SALESMAN,7698,1981-10-22,1250,1400,30
 7698,BLAKE,MANAGER,7839,1981-05-01,2850,,30
 7782,CLARK,MANAGER,7839,1981-09-06,2450,,10
 7788,SCOTT,ANALYST,7566,1982-12-08,3000,,20
 7839,KING,PRESIDENT,,1981-11-17,5000,,10
 7844,TURNER,SALESMAN,7698,1984-10-08,1500,,30
 7876,ADAMS,CLERK,7788,1983-01-12,1100,,20
 7900,JAMES,CLERK,7698,1981-12-03,950,,30
 7902,FORD,ANALYST,7566,1981-12-13,3000,,20
 7934,MILLER,CLERK,7782,1982-01-25,1300,,10",
 header=TRUE,sep=",")

emp[grep("^A",emp$ename),c("ename","sal")]
  ename  sal
2  ALLEN 1600
11 ADAMS 1100

Jim
On Mon, Aug 22, 2016 at 3:06 PM, ??? <subincj at naver.com> wrote: