topic Re: Dealing with 32 characters on SAS Viya in SAS Programming

Dealing with 32 characters on SAS Viya

claudiodejesusa — Tue, 30 Aug 2022 00:59:16 GMT

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

Re: Dealing with 32 characters on SAS Viya

SASKiwi — Tue, 30 Aug 2022 02:56:25 GMT

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.

Re: Dealing with 32 characters on SAS Viya

LinusH — Tue, 30 Aug 2022 09:53:19 GMT

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....).