Any tips on why this does not work? The first value for Name has an embedded blank so between Name and Amount, I used two blanks for the first 3 rows. They read in fine. The last observation does not have a value for Name. I tried to add one or two blanks before the amount (40), but still could not read in the last row correctly.
infile datalines missover DSD DLM=' ';
input Name$ & Amount;
Dan Inc 100
proc print data=work.test;
If there is a chance you will have a blank value, then you will need to consider using the _INFILE_ automatic variable to parse your input record with the SCAN function (or possibly using FIND, INDEX/INDEXW/INDEXC).
Google advanced search argument, this topic / post:
The & (ampersand) format modifier enables you to read character values that contains one or more embedded blanks with list input and to specify a character informat. SAS reads until it encounters two consecutive blanks, the defined length of the variable, or the end of the input line, whichever comes first.