About momin

momin · ‎10-29-2014

proc gplot data=shareef.tra_pt_1m1; plot mean_*day; symbol value= star interpol=sm45; run; quit; my x-axis values arein order in the columneg 3,7,15,30,90,180,360,720. However in the plot i see it as 15,180,3,30,360,7,720 Thanks for help. Regards Mohammed Shareef

momin · ‎10-28-2014

I useddonor_relation Frequency Count related 18 spousal 23 unrelat 23 I created this file using the following code proc freq data=b ; table donor_relation/nocum nopercent out=how2; run; the question is how can I get the total sum of all frequencies at the bottom.Is there any other methodwhich I can use? non

momin · ‎10-23-2014

proc sql; select * from shareef.emp; <- remove this colon. where deptno= 20 ; quit; This one worked. Thank you RW9. Momin

momin · ‎10-23-2014

proc sql; select * from shareef.emp; where deptno='20'; quit; I was trying to run this code on sas9.2. Both where as well as having and order by not workig. However I get all departments in the output. Also following message in the log Any suggestions why it won't work. Thanking you. Mohammed Shareef 7 where deptno='20'; WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored. 8 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.20 seconds cpu time 0.14 seconds

momin · ‎08-25-2014

The SAS System EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7934 MILLER CLERK 7782 23JAN1982:00:00:00 2200.00 . 10 7782 CLARK MANAGER 7839 09JUN1981:00:00:00 3350.00 . 10 7839 KING PRESIDENT . 17NOV1981:00:00:00 6000.00 . 10 7902 FORD ANALYST 7566 03DEC1981:00:00:00 4650.00 . 20 7788 SCOTT ANALYST 7566 19APR1987:00:00:00 4400.00 . 20 7876 ADAMS CLERK 7788 23MAY1987:00:00:00 2275.00 . 20 7369 SMITH CLERK 7902 17DEC1980:00:00:00 1900.00 . 20 7566 JONES MANAGER 7839 02APR1981:00:00:00 4618.75 . 20 7900 JAMES CLERK 7698 03DEC1981:00:00:00 1587.50 . 30 7698 BLAKE MANAGER 7839 . 3962.50 . 30 7499 ALLEN SALESMAN 7698 20FEB1981:00:00:00 2400.00 300.00 30 7844 TURNER SALESMAN 7698 08SEP1981:00:00:00 2275.00 0.00 30 7521 WARD SALESMAN 7698 22FEB1981:00:00:00 1962.50 500.00 30 7654 MARTIN SALESMAN 7698 28SEP1981:00:00:00 1962.50 1400.00 30 I need a new variable called newsal which should be created using do loop for 3 years with 10,20 and 30 % for dept 10,20 and 30respectively. Thanks

momin · ‎08-25-2014

for say 5 years.

momin · ‎08-25-2014

Dear all I have an employee table where they belong to different departments. I need to hike the salaries of employee from dept A, B, and C by 10,20 and 30 % respectively using do loops. Now the question is how do I do it? Regards Mohammed Shareef

momin · ‎08-18-2014

tried again.it worked.Thanks for everyone's help.Regards Mohammed

momin · ‎08-17-2014

No,doesn't work!

momin · ‎08-17-2014

SORRY, BOTH WAYS DON'T WORK. THANKS ANYWAYS MOHAMMED

momin · ‎08-17-2014

Hi Tom, Is that the way to do it? Thanks Mohammed Data B; set Shareef.emp; dtextyear(1982); run;

momin · ‎08-17-2014

Data A; set Shareef.emp; if year(datepart(date))=1982; run; This is not working.returns zero observations. I know for sure that there is year 1982 in the following format 23jan198200.00.00 and the name of the variable is hiredate. Thanks for the help.

momin · ‎08-17-2014

How do you extract or subset observations for a specific year from variable date time from a data set ?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

x-axis doesn't order properly in gplot.Any Suggestions

How to get sum of frequencies of non numeric variables?

Re: proc sql query

proc sql query

Re: Do loops for specific variables!!

Re: Do loops for specific variables!!

Do loops for specific variables!!

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

Re: Do loops for specific variables!!

x-axis doesn't order properly in gplot.Any Suggestions

How to get sum of frequencies of non numeric variables?

Re: proc sql query

proc sql query

Re: Do loops for specific variables!!

Re: Do loops for specific variables!!

Do loops for specific variables!!

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

Re: How do you extract or subset observations for a specific year fro...

How do you extract or subset observations for a specific year from va...