I want to make a SAS data set using datalines data , what should I do ?

[tianerhu]

data bank2;
infile datalines dsd;
input name $ rate;
datalines;
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
;
run;
proc print data = bank2;
run;

[jimbarbour]

I don't understand. What ate you asking?

If you are getting errors, please post your log.

Jim

[tianerhu]

I want to make a SAS data set using datalines statement ,the data in the datalines as following：

FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728

the variable name is 'name' and 'rate' .

[Astounding · Accepted solution]

Your sample program is most of the solution.  However, by reading across from left to right and taking whatever is found in the data, the program has to decide how many characters to use to store NAME.  In that situation, the software automatically uses a length of 8, so values of NAME will be truncated.  To fix that, define NAME before the INPUT statement:

data bank2;
infile datalines dsd;
length name $ 15;
input name $ rate;
datalines;
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
;

Just select a length that makes sense for the data you need to read.

Also note, if some values of NAME contain an embedded blank such as "First Capital", you will need to take additional steps.

[tianerhu]

Thank you for your help.