Hello, Do you know if MAPE can be used to asses an autoreg model. Using proc Autoreg, it is listed in the results, but we understand that some statisticians do not like to use it (maybe we misunderstood). If it is not a good way to asses the model, which of the other measures provides a good assessment? Thank you! ... View more

Hello, In order to detect problems with csv input files I count the number of columns in them (and compare them with the expected number), using the code: data _null; infile "&dir.test.csv"; input; call symputx("ncol_file1", countw(_infile_,",")); stop; run; This works fine when all columns have data in row 1 (the data set is without column names). When a column does not have data in row 1 the resulting number of columns is without that column. Is there a way to count a column even when the first row (or several first rows) are without data? Thank you!   ... View more

Hello, I have a data set like: A  B 1   11 2  12 3  13 4  0 5  0 6  0 7  0 The goal is to have SAS search for all locations of b=0 and enter instead the lag of b, draging it throughout all "0"s, to get 1  11 2  12 3  13 4  13 5  13 6  13 7  13 I'm using the code data test1; set test; x=lag(b); if b=0 then b=x; run; Only b in line 4 gets to be 13, not the following rows, in them b stays 0. Any help will be appriciated. This data set is an example, we do not know how many row there are with b>0 and how many with b=0, those rows can be at the end but also in other placed in the data set. Thank you! ... View more