BookmarkSubscribeRSS Feed
PRP
Calcite | Level 5 PRP
Calcite | Level 5
Hi:
I'm starting of with a simple program to read in data and calculate the mean. I have two columns of data (numbers), but SAS says that column 1 is text and column 2 is numerical. Column 1 does have a negative number in there, and I'm wondering if the '-' is letting SAS think that it's a text and not numeric. How can I change the format?
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Share your SAS code.

Scott Barry
SBBWorks, Inc.
abdullala
Calcite | Level 5
it must be that your column 1 was defined as char, not likely only because of the negative sign. use a new variable to transform it to numeric:
column3=input(column1, best.)
Doc_Duke
Rhodochrosite | Level 12
There are lots of reasons you could get that error. For instance, it will occur if there is a space between the "-" and the digits when you are using free format input or the import wizard. As Scott said, share your code and log.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 770 views
  • 0 likes
  • 4 in conversation