hello, excuse , can you show me how Using implement PROC FORMAT and a picture statement, with thanks ... View more

hello, excuse , I could not implement this formula , Is there a simpler formula .      ... View more

Hello, thanks for answering , I want to know how to convert a string like ,    2021Jun1   ...  .... 2021Dec31'into a real SAS date, ... View more

thank you very much , I would  like to clarify that  I am currently working on models VARMAX  , I hope to learn more about these topics , I would like to thank you for all the help you provided to me .     with thanks and appreeciation  ... View more

Hello , You can use Sas on demand for Academics  It's also free and runs in your browser from their cloud server.   It has the same functionality.   I  run it on my Computer .                                                  with many thanks ... View more

Sory, But the procedure requires the use of all variables Lsilverprice Lgoldprice  and variable of date OUTMONTH .there is no way to combine them , when I apply the program : title "Illustration of ODS Graphics"; proc varmax data=WANT plot(unpack)=(residual model forecasts); id OUTMONTH interval=month; model Lsilverprice Lgoldprice / dify=(1,12) noint p=0 q=1; output lead=12; run;  appears an ERROR: variable Lsilverprice not found                      ERROR variable Lgoldprice not found      when I apply the program ;   title "Illustration of ODS Graphics"; proc varmax data=IMPORT   plot(unpack)=(residual model forecasts); id OUTMONTH interval=month; model Lsilverprice Lgoldprice / dify=(1,12) noint p=0 q=1; output lead=12; run;   An error appears:  ERROR : variable OUTMONTH not found   there is no way to combine them , with  thanks and appreciation . ... View more

Sory , when I implement this program :An error apear  proc varmax data=WORK.WANT plot(unpack)=(residual model forecasts); id OUTMONTH interval=month; model Lsilverprice Lgoldprice / dify=(1,12) noint p=0 q=1; output lead=12; run;  An ERROR : variable Lsilverprice not found        ERROR variable Lgoldprice not found      I refer to data set of variable of date  OUTMONTH  but the dataset of variabls Lsilverprice Lgoldprice is WORK.IMPORT . how can do my code with many thanks . ... View more

Sory ,my orijinal data (goldprice and silverprice)   in table WORK.IMPORT and OUTMONTH created in table WORK.WANT how can I  put  it them in one table , So I can apply my program PROC VARMA .  ... View more

thank you very mach for your answer , but when I implement the program    PROC VARMAX DATA=WORK.IMPORT PRINTALL PLOTS=ALL; MODEL LSILVERPRICE LGOLDPRICE/DIF=(LSILVERPRICE(1) LGOLDPRICE(1)) Q=1 METHOD=ML; OUTPUT LEAD=25; ID outmonth INTERVAL=month; RUN; An error appears : ERROR: Variable outmonth not found . ... View more

Sorry , I am a beginner in the SAS program  , so how do I implement the conversion from numerical to datetime sas. ... View more

thank you for your answar , I have implemented the program and the result is shown below , data have; input inmonth $7.; datalines; 2016m1 2016m2 2016m3 2016m4 2016m5 2016m6 2016m7 2016m8 2016m9 2016m10 2016m11 2016m12 2017m1 2017m2 2017m3 2017m4 2017m5 2017m6 2017m7 2017m8 2017m9 2017m10 2017m11 2017m12 2018m1 2018m2 2018m3 2018m4 2018m5 2018m6 2018m7 2018m8 2018m9 2018m10 2018m11 2018m12 2019m1 2019m2 2019m3 2019m4 2019m5 2019m6 2019m7 2019m8 2019m9 2019m10 2019m11 2019m12 ; data want; set have; outmonth = input(compress(inmonth,'m'),yymmn6.); format outmonth yymm7.; run; but when I implemented the program : PROC VARMAX DATA=WORK.IMPORT PRINTALL PLOTS=ALL; MODEL LSILVERPRICE LGOLDPRICE/DIF=(LSILVERPRICE(1) LGOLDPRICE(1)) Q=1 METHOD=ML; OUTPUT LEAD=25; ID MONTH INTERVAL=MONTH; RUN; An error appears : ERROR : Variable month in list does not match type prescribd for this list   ... View more

thanks very much for your answer, but I think the data is unclear , I will send my details to be clear to you ... View more