HI Arthur it only took 1 day and code stop working story of my life lol I here is there error log ERROR: Array subscript out of range at line 79 column 205. Atmcodenumber=CA2644 DispCashAmt=1800.00 Date=9 FIRST.Atmcodenumber=0 LAST.Atmcodenumber=1 date1=839.00 date2=0.00 date3=0.00 date4=1045.00 date5=1200.00 date6=245.00 date7=0.00 date8=0.00 ___nnum=9 ___i=1 _ERROR_=1 _N_=12804 ng this step because of errors. NOTE: There were 12805 observations NOTE: The SAS System stopped process iread from the data set WORK._TEMP. be incomplete. When this step was stopped there were 1854 WARNING: The data set WORK.WANT1 ma y here is that line #79script not sure if the error is in the macro or tables %macro transpose(libname_in=, libname_out=, data=, out=, by=, prefix=, var=, autovars=, id=, var_first=, format=, delimiter=, copy=, drop=, sort=, sort_options=, use_varname=, preloadfmt=, guessingrows=, newid=row); /*Check whether the data and out parameters contain one or two-level filenames*/ %let lp=%sysfunc(findc(%superq(data),%str(%())); %if &lp. %then %do; %let rp=%sysfunc(findc(%superq(data),%str(%)),b)); %let dsoptions=%qsysfunc(substrn(%nrstr(%superq(data)),&lp+1,&rp-&lp-1)); %let data=%sysfunc(substrn(%nrstr(%superq(data)),1,%eval(&lp-1))); %end; %else %let dsoptions=; %if %sysfunc(countw(&data.)) eq 2 %then %do; %let libname_in=%scan(&data.,1); %let data=%scan(&data.,2); %end; %else %if %length(&libname_in.) eq 0 %then %do; %let libname_in=work; %end; %if %sysfunc(countw(&out.)) eq 2 %then %do; %let libname_out=%scan(&out.,1); %let out=%scan(&out.,2); %end; %else %if %length(&libname_out.) eq 0 %then %do; %let libname_out=work; %end; THanks again
... View more
