%let repmword=%sysfunc(mdy(&repmonth,1,&repyear),monname9.);
what does this function mean?
%SYSFUNC(function(argument(s))<, format>)
The second parameter to SYSFUNC() is a format, so whatever is processed as the first argument will get formatted as MONNAME9.
MONNAME format -> Writes date values as the name of the month.
MDY() function -> Returns a SAS date value from month, day, and year values.
SAS Functions by Category:
So first argument is creating a date and second formats it as a month.
%SYSFUNC(function(argument(s))<, format>)
The second parameter to SYSFUNC() is a format, so whatever is processed as the first argument will get formatted as MONNAME9.
MONNAME format -> Writes date values as the name of the month.
MDY() function -> Returns a SAS date value from month, day, and year values.
SAS Functions by Category:
So first argument is creating a date and second formats it as a month.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.