topic Re: "NOTE 49-169: The meaning of an identifier after a quoted string....." error in SAS Programming

"NOTE 49-169: The meaning of an identifier after a quoted string....." error

Myurathan — Mon, 23 Jul 2018 09:42:34 GMT

Hello Experts,

I have following code;

%Macro Relcontclien_Module();
	Proc sql;
		Create table IFRS.RELCONTCLIEN_&Period._Nordic as
		select Distinct
		 "&date."d format YYMMDDn8. as FECREPOR, /*Format conversion needed */
		 Country_ISO_01 format $5. as CORUNIT, /*Clarification need on how to report unit*/
		 Contract_Key as CODCONTR,
		 CustomerID as CODIDPER,
		 '1' as CODINTER
		 from IFRS.Module_Cal_&Period._Nordic	
		 order by Contract_Key;
	quit;

%Mend;

When I run it, it displays the following error in the log;

NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
             between a quoted string and the succeeding identifier is recommended.

But the Log summary has not got any error marks. I have already seen other posts on the same question. I could not figure out still how to fix it.

Thanks in advance

Re: "NOTE 49-169: The meaning of an identifier after a quoted string....." error

RW9 — Mon, 23 Jul 2018 09:50:36 GMT

I have nothing to run this on so just guessing. The warning refers to scenarios using named literals. This is a system whereby a letter is suffixed to a string to indicate type, e.g. "21jul2018"d - this indicates the string is a date. As these suffixes could change it is warning you that a generated part of your code has created this and you should be careful.

I suspect it is this line:

"&date."d

Which you can change to:

input("&date.",date9.) as recrepor format yymmddn8.,

Please do avoid coding in mixed case, it makes code very hard to read.

Re: "NOTE 49-169: The meaning of an identifier after a quoted string....." error

Myurathan — Mon, 23 Jul 2018 11:24:00 GMT

Thank you so much 🙂