Remove the macro bits:
data step9.Patstat_total_hrm_Step34;
set step9.Patstat_total_hrm_Step34;
&COMPANY_NAME._S34=&COMPANY_NAME._S33;
&COMPANY_NAME._S34=cat(' ',strip(&COMPANY_NAME._S34),' ');
/* GENERAL MULTILANGUAGE STANDARDIZATION (BY BHH)*/
if find(&COMPANY_NAME._S34,' A B ')>0 then do;
&Company_name._S34= tranwrd(&Company_name._S34,' A B ',' AB ');FlagSingle=1;end;
&Company_name._S34= tranwrd(&Company_name._S34,' A CALIFORNIA CORP ',' CORP ');
&Company_name._S34= tranwrd(&Company_name._S34,' A DELAWARE CORP ',' CORP ');
&Company_name._S34= tranwrd(&Company_name._S34,' AKTIEBOLAGET ',' AB ');
..
&Company_name._S34= tranwrd(&Company_name._S34, ' CURATORS ',' ');FlagCLEAN_UNI_NAME=1;end; /* GM */
if find(&Company_name._S34,' THE ' )>0 then do;
&Company_name._S34= tranwrd(&Company_name._S34, ' THE ',' ');FlagCLEAN_UNI_NAME=1; FlagTHE=1;end;
&Company_name._S34= tranwrd(&Company_name._S34, ' ',' ');
&Company_name._S34= tranwrd(&Company_name._S34, ' ',' ');
&Company_name._S34=strip(&Company_name._S34);
c&Company_name._33v34=(&Company_name._S34 ne &Company_name._S33);
run;
Do a search and replace of "&Company_name" with one of your representative values, such as "HRM_L2".
Resubmit - you'll get better line and column numbers in the log indicating the problem statements.
More than likely your problem variables are not contained in your source dataset and are defaulting to numeric values. If that is the case, declare them as character via length or attrib statements. Use the PUT() and INPUT() functions to explicitly convert character to numeric and vice versa.
Fully debug your SAS code, then convert to macro.
Along those lines:
1) You declare no= as a macro parameter but never reference it in your code.
2) Minor: I assume the macro name CompnayNameM is misspelled.
Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.
Click image to register for webinar
