topic Re: Get the Current year,Current Month,Prev Month,Prev Year in SAS Programming

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

JJP1 — Wed, 20 Nov 2019 07:20:34 GMT

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;;

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

PeterClemmensen — Wed, 20 Nov 2019 07:23:47 GMT

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

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

andreas_lds — Wed, 20 Nov 2019 07:38:32 GMT

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?

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

JJP1 — Wed, 20 Nov 2019 07:40:26 GMT

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

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

SASKiwi — Wed, 20 Nov 2019 07:41:14 GMT

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.

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

Kurt_Bremser — Wed, 20 Nov 2019 08:20:36 GMT

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;