BookmarkSubscribeRSS Feed
pearsoninst
Pyrite | Level 9

data newdata;
Input

@1A
@3B
@5C
@7D;
datalines;
1 2 3 4
1    2 2
2    2 2
;
run;

Proc Print data = newdata;
run;

2 REPLIES 2
kannand
Lapis Lazuli | Level 10

Please see the input var definitions below:

 

data newdata;
Input
@1 A $1.
@3 B $1. 
@5 C $1.
@7 D $1.;
datalines;
1 2 3 4
1   2 2
2   2 2
;
run;
Proc Print data = newdata;
run;

Here is the output for your reference...

 

Obs	A	B	C	D
1	1	2	3	4
2	1	 	2	2
3	2	 	2	2

Hope this helps. Good Luck...!!!

Kannan Deivasigamani
ballardw
Super User

These both work

data newdata;
   infile datalines missover;
   Input
      A  1-2
      B  3-4
      C  5-6
      D  7-8
   ;
datalines;
1 2 3 4
1   2 2
2   2 2
;
run;

data newdata;
   infile datalines missover;
   Input
      A  f2.
      B  f2.
      C  f2.
      D  f2.
   ;
datalines;
1 2 3 4
1   2 2
2   2 2
;
run;
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
  • 2 replies
  • 1452 views
  • 0 likes
  • 3 in conversation