/*CREATING MACROS FOR NUMBER OF SHEETS EXISTED IN EXCEL FILE CONTAINS 2015 YEAR*//*MACRO N FOR NUMBER OF SHEETS THAT CONTAINS SHEET NAME 2015*/PROC SQL;SELECT COUNT(*) AS ROWS, MEMNAME INTO: N,HEET1-HEET&SYSMAXLONG FROM DICTIONARY.TABLESWHERE UPCASE(LIBNAME)="DATA" AND MEMNAME CONTAINS "2015";QUIT;

/*CREATING MACROS FOR NUMBER OF SHEETS EXISTED IN EXCEL FILE CONTAINS 2015 YEAR*//*MACRO N FOR NUMBER OF SHEETS THAT CONTAINS SHEET NAME 2015*/PROC SQL;SELECT COUNT(*) AS ROWS, MEMNAME INTO: N,HEET1-HEET&SYSMAXLONG FROM DICTIONARY.TABLESWHERE UPCASE(LIBNAME)="DATA" AND MEMNAME CONTAINS "2015";QUIT;