Hi Haikuo, I try to wrap up your code in the macro, please see %MACRO check_upcase; data _null_; set sashelp.vcolumn; WHERE memname EQ 'ADAE' AND libname EQ 'DERIVED'; %IF upcase(name)NE name %then %DO; %put %SYSFUNC( CATT( WARNING: Please check the dataset check_upcase Some variable its not UPCASE)); %END; %MEND check_upcase; %check_upcase; Unfortunately come this error message, could you help me please The SAS System NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR ERROR: Required operator not found in expression: upcase(name)NE name ERROR: The macro CHECK_UPCASE will stop executing. 39 ;*';*";*/;quit;run; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Hi Haikuo and Draycut Thank you for your response. My intention was the name of the variable. I have created some macro, could you please take a look. What do you think? %MACRO check_upcase; PROC SQL; CREATE TABLE check_01 AS SELECT * FROM sashelp.vcolumn WHERE memname EQ 'ADAE' AND libname EQ 'DERIVED'; QUIT; DATA notupcase; set check_01; IF upcase(name)NE name THEN OUTPUT notupcase; RUN; %IF obs. >0 %THEN %DO; %PUT %SYSFUNC( CATT(WARNING: Please check the dataset check_upcase. Some variable its not UPCASE. )) ; %END; %MEND check_upcase; %check_upcase; ... View more