cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
M_Elteibi
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 4 Likes Received
About
Mohammad has applied his statistical knowledge in a number of industries ranging from health to financial services & marketing research in both Australia and abroad. This experience has honed his ability to translate business needs into analytical problems and providing actionable recommendations. Through a number of roles were Mohammad has executed countless number of analytical projects from building predictive models, segmentations to establishing analytical frameworks used across organisations. In addition Mohammad has worked on driving business results through the effective utilisation of analytical outcomes the last of which earning him and his project team a CEO award from the Commonwealth Bank of Australia. Mohammad views analytics as a set of tools that when used correctly and applied by skilled statisticians can lead business to great outcomes. He is also an effective translator and a data story teller. He utilises tools such as SAS including Enterprise Guide, Base Programming and Enterprise Miner, SAS MACRO, SPSS including Clementine, STATA, R, SQL programming and others.

Re: Help with freq and duplicates

by Calcite | Level 5 in SAS Procedures
‎11-07-2013 07:46 PM
‎11-07-2013 07:46 PM
Hi nicnad, Seems what you need to do is deduct 1 from each frequency then add up the new variable as follows. DATA NUM_OF_DUPS; SET  Form1_DUPIDS; DUP_VALUES = COUNT - 1; run; Proc Means Data = Num_of_dups SUM; var DUP_VALUES; run; that should give you the number of duplicate values. Cheers, Mohammad ... View more

Re: Identifying and deleting duplicates by multiple variables

by Calcite | Level 5 in SAS Data Management
‎10-31-2013 07:52 PM
4 Likes
‎10-31-2013 07:52 PM
4 Likes
Hi emcee825, If i may suggest a different approach. From my understanding you want to join 2 tables produce a new table that only contains records that are matched on  dob lnam disease1. If that is the case i would suggest simply using PROC SQL for this task. Such as PROC SQL;      CREATE TABLE NEW_DISTINCT_TABLE AS SELECT * FROM perm.avss_2 as a JOIN perm.calredie_2 as b ON a.dob = b.dob AND a.lnam = b.lnam AND a.disease1 = b.disease1 ; QUIT; OR if you have completed the merge and only want to create a new table with unique rows across all variables you could use PROC SQL with DISTINCT as PROC SQL; CREATE TABLE only_distinct as SELECT DISTINCT * FROM my_combined_table ; QUIT; Hope this helps. Mohammad ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links