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

Hi, Is there a code to know the number of columns in a csv file? We are using a program that inputs csv files. There are sometimes errors in the input files, were they have fewer columns then they need to have. I am looking for a way to check the number of columns. If less/more then required, I will write a code to send a warning (that is not a problem). Thank you.   ... View more

Hello, I need to copy a text file from one directory to another (in linux). I am using the following code -   filename infile "/cifs/test1/test2/test3/test.txt"; filename outfile "/cifs//test10/test20/test30/test.txt"; data _null_ ; rc = fcopy(infile, outfile); run; I get rc 2004, and the file isn't copied. All help will be appreciate, Thank you. ... View more