Hello, good afternoon, I would like to ask for a little help with something. In the Guide server we have several tables listed by years, I have a process which analyzes the tables but what I want to achieve is that the user selects the year with a prompt and executes the analysis qwerys.
These are examples with the names of the tables that I have.
thanks for your time.
Here is a qwery, text in red I would like it to be variable by year in the FROM. if the person enters 2020 take the table TABLE2020, if the person enters 2019 that take the table TABLE2019
CREATE TABLE WORK.QUERY_TABLETEST AS
(INPUT(t1.IdComuna,BEST32.)) AS ID_COMUNA
(SUM(t1.Col01 - t1.Col04 - t1.Col05 )) AS TOTAL
FROM TABLE2020 t1
maybe I could explain myself better
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.