topic Re: DATAINLINES in New SAS User

DATAINLINES

DLROW — Mon, 04 Mar 2019 19:34:45 GMT

Hi , Below is the code. Please elt me know why I get blanks for the coulumns E to H and 'I' under the coumn I instead of 'Yes'

data SAMPLE;

input A $ B $ C $ D
E F G H I $ ;
label A="A"
B="B"
C="C"
D="D";
E="E";
F="F";
G="G";
H="H";
I="I";

datalines;
CIT 05792 1/1/2016 225000 60000 1017815 4924600 233978 YES
CIT 05792 1/1/2016 225000 60000 1017815 4946901 472 YES
CARL 05295 1/1/2017 175000 50000 10187296 302304 136097 YES
CARL 05295 1/1/2017 175000 50000 10187296 900400 88954 YES

A B C D E F G H I
CIT 05792 1/1/2016 225000 . . . . I
CIT 05792 1/1/2016 225000 . . . . I
CARL 05295 1/1/2017 175000 . . . . I
CARL 05295 1/1/2017 175000 . . . . I
;

Re: DATAINLINES

Astounding — Mon, 04 Mar 2019 19:42:37 GMT

You have extra semicolons in the LABEL statement. Remove them (except the final one).

Re: DATAINLINES

tomrvincent — Mon, 04 Mar 2019 19:42:53 GMT

your log will tell you why. E is numeric.

Re: DATAINLINES

novinosrin — Mon, 04 Mar 2019 19:43:01 GMT

syntax issue in your label statement

correction:

data SAMPLE;
input A $ B $ C $ D E F G H I $ ;
label A="A"
B="B"
C="C"
D="D"
E="E"
F="F"
G="G"
H="H"
I="I";
datalines;
CIT 05792 1/1/2016 225000 60000 1017815  4924600 233978 YES
CIT 05792 1/1/2016 225000 60000 1017815 4946901 472 YES
CARL 05295 1/1/2017 175000 50000 10187296 302304 136097 YES
CARL 05295 1/1/2017 175000 50000 10187296 900400 88954 YES
;

Re: DATAINLINES

PGStats — Mon, 04 Mar 2019 19:43:31 GMT

Because you have semicolons in your LABEL statement, transforming it into a series of assignments.

Re: DATAINLINES

novinosrin — Mon, 04 Mar 2019 19:46:55 GMT

"transforming it into a series of assignments"

That's what makes Prodigygeniusstats aka PGstats exquisite, My oh My, that's attention to detail. Class!

@PGStats wrote:

Because you have semicolons in your LABEL statement, transforming it into a series of assignments.

Re: DATAINLINES

DLROW — Mon, 04 Mar 2019 19:48:56 GMT

Thank you all!

Re: DATAINLINES

Tom — Mon, 04 Mar 2019 20:35:54 GMT

Your program/date works fine for me.

Something must have gotten lost in translating your code into your posting.

Perhaps you can post lines from your SAS log? Make sure to use the insert Code pop-up window to preserve formatting.

data SAMPLE;
 input A $ B $ C $ D E F G H I $ ;
datalines;
CIT 05792 1/1/2016 225000 60000 1017815  4924600 233978 YES
CIT 05792 1/1/2016 225000 60000 1017815 4946901 472 YES
CARL 05295 1/1/2017 175000 50000 10187296 302304 136097 YES
CARL 05295 1/1/2017 175000 50000 10187296 900400 88954 YES
;
proc print;
run;