DATAINLINES

[DLROW]

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
;

[Astounding · Accepted solution]

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

[tomrvincent]

your log will tell you why. E is numeric.

[novinosrin]

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
;

[PGStats]

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

[novinosrin]

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

---

[DLROW]

Thank you all!

[Tom]

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;