topic Re: How to change libname folder to current year in SAS Programming

How to change libname folder to current year

BonnaryW — Thu, 15 Dec 2016 18:54:59 GMT

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

Re: How to change libname folder to current year

Astounding — Thu, 15 Dec 2016 19:26:38 GMT

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.

Re: How to change libname folder to current year

BonnaryW — Thu, 15 Dec 2016 19:39:06 GMT

Thank you, it's worked wonderfully.