How to change libname folder to current year

[BonnaryW]

Hello,

We have a folder with year (folder2014, folder2015) and every new year, we have to modify the libname to read the current year. Is there a way to subsutiute the year with the %sysfunc(year("&sysdate"d));

LIBNAME '/SASLIBRARY/SASDATA/folder||&syear';

Thank you,

Bonnary

[Astounding · Accepted solution]

It shouldn't be a problem, but you will need to switch the double quotes and single quotes.  For example:

LIBNAME "/SASLIBRARY/SASDATA/folder%sysfunc(year('&sysdate'd))";

If it doesn't work as is, there should be an easy fix.  Give it a shot and see what you get.

[BonnaryW]

Thank you, it's worked wonderfully.