How to skip missing values between two delimiters in SAS

sas

#1

Hello,
I am trying to read in a text file which has data like:

“Title”,“FirstName”,“LastName”
“Mr.”,“Adam”,“Smith”
“Mrs.”,“Mariam”,“Shaw”
“Mr.”,“Sparrow”
“Mr.”,“Henry”
“Mr.,Mrs.”,“Daniel”,
The code I have used:

data names;
infile '/folders/myfolders/sasuser.v94/data/names.txt' dlm = "," missover;
input Title $ FirstName $ LastName $;
run;

However the output is not correct.

Can somebody please point out to me how to read in the data correctly.
There should be a missing value between “Mr.” and “Sparrow”.Also the first row contains the headers which should not be the case.