topic Re: proc import behave different in SAS Base and SAS Enterprise Guide in SAS Procedures

proc import behave different in SAS Base and SAS Enterprise Guide

jjjch — Thu, 01 Jun 2017 21:47:37 GMT

At least the columns names created by "proc import" are different depending on the codes are running in SAS Base or SAS Enterprise Guide.

As a result of column name differences, the codes created in SAS Enterprise Guide cannot run sucessfully in SAS Base.

How to make SAS Enterprise Guide to generate the same codes as SAS Base for "proc import"?

Thank you!

Re: proc import behave different in SAS Base and SAS Enterprise Guide

Reeza — Thu, 01 Jun 2017 22:08:22 GMT

Depends what you mean. It's possible you could be running two different versions of SAS, but most likely you need to set the following option:

option validvarname=v7;

EG is set to ANY by default, which allows more variation in naming, but I find it just confuses things.

Try this and see if that helps. If not, post back with more details and an example of how they're different.

Re: proc import behave different in SAS Base and SAS Enterprise Guide

ballardw — Thu, 01 Jun 2017 22:10:02 GMT

For a similar issue please read through this thread: https://communities.sas.com/t5/Base-SAS-Programming/Importing-Excel-into-SAS/m-p/363447

I know that you did not say that your data is Excel. Excel and other spreadsheets are just one layer of the underlying issue:

Proc IMPORT Guesses and the guesses may change from file to file based on the content. Any process that relies heavily on Proc Import will eventually fail.