Get the Current year,Current Month,Prev Month,Prev Year

[JJP1]

hi,
iam struggling to create output to get the current year,current month,previous_year,previous_month.
and iam using below code and iam not getting waht iam expecting please.kindly help
expected output should be
all the columns should be in numeric format and not character format

   proc sql;
      create view work.WXVDZU as
         select
            
            
           (year(today())) as Current_Year length = 8
               format = z2.
               informat = z2.,
            (month(today())) as Current_Month length = 8
               format = z2.
               informat = z2.,
            (%sysfunc(year(%sysfunc(intnx(month, %sysfunc(today()), -1))))) as Previous_Year length = 8
               format = z2.
               informat = z2.,
            (%sysfunc(month(%sysfunc(intnx(month, %sysfunc(today()), -1))))) as Previour_Month length = 8
               format = z2.
               informat = z2.
      from &etls_lastTable
      ;
   quit;;

[PeterClemmensen]

Just to understand, all you want is a table with the current year, month, the previous year and the previous month?

[JJP1]

yes @PeterClemmensen  .all i need  is with the current year, current month, the previous year and the previous month values with numeric columns.

also i need informat and format values also what to mention

as iam using this in SAS DI please

[andreas_lds]

The view you are trying to create does not need any variable from "&etls_lastTable", right? Why do want to create a view at all?

[SASKiwi]

You only need %SYSFUNC if you are doing calculations on macro variables, and I see no macro variables at all. You can start by removing all uses of %SYSFUNC.

[Kurt_Bremser · Accepted solution]

To simply create a dataset, use SAS' in-built Swiss Army Knife, aka The Data Step:

data wxvdzu;
length
  current_year
  current_month
  previous_year
  previous_month
    3
;
format
  current_year
  previous_year
    z4.
  current_month
  previous_month
    z2.
;
current_year = year(today());
current_month = month(today());
previous_year = year(intnx('month',today(),-1));
previous_month = month(intnx('month',today(),-1));
run;