Changes
Jump to navigation
Jump to search
no edit summary
**Either make a lookup table or find the patterns
**Build a new variable to add the 'clean title'
*Create a man/women variable (0 if man, 1 if women)- DONE**Load up your census names- DONE**Find the distinct man/women names-DONE. built SQL table w name plus 0,1 value.
**Write an SQL query to JOIN a man/woman variable when title = DR
*Build the output table in SQL
