03-27-2025
Taliah
Quartz | Level 8
Member since
01-21-2019
- 49 Posts
- 0 Likes Given
- 2 Solutions
- 0 Likes Received
-
Latest posts by Taliah
Subject Views Posted 528 03-27-2025 09:44 AM 569 03-27-2025 08:45 AM 1353 11-05-2024 05:50 AM 2170 10-30-2024 07:17 AM 1352 07-30-2024 04:53 AM 897 07-30-2024 04:52 AM 1446 07-28-2024 08:31 AM 1620 07-22-2024 08:27 AM 937 03-31-2024 05:15 AM 1091 03-28-2024 12:38 PM -
Activity Feed for Taliah
- Posted Re: proc autoreg direction of AR1 estimate on SAS Forecasting and Econometrics. 03-27-2025 09:44 AM
- Posted proc autoreg direction of AR1 estimate on SAS Forecasting and Econometrics. 03-27-2025 08:45 AM
- Posted Re: Autogerression direction of the AR estimate on SAS Forecasting and Econometrics. 11-05-2024 05:50 AM
- Posted Autogerression direction of the AR estimate on SAS Forecasting and Econometrics. 10-30-2024 07:17 AM
- Posted Re: Autoregression predicting yearly sum on SAS Forecasting and Econometrics. 07-30-2024 04:53 AM
- Posted Autoregression when predicting yearly sum on SAS Forecasting and Econometrics. 07-30-2024 04:52 AM
- Posted Re: Autoregression predicting yearly sum on SAS Forecasting and Econometrics. 07-28-2024 08:31 AM
- Posted Autoregression predicting yearly sum on SAS Forecasting and Econometrics. 07-22-2024 08:27 AM
- Posted Re: Using MAPE for Autoregression on SAS Forecasting and Econometrics. 03-31-2024 05:15 AM
- Posted Using MAPE for Autoregression on SAS Forecasting and Econometrics. 03-28-2024 12:38 PM
- Posted Re: counting number of columns in csv file on SAS Programming. 03-04-2024 06:00 AM
- Posted Re: counting number of columns in csv file on SAS Programming. 03-04-2024 05:21 AM
- Posted Re: counting number of columns in csv file on SAS Programming. 03-04-2024 05:19 AM
- Posted counting number of columns in csv file on SAS Programming. 03-04-2024 04:03 AM
- Posted Re: "Draging" data from one row to following rows on SAS Programming. 02-29-2024 10:02 AM
- Posted "Draging" data from one row to following rows on SAS Programming. 02-29-2024 09:37 AM
- Posted Re: checking number of columns in a csv file on SAS Programming. 10-25-2023 05:38 AM
- Posted checking number of columns in a csv file on SAS Programming. 10-25-2023 05:21 AM
- Posted Re: fcopy with directory paths on SAS Programming. 03-20-2023 07:09 AM
- Posted fcopy with directory paths on SAS Programming. 03-20-2023 05:06 AM
03-27-2025
09:44 AM
I was searching for that question and answer and couldn't find it
Thank you!
... View more
03-27-2025
08:45 AM
Hello, in the results of proc autoreg we get a negetive AR1 estimate. Based on the data an on buisness logic we know that the higher AR1 the higher the dependent veriable and it's prediction. Does that make sense and does that mean that the direction AR1 influences the dependent veriable is oposite to the estimate's direction we get from SAS? Thank you
... View more
11-05-2024
05:50 AM
Thank you
The code is -
proc autoreg data= file1 outest=file2 plots;
model y= x1 x2 x3 x4/
model=ML
maxiter=100
NLAG=(1)
backstep slstay=0.0500
dw=1;
output out=file3 lcl=lcl ucl=ucl p =predicted rm=r pm=pm r=residual alphacli=0.05;
run;
Does that enable an answer to what I asked above?
Thank you!
... View more
10-30-2024
07:17 AM
Hello
I'm running proc autoreg. In the results the estimate of AR1 is negetive (-0.58)
The data is such that I would expect that the higher the value of the dependent varaiable in the previous data line (coresponding to AR1) the higher the value of the dependent vaiable in the current month.
Is it correct to say that a negetive estimate of AR1 means that the higher the value of the dependent varaiable in the previous data line (coresponding to AR1) the higher the value of the dependent vaiable in the current month?
Thank you!
... View more
07-30-2024
04:53 AM
Thank you! I posted the question on that board as you suggested
... View more
07-30-2024
04:52 AM
Hello
I need to build a statistical model using monthly data (each row is one month) predicting for each row the sum of variable Y for the next 12 months. I am using proc autoreg, and am getting Durbin Watson below or around 1 (i.e., autocorrelation in the data even after including AR variables). I understand why that is happening, as the model is predicting the sum of variable y for the following 12 rows. Any solution will be helpfull. Thank you.
... View more
07-28-2024
08:31 AM
Hi all,
I'm trying again to send the question above, anything you can say about it can help
Than you!
... View more
07-22-2024
08:27 AM
Hello
I need to build a statistical model using monthly data (each row is one month) predicting for each row the sum of variable Y for the next 12 months. I am using proc autoreg, and am getting Durbin Watson below or around 1 (i.e., autocorrelation in the data even after including AR variables). I understand why that is happening, as the model is predicting the sum of variable y for the following 12 rows. Any solution will be helpfull. Thank you.
... View more
03-31-2024
05:15 AM
Thank you very much for all the details!
... View more
03-28-2024
12:38 PM
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
03-04-2024
06:00 AM
I tried it again and it worked (not sure what happened the first time I tried it), Thank you!
... View more
03-04-2024
05:21 AM
The next step is comparing the number of columns counted with teh expected number, and if they are different the code sends a warning email and stops running (abort cancel)
... View more
03-04-2024
05:19 AM
Thank you! the m modifier works great.
You wrote " To avoid a result of 1 in case of a blank line (no delimiters)" -
you mean if row 1 has no modofiers, and no data?
When I add the addition you gave and the file has modifiers and data in row 1, it subtracts 1 from the count (as you wrote), so I can't add that to the code (I am trying to understand what you are suggesting), Thank you!
... View more
03-04-2024
04:03 AM
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