Create macro loop from 1 to 50 like %macro loop ; %do i=1 %to 50; libname X1&i. " GDG name (&I.)" disp=shr; data test;    set X1&i; run; so on.. ... View more

What is the organisation of the file on the mainframe (FB, VB, ...) and the record size? The log from the data step would be helpful. Small hint: filename fixit ftp "'&fixedfile'" .....; lets you omit the cd='..' option. Note the single quotes inside the double quotes. ... View more

The same question as other's . data data1 ; input urn                       Post_date   : date9.        pay_amount ; format      Post_date date9.; cards;       121                                  10mar2015               100       121                                 13mar2015               100 ; run; data key; input urn                       Trans_date    : date9.         pay_amount ; format Trans_date date9.; cards;       121                                  11mar2015               100       121                                 14mar2015               100 ; run; data want; set data1(rename=(Post_date=days)) key(rename=(Trans_date=days) in=inb); by urn days; v=lag(urn);d=lag(days);i=lag(pay_amount); if inb and not lag(inb) and urn=lag(urn) ; format       d date9.; drop urn  pay_amount; run; Xia Keshan ... View more