EG 5.1 Importing

Reply
Contributor LRN
Contributor
Posts: 57

EG 5.1 Importing


Hi,

I am trying to import excel files using sas eg 5.1v. The column names are not getting imported as in using pc sas. For ex. in pc sas the column name "policy #' will be changed to 'policy__' / 'policy number' will be changed to 'policy_number' automatically. How can I get that in sas EG?

Thanks

Contributor oht
Contributor
Posts: 25

Re: EG 5.1 Importing

Hi

I encountered a similar problem, I imported an excel file into EG and exported out to SAS in a folder, the transition is fairly smooth. However, when I tried to open to viewtable to view the converted dataset in PC/SAS. It prompted and error saying that those variable(like 'Sequence Number') is a invalid SAS variable because he EG did not replace the space with an '_'.

Thanks

Super User
Posts: 3,108

Re: EG 5.1 Importing

Suggest you try the SAS option validvarname = V7 in EG to get it to translate your column names:

options validvarname = V7;

Ask a Question
Discussion stats
  • 2 replies
  • 200 views
  • 1 like
  • 3 in conversation