Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to setup variables in Vertica

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.