About umar_milanzi

umar_milanzi · ‎05-30-2017

Thanks @Astounding this looks like it is doing what i want. Thanks everyone for the inputs.

umar_milanzi · ‎05-30-2017

data have; input customer_name $ Mobile_Number ; datalines; john 555777 sam 556865 joe 555888 sam+joe 556865 tim 555777 ; run;

umar_milanzi · ‎05-30-2017

hi All, i need help. I have a dataset, sample below: CUSTOMER_NAME MOBILE_NUMBER John 555-777 Sam 556-865 Joe 555-000 Sam+Joe 556-865 Tim 555-777 want to output customers with same mobile number but different names. in the data above we can see that Sam and Sam+Joe have the same number, this means Sam is Joe's partner so they can have the same number. but John and Tim are not connected and have the same number, those are the guys i want to output thanks in advance

umar_milanzi · ‎06-10-2016

i have a dataset that looks like customer_id cellphone deeee 0897777 deesss 65788 reeesss 7866 (not real values) I want to check which of the customer_id has the same cellphone value

umar_milanzi · ‎06-08-2016

do i have to create the vbs file? cant i do it with a script of just clicking?

umar_milanzi · ‎06-08-2016

@Kurt_Bremser yes i used that

umar_milanzi · ‎06-08-2016

Hi, I am using SAS EG 5.1 on windows 7. i have project that has Autoexec and flow other process flows. i want to schedule it to run automatically it around 7 am. i used the windows task scheduler, it only runs the autoexec and it stops how can i get it to run all the way

umar_milanzi · ‎04-26-2016

i normaly disconnect from the server all together. the down side to this is that if you are extracting from the database you will have the process cotinuing in the background. I then use the below code to kill those processes data _null_; x 'kill -9 process_id'; run; to get your process_id there are few unix commands to use to determine what processes are linked to your user profile. unfortunately i am not that good with unix. to make things easy for me, i always ask my administrator if there are any processes running under my name. i normally get a list in the morning of processes that i have executed for more than 12 hours

umar_milanzi · ‎04-26-2016

hi, i am running a piece of code in SAS Enterprise Guide. the log is empty and when i click details it just shows running data extraction is it possible to write a code or do something to SAS EG to see how much percentage is completed and estimated time to complete the potion of the code? please help regards,

umar_milanzi · ‎04-20-2016

thanks Manu you guys are stars i truly appreciate this

umar_milanzi · ‎04-20-2016

Thanks Reeza

umar_milanzi · ‎04-20-2016

Hi Reeza thanks for the clarity. i see that your code joins two tables. how will the code be if the data is contained in one table. like in my sample code provided. how can i compare first value of 'Salary' to other values?

umar_milanzi · ‎04-20-2016

hi , iam trying to monitor some financial figures. i have 2 values that i need to work with but i just dont have an idea on how i will write this interms of sas coding. please help my values are as follows: Trans_Type Amount Salary 10000 Cheq Dep 1000 Sandry Dep 2000 my desire results is that any amount that is more than 20% of the salary should be flagged 1. and any amount below 20% of the salary should be flagged 0. anyone please help urgently!!! thanks in advance

umar_milanzi · ‎04-20-2016

hi , iam trying to monitor some financial figures. i have 2 values that i need to work with but i just dont have an idea on how i will write this interms of sas coding. please help my values are as follows Trans_Type Amount salary 10000 Cheq dep 1000 Teller dep 5000 my desire results is that any amount that is more than 20% of the salary should be flagged 1. and any amount below 20% of the salary should be flagged 0. anyone please help urgently!!! thanks in advance

umar_milanzi · ‎04-20-2016

hi , iam trying to monitor some financial figures. i have 2 values that i need to work with but i just dont have an idea on how i will write this interms of sas coding. my values are as follows Trans_Type Amount salary 10000 Cheq dep 1000 Teller dep 5000 my desire results is that any amount that is more than 20% of the salary should be flagged 1. and any amount below 20% of the salary should be flagged 0. anyone please help urgently!!! thanks in advance

Online Status	Offline
Date Last Visited	‎08-02-2017 03:03 AM

Re: Select Distinct Duplicate values

Re: Select Distinct Duplicate values

Select Distinct Duplicate values

SAS Code

Re: SAS EG Project Scheduling help

Re: SAS EG Project Scheduling help

SAS EG Project Scheduling help

Re: Stopping take too long.

percentage process of the code

Re: comparing 2 amount values

Re: Select Distinct Duplicate values

Re: Select Distinct Duplicate values

Select Distinct Duplicate values

SAS Code

Re: SAS EG Project Scheduling help

Re: SAS EG Project Scheduling help

SAS EG Project Scheduling help

Re: Stopping take too long.

percentage process of the code

Re: comparing 2 amount values

Re: comparing 2 amount values

Re: comparing 2 amount values

comparing 2 amount values

comparing 2 amount values

comparing 2 amount values

SAS Global Forum 2016