My proc tabulate
proc tabulate data=s_18 format=nlnum32. out=s_18_CF;
class original_currency yearno company_name company_bk company_type_code period_name typeno;
var epifp;
by Company_Name company_bk company_type_code period_name ;
table yearno='Year'*company_name='Company'*company_bk='nr'*company_type_code='Institutgroup'*original_currency='Curr'*period_name='Period'
all='Total', all='Total'*(epifp);
run; I get this notes in the log and I can't understand why. Has anyone an idea of why? Why does SAS create new names? NOTE: Variable Company_Name already exists on file WORK.S_18_CF, using Company_Name2 instead.
NOTE: Variable Company_BK already exists on file WORK.S_18_CF, using Company_BK2 instead.
NOTE: Variable Company_Type_Code already exists on file WORK.S_18_CF, using Company_Type_Code2 instead.
NOTE: Variable Period_Name already exists on file WORK.S_18_CF, using Period_Name2 instead.
NOTE: The above message was for the following BY group:
Company name=XXX Company_BK=NNNN Company type code=SSS Period name=2022
... View more