topic Re: how to read Blank(no dot just white space) values in SAS Programming

how to read Blank(no dot just white space) values

pearsoninst — Tue, 17 Nov 2015 18:42:12 GMT

data newdata;
Input

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

Proc Print data = newdata;
run;

Re: how to read Blank(no dot just white space) values

kannand — Tue, 17 Nov 2015 19:01:06 GMT

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

Re: how to read Blank(no dot just white space) values

ballardw — Tue, 17 Nov 2015 19:01:09 GMT

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;