Statistical programming, matrix languages, and more

Error, IML Symbol Name

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

Error, IML Symbol Name

Hi,

 

I'm simply trying to read an existing dataset into a matrix, but keep recieving the same error, that I can't fix.

 

The message is: ERROR: A dataset field name is not a valid IML symbol name.

 

Here's the code:

proc iml;
use points;
	read all var _ALL_ into runs;
	close points;
	print runs;

What's triggering the error?


Accepted Solutions
Solution
‎04-12-2017 08:20 AM
SAS Super FREQ
Posts: 3,234

Re: Error, IML Symbol Name

The USE statement in SAS/IML reads data from a SAS data set.  Valid variable names in SAS begins with a letter or an underscore.  In your data, try using variable names such as X0_0, X0_1, etc.  How did you create this data set? 

View solution in original post


All Replies
Super Contributor
Posts: 400

Re: Error, IML Symbol Name

Your code seems to be working fine as below, so my guess is that one of your column names are conflicting with SAS standards.

 

Can you post some sample of the data you are trying to read?

 

data points;
input ID point;
datalines;
1 100
2 200
3 300
;

proc iml;
use points;
	read all var _ALL_ into runs;
close points;

print runs;
quit;
Contributor
Posts: 38

Re: Error, IML Symbol Name

Here'sa a picture. I don't need the first column. Would it be because that coumn names are numeric?

 

events snip.JPG

Solution
‎04-12-2017 08:20 AM
SAS Super FREQ
Posts: 3,234

Re: Error, IML Symbol Name

The USE statement in SAS/IML reads data from a SAS data set.  Valid variable names in SAS begins with a letter or an underscore.  In your data, try using variable names such as X0_0, X0_1, etc.  How did you create this data set? 

Contributor
Posts: 38

Re: Error, IML Symbol Name

The dataset was imported from an excel worksheet. I renamed the columns so they begin with a letter, and it works. Thank you.

Post a Question
Discussion Stats
  • 4 replies
  • 133 views
  • 3 likes
  • 3 in conversation