topic Re: I want to make a SAS data set using datalines data , what should I do ? in SAS Programming

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

tianerhu — Sun, 08 Aug 2021 18:42:33 GMT

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

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

jimbarbour — Sun, 08 Aug 2021 19:48:39 GMT

I don't understand. What ate you asking?

If you are getting errors, please post your log.

Jim

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

tianerhu — Sun, 08 Aug 2021 19:51:33 GMT

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' .

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

Astounding — Sun, 08 Aug 2021 20:07:25 GMT

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.

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

tianerhu — Sun, 08 Aug 2021 20:37:14 GMT

Thank you for your help.