Desktop productivity for business analysts and programmers

Long names - from v9 to EG

Reply
New Contributor
Posts: 4

Long names - from v9 to EG

We have an existing database in SQL server, and we successfully created an ODBC connection to SAS v 9.

One of the tables have 2 long column names :
main_claim_process_unit_type_desc_en
main_claim_process_unit_type_desc_fr

SAS v9 concatenated these names and doing a PROC CONTENTS gave :
main_claim_process_unit_type_de0
main_claim_process_unit_type_des

When we converted to E.G., doing a PROC CONTENTS gave us the error :
ERROR: Variable main_claim_process_unit_type_de0 is not on file PRDDMWDW.vwdw_claim_dim.

Does anybody have the same experience ? Is this a bug in E.G. ?
New Contributor
Posts: 4

Re: Long names - from v9 to EG

i just found out that :

EG uses OPTIONS VALIDVARNAME=ANY; by default
SAS uses options validvarname=v7; by default
Ask a Question
Discussion stats
  • 1 reply
  • 91 views
  • 0 likes
  • 1 in conversation