BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ronein
Meteorite | Level 14

Hello

Why in the output I see only one raw?

Data have;
input ID X1 X3 W1 W3 W2 X2 X4 X5 X6 W4 W5 W6 Z1 Z2 Y1 Y2 Y3 Z3 Z4 Z5 Y4 Y5 Y6;
Cards;
999 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
888 3 2 1 5 6 7 8 6 10 11 17 13 14 15 16 17 18 21 20 21 22 25
;
Run;
1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Because you have 24 variables and 23 values specified in the first row. That is why SAS places the value 888 (from the second datalines row) in the last variable in the resulting data set. 

 

Use Missover / Flowover etc. to control the input buffer.

View solution in original post

1 REPLY 1
PeterClemmensen
Tourmaline | Level 20

Because you have 24 variables and 23 values specified in the first row. That is why SAS places the value 888 (from the second datalines row) in the last variable in the resulting data set. 

 

Use Missover / Flowover etc. to control the input buffer.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 348 views
  • 1 like
  • 2 in conversation