Hi mates,   I need a way to create a three positional input due the following txt file:    F 015 3 20151029 019 0100 00000000000000 20151029 102004 20151029 47,28 1530215000019 591 PAGAMENTO INCLU 019 0100 00000000000000 20151029 102155 20151029 212,50 1530215000020 . . 018 0023 00000000000000 20151029 103258 20151029 538,85 1530215000021   The first line will start with the F in the column1, 015 in the column 2 and 3 in the column3, all the other values should match for the first row, but in the third row the "019" should be at the same position of "019" in the first line.   To understant what i'm saying, the first textbox is how my raw file is in SAS, the second textbox bellow is represented on how the third row should begin:    F 015 3 20151029 019 0100 00000000000000 20151029 102004 20151029 47,28 1530215000019 591 PAGAMENTO INCLU 019 0100 00000000000000 20151029 102155 20151029 212,50 1530215000020 . . 018 0023 00000000000000 20151029 103258 20151029 538,85 1530215000021 So what i want is to read the first and the second line and print the into the first line.   The third row should begin to read or print the value at the same column of the "019" and put missing to the first 4 columns.   The final output i'm trying to make is this:    F| 015| 3| 20151029 | 019 | 0100 | 00000000000000| 20151029 |102004| 20151029| 47,28 |1530215000019| 591| PAYMENT | | | | 019 | 0100 | 00000000000000| 20151029 |102155| 20151029| 212,50 |1530215000020| 591| PAYMENT | | | | 018 | 0023 | 00000012344534| 20151029 |103258| 20151029| 538,85 |1530215000021| |   My code is this: DATA TEST; /* INFILE "/home/re43526/quickview/TI47_*.txt"*/ /* TRUNCOVER FIRSTOBS=11;*/ INPUT F1 $1-4 F2 $4-8 F3 $22-25 F4 $26-34 F5 $43-58 F6 $ F7 $ F8 $ F9 $ F10 $115-135 #2 F11 $1-4 F12 $4-50; CARDS; F 015 3 20151029 019 0100 00000000000000 20151029 102004 20151029 47,28 1530215000019 591 PAYMENT 019 0100 00000000000000 20151029 102155 20151029 212,50 1530215000020 . . 018 0023 00000000000000 20151029 103258 20151029 538,85 1530215000021 ; RUN;   But i'm having a lot trouble to make this. Can you help me ?   Thanks in advance ... View more

Hi mates,   I need to read a raw datafile just like this:   Joe Smith 20 M 35000 BS Jane Doe 24 F 50000 MS Matt Brown 30 M 65500 HS Mike Johnson 55 M 85000 PhD   I've tryed the following code but doesn't work:   data new; infile "path/test.txt"; length fname $6 lname $10 sex $1 education $3; informat lname $10. income 7.; input fname 1-6 @7 lname / age 1-3 sex +1 income @14 education; run; The code is from this link: http://www.lexjansen.com/nesug/nesug08/ff/ff01.pdf   I need a way to tell the input statement when it needs to read the next line, how can i do that ? I forgot.   Thanks   ... View more

Hi mates, I'm trying to make a join where some of my dates are as follows:   date of table 1 = 12apr2015:00:23:46 date of table 2 = 13apr2015:00:23:46   I'd like to join these table in condition just like d1.date = d2.date + 1*24*60*60(one more day). But consider that some dates are the same in both tables but sometimes they don't.   In fact the join should match in both cases.   The code to test is this:   data have; infile datalines4; format date date9.; input ID$ VISIT value1 value2 value3 date:date9. ; datalines4; A 1 5 7 9 16jan2015 A 2 . . . 14feb2015 A 3 . . . 27mar2015 A 4 10 5 3 17apr2015 A 5 . . . 17may2015 B 1 11 2 6 18jun2015 B 2 . . . 19jul2015 B 3 16 7 9 10aug2015 B 4 . . . 11sep2015 B 5 18 20 5 17oct2015 ;;;;;; run; %macro date(num); data want; set have; %do i =1 %to 3; if value&&i. = . then value&&i.=0; %end; run; %mend; %date(3); data last; infile datalines4; format date date9.; input x$ date:date9.; datalines4; A 17jan2015 A 15feb2015 A 28mar2015 A 18apr2015 A 18may2015 B 19jun2015 B 20jul2015 B 11aug2015 B 12sep2015 B 17oct2015 ;;;;;; run; proc sql; create table final as select * from want as w right join last as l on (w.date=l.date); quit;   How can i fix this ?   Thanks before any answer ... View more