What is wrong with macro? %let dat=%str(hssu08.dat);

%macro dept; %if %upcase(%substr("&dat",1,2))="HS" %then %do; %let tit=%str(DEPARTMENT OF HEALTH SCIENCES); %end; %else %if %upcase(%substr("&dat",1,2))="HI" %then %do; %let tit=%str(DEPARTMENT OF HEALTH INFORMATION MANAGEMENT); %end; %mend; %dept;

I get this error: NOTE: One or more missing close parentheses have been supplied for the %UPCASE function. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %upcase(%substr("&dat",1,2))="HS" ERROR: The macro DEPT will stop executing.

Dr. Jamil Ibrahim, Ph.D. Scientist IV Professor , SHRP Research Supervisor Univ. Of Miss. Med. CTR. 2500 N state St Jackson, MS 39216 Tel. 601-984-1197 Fax 601-984-1205 Nternet: jibrahim@acadaff.umsmed.edu The information contained in the attachment(s) to this email is confidential. If you were not expecting a confidential email from the Department of Institutional Research at the University of Mississippi Medical Center, please do not view, open, disclose, reproduce, distibute or otherwise use this attachment. If you received this email in error, please notify me immediately. Thank you.

Individuals who have received this information in error or are not authorized to receive it must promptly return or dispose of the information and notify the sender. Those individuals are hereby notified that they are strictly prohibited from reviewing, forwarding, printing, copying, distributing or using this information in any way.