How to setup variables in Vertica

9 years ago
Feb 15, 2017 8:06 PM UTC
1 reply
5 views

sau7590

I am basically trying to convert SAS code which hits vertica to SQL queries understood by vertica..

Can someone help me know how to store values in variable.Note:i am using Squirrel SQL to write my vertica understanble SQL queries.Trying to convert
%LET RUNOUT = 0;
%LET PERIODS = 4;
%let ENRLMNTDY = 15;
%LET RUN_DATE = %SYSFUNC(TODAY());
%LET START_DATE = %SYSFUNC(INTNX(MONTH, &RUN_DATE.,%EVAL(-12*&PERIODS.-&RUNOUT.),B));
%LET END_DATE = %SYSFUNC(INTNX(MONTH, &RUN_DATE.,%EVAL(-1-&RUNOUT.),E));

to variables in vertica