The major reason this code will fail:  perhaps your data set already contains a variable named CHANGE.  It's illegal to use the same name for both a variable and an array.   As @ballardw pointed out, it is not a good idea to use this form of a DATA step:   data outdb.outdata; set outdb.outdata; .....   This is dangerous, particularly when your code needs to be tested and debugged.  It is possible that your original version of the data did not contain a variable named CHANGE, but one of the tests inadvertently added such a variable to the data set.   In any event, use an array name that does not duplicate the name of an existing variable.  If that's not the problem, post the log because the log messages are always an important clue. ... View more

You can use the INTCK function to count the months between two dates.  So all you need is the date of the first record (retained across all observations) and date of the N'th record:   data want (drop=_:); input @25 date ddmmyy6.; format date date9.; if _n_=1 then _first_date=date; retain _first_date; month=1+intck('month',date,_first_date); run; ... View more

If you are uploading a SAS dataset then you should be using these options. I'm assuming here you want your SAS dataset converted to mainframe format so it can be used by other mainframe SAS programs. If this is not the case please advise.   libname locref '\\ABC\xyz\aaa\ccc'; rsubmit; libname lref 'VPMS.D06.CAM.DROPPED' disp = new; proc upload data=locref.dropped_cam out=lref.dropped_cam; run; endrsubmit;      ... View more

@tapas_16880 fix it to what? You don't actually say...     When you specify values in the INPUT statement it is assumed as an INFORMAT not the type. If you want the types declared, i.e. length and type then you need to do it manually before your INPUT statement. A Length statement is a good method.   length accountNumber $8 sort_code $6 party_ID $6.; *for character; length i_dets_curr_no_arrs_disp_aj 8. ; You should also note the the length for numeric variables it the number of bytes it can store, not that 8 means it will have 8 digits.  ... View more

var16, var17, var18, var19 etc is just awful data structure.   Your explanation makes no sense to me.  I don't see why you need an array.  We are not clear on what you are actually trying to achieve.    https://meta.stackexchange.com/questions/66377/what-is-the-xy-problem     ... View more