Hello, Has anyone dealt with how to reference tables names larger than 32 characters on redshift through proc sql? Thanks. Susan BASE SAS V9 using ODBC connecting to Amazon redshift via proc sql and a libname statement. proc sql;
create table nutslp as
select blah
from prod.member m
inner join prod.member_activities_by_activitytype ma
on a.action_type = ma.activitytype
;
quit;
partial log below:
637 inner join prod.member_activities_by_activitytype ma
---------------------------------
65
ERROR 65-58: Name 'MEMBER_ACTIVITIES_BY_ACTIVITYTYPE' is too long for a SAS name in this context.
... View more