Dealing with 32 characters on SAS Viya

[claudiodejesusa]

Hi everybody,

In my company, we have production database with hive and impala, the fields have size bigger than 32 characters.

I know that SAS has a name convention about DBMS, but how your company or SAS experts suggest to deal with this problem?

I want suggestions in order to board with data engineer team.

Thanks,
Claudio

[SASKiwi]

This issue goes back a long way. Check this post out: Solved: Dealing with 32 character restrictions - SAS Support Communities

BTW: SAS 9.5 as mentioned in the post was going to fix this, however 9.5 is no longer planned with all major software development switching to Viya.

The main workaround is to use SQL Passthru (see post). This is also available in Viya. I'm not sure if there are other Viya ways of dealing with this. I'm interested if there are as we will be moving to Viya in the near future.

[LinusH]

CAS has pretty much the same naming conventions as SAS 9.4.

Ironically, CASLIB's can be up to 256 chars long (but the recommendation is to stick to max 8 to mach the libref in the LIBANAME statment....).