@Sodube wrote:
This is almost working. The problem is some of the Specialties have commas, spaces, and "/" in them. (Ex: "Gynecology and Obstetrics / Maternal-Fetal Medicine" and "Psychology, Psychiatry, and Developmental Medicine") And each name is formatted Last, First Middle, Title. Included are hyphenated names and periods in titles. Example: Doe-Smith, John, M.D. Sorry my original post wasn't very descriptive.
Any thoughts?
The comma should work if you add the DSD option to the infile statement. That indicates that there may be delimiters inside the data values.
There are other ways to read this data but due to the nature of Excel and such it may be a tad more difficult to get a consistent length for the character variables.
... View more