Macrovariable in SAS Viya Data Studio (manage data)

[elmendamian]

Hi everyone.

I'm trying to replicate a SAS 9 code in SAS Viya Data Studio to clean my data.

The SAS 9 code has a macro variable that not works in SAS Viya Data Studio (manage data). I mean, the code shows an error when I include the macro variable.
Here is a code works:

/* BEGIN data step with the output table data */
data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}} promote="no");
/* Set the input set */
set {{_dp_inputTable}} (caslib={{_dp_inputCaslib}} );
/* END data step run */
      CERAPTFIS_CATEGORIA_IDCATEGOR = upcase(trimn(left(compbl(CERAPTFIS_CATEGORIA_IDCATEGOR))));
      
	  ceraptfis_fechexped = datepart(ceraptfis_fechexped);
      CERAPTFIS_VIGENCIA  = datepart(CERAPTFIS_VIGENCIA);
      CERAPTFIS_FECEXAMED = datepart(CERAPTFIS_FECEXAMED);
      CERAPTFIS_FECHCANCE = datepart(CERAPTFIS_FECHCANCE);
	  format ceraptfis_fechexped CERAPTFIS_FECEXAMED CERAPTFIS_VIGENCIA CERAPTFIS_FECHCANCE date9.;
	  if CERAPTFIS_FECHEXPED > "10dec2019"d;
run;

And here is not works code:

%let par_fecha_hoy = 10dec2019;
/* BEGIN data step with the output table data */
data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}} promote="no");
/* Set the input set */
set {{_dp_inputTable}} (caslib={{_dp_inputCaslib}} );
/* END data step run */
      CERAPTFIS_CATEGORIA_IDCATEGOR = upcase(trimn(left(compbl(CERAPTFIS_CATEGORIA_IDCATEGOR))));
      
	  ceraptfis_fechexped = datepart(ceraptfis_fechexped);
      CERAPTFIS_VIGENCIA  = datepart(CERAPTFIS_VIGENCIA);
      CERAPTFIS_FECEXAMED = datepart(CERAPTFIS_FECEXAMED);
      CERAPTFIS_FECHCANCE = datepart(CERAPTFIS_FECHCANCE);
	  format ceraptfis_fechexped CERAPTFIS_FECEXAMED CERAPTFIS_VIGENCIA CERAPTFIS_FECHCANCE date9.;
	  if CERAPTFIS_FECHEXPED > "&par_fecha_hoy."d;
run;

I need to invocate lot of macros and macrovariable like SAS 9.

Anyone knows how I can use macros and macrovariables in SAS Viya Data Studio (manage data).

Thank you very much.

[VDD]

is CERAPTFIS_FECHEXPED in your dataset a date field?

SAS dates are stored as numbers and your d. is not converting your macro to a number.

[elmendamian]

Hi VDD.

Yes CERAPTFIS_FECHEXPED is a date column and his format is date9.

[VDD]

@elmendamian you need to do something like this to convert your stringed macro date to a number that represents SAS date values.

%let mydate = 10dec2019;
data _null_;
yesterday = input("&mydate",date9.);
put yesterday;
run;