Fiche Data Prep

data casuser.identities; infile datalines delimiter=','; length name $ 20 address $ 30 email $ 30; input id name $ address $ email $; datalines; 1, John Smith, 123 Main St, j.smith@example.com 2, Jon Smith, 123 Main Street, j.smith@example.com 3, Mary Jones, 456 Oak Ave, mary.jones@example.com 4, John Smith, 789 Pine Ln, jsmith@work.com 5, Mary Jones, 456 Oak Ave, mary.jones@example.com ; run;