BookmarkSubscribeRSS Feed
Rajnish
Calcite | Level 5
Hi,More than a reply, its a querry. I am new user of SAS Enterprises 4.3. I found that its is more convenient in importing .xlsx file as compared to SAS 9.1. However the problem is that when I try to use SAS data set created by SAS Enterprises 4.3 in SAS 9.1, some error is coming "The value Comapany name is not recognized". Does anyone can help in this. As I have lots of .xlsx file. I know I can always convert it in csv file and then import it in SAS 9.1.
Thanks in advance.
1 REPLY 1
ChrisHemedinger
Community Manager
Rajinish,

I think what's happening is that the output data contains one or more columns with a space in the column name: "Company name", for example.

In Enterprise Guide 4.2 and 4.3, check the box on the Import Data task that says "Rename columns to comply with traditional SAS naming conventions". That's the easiest fix.

You could also elect to retain the name with the space, and use OPTIONS VALIDVARNAME=ANY in SAS to read the data, but that is less convenient when you want to write programs that reference the data column.


Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 627 views
  • 0 likes
  • 2 in conversation