data test; input empno ename$ job$ sal deptno; datalines; 7788 SCOTT ANALYST 3000.00 20 7902 FORD ANALYST 3000.00 20 7934 MILLER CLERK 1300.00 10 7369 SMITH CLERK 800.00 20 7876 ADAMS CLERK 1100.00 20 7900 JAMES CLERK 950.00 30 7782 CLARK MANAGER 2450.00 10 7566 JONES MANAGER 2975.00 20 7698 BLAKE MANAGER 2850.00 30 7839 KING PRESIDENT 5000.00 10 7499 ALLEN SALESMAN 1600.00 30 7521 WARD SALESMAN 1250.00 30 7654 MARTIN SALESMAN 1250.00 30 7844 TURNER SALESMAN 1500.00 30 ; run; proc print; run; proc sort data=test; by deptno; run; proc freq data=test; table job/nocum nopercent; by deptno; weight sal; run; Hi, Can we change the level of column frequency in the result of this programme of can we create a new dataset same as result???? thanks
... View more
data test; input month $ sale; datalines; jan 2000 feb 1400 mar 2300 apr 3400 may 2700 jun 3200 july 800 aug 2900 sep 1700 oct 2100 nov 2600 dec 3200 ; run; i m looking to convert month in num as 1 2 3 , for that i m tring it. data test1; set test; mon_num=input(month,monname3.); run; proc print; run; but its showing error. i need to short data by month. can we do it in short or sud i use if condition on each month????
... View more
data test; input month $ sale; datalines; jan 2000 feb 1400 mar 2300 apr 3400 may 2700 jun 3200 july 800 aug 2900 sep 1700 oct 2100 nov 2600 dec 3200 ; run; i m looking to convert month in num as 1 2 3 , for that i m tring it. data test1; set test; mon_num=input(month,monname3.); run; proc print; run; but its showing error. i need to short data by month. can we do it in short or sud i use if condition on each month????
... View more
data test; input month $ sale; datalines; jan 2000 feb 1400 mar 2300 apr 3400 may 2700 jun 3200 july 800 aug 2900 sep 1700 oct 2100 nov 2600 dec 3200 ; run; i m looking to convert month in num as 1 2 3 , for that i m tring it. data test1; set test; mon_num=input(month,monname3.); run; proc print; run; but its showing error. i need to short data by month. can we do it in short or sud i use if condition on each month???? desired output is month sale 1 2000 2 1400 3 2300 4 3400 .......
... View more
_n_ and _error_ each creates 2 valriable in programme data vector... what is the name of that 2 variable n type of them , thanks in advance
... View more
if u just want result then try it,, if macro variable is nt necessary for u.. data test; x='1,2,3,4,5'; do i= 0 to length(x); y=substr(x,i+1,1); i=i+1; output; end; drop i x; run; proc print; run;
... View more
Dear Sir, Plz guide me ,, is my logic is correct or i sud need to some more practice on it.. in query i need to find out top 2 sal in every dept. for that i did some work n got result, but i m bit confused on quality of my work. plz guide me. data anuj; input dept_id sal; cards; 1 1000 1 2000 1 3000 1 4000 1 5000 1 6000 1 7000 1 8000 2 1000 2 2000 2 3000 2 4000 2 5000 2 6000 3 1000 3 2000 3 3000 3 4000 3 5000 3 6000 4 1000 4 2000 4 3000 4 4000 4 5000 4 6000 5 1000 5 2000 5 3000 5 4000 5 5000 5 6000 6 1000 6 2000 6 3000 6 4000 6 5000 6 6000 6 7000 7 1000 7 2000 7 3000 8 1000 8 2000 9 1000 9 2000 9 3000 9 4000 9 5000 9 6000 9 7000 9 8000 ; run; proc sort data=anuj; by dept_id descending sal; run; data test1; set anuj; if _n_=1 then do; new_id=dept_id; i=0; end; if dept_id= new_id and i <2 then do; i=i+1; output ; end; else if dept_id NE new_id then do; new_id=dept_id; i=1;output;end; retain new_id i; drop i new_id; run; proc print; run;
... View more
hi jagdish, there is lots of way to do this in data step, like using outobs= , using obs option many more.. i was looking like function like below... proc sql number; select * from test where sal in select distinct sal from test1 where monotonic()<4 order by sal desc; quit; like it so i wud replace monotonic() function with accordingly right function , with the help of that i will get correct result . a function which updates rownumber simultaneously at the time or ordering..
... View more
data test; input name $ sal; datalines; a 8 b 3 c 7 d 2 e 4 f 6 g 9 h 10 i 1 j 5 k 10 l 9 ; run; proc sql number; create table test1 as select distinct sal from test order by sal desc; select * from test where sal in (select distinct sal from test1 where monotonic()<4) order by sal desc; quit; as monotonic() dont give real time row number so i need to run 2 queries. is there any function which give realtime row number. or which updates rownumber accordingly after ordering the data???
... View more
i m sorry i thnk i m nt able to explain my query well. i thnk i sud ask how _n_ and _error works in vector table. i m going through with ur given doc. thanks
... View more
