You need to tell it to skip over the header line. That is most likely why the first observation is all missing. You can use the FIRSTOBS= option on the INFILE statement.
Your file probably was made on a PC and so is using CR+LF as the end of line characters instead of LF like Unix uses. That is probably what is causing the last variable to not be read as the CR character is making the value an invalid numer.
You also migth want to define STORE as longer than the default 8 characters. 8 should be enough for the values you have posted, but if later in the file there are longer values they will be truncated.
Try this.
data SAM.vikas;
infile '/folders/myshortcuts/MyFolders/SAS Data.txt'
firstobs=2 termstr=CRLF truncover
;
length store $12 ;
input Store Revenue Staff Salary Operation Profit Complaint Turnover;
run;
... View more
