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

[Myurathan]

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

[RW9 · Accepted solution]

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.

[Myurathan]

Thank you so much 🙂