BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jojozheng
Quartz | Level 8

Hi everyone, 

 

I have a column of character like: 

flash

1.04

2.11

0.7

1

1.1

2.04

I want them to convert to numeric so I can use mean function.

flash 

1.04

2.11

0.70

1.00

1.10

2.04

I tried input(flash, best.), all value are missing... also tried input(flash,best4.2), it becomes

1.04

2.11

.

.

.

2.04

 

I cannot figure out how to do this...BTW, how can I create another numeric column with the same value? Can anyone provide some detail codes? Thank you so much!  

1 ACCEPTED SOLUTION

Accepted Solutions
Doc_Duke
Rhodochrosite | Level 12

JoJo,

 

This looks like you have some unprintable characters in the flash column.  Use a text editor that is capable of displaying the hex coding of the data to see if that is the case.  If you don't have one, you could also use SAS to print the text field with a HEX format.

View solution in original post

11 REPLIES 11
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

data have;
input mydata $;
cards;
1.04
2.11
0.7
1
1.1
2.04
;
data want;
 length mynum 8;
 set have;
 mynum = mydata;
 format mynum 8.2;
run;

VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

the length statement creates a new numeric variable

the format statement applies the 8.2 value to the number variable. 

 

ChrisNZ
Tourmaline | Level 20

@VDD

Your code generates the message

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).

 

While the informat best. is sometimes disappointing, it is best practice to use it (or another format, I usually use dollar32.) and to avoid such messages.

 

 

jojozheng
Quartz | Level 8
Thank you@VDD
I tried your method, but it failed.
ChrisNZ
Tourmaline | Level 20

This works.

data HAVE;
  input FLASH $;
cards;
1.04
2.11
0.7
1
1.1
2.04
run;


data WANT;
  set HAVE;
  F=input(FLASH,best.);
  drop FLASH;
  rename F=FLASH;
run;

I suspect your getting missing values means your data is not what you describe.

Capture.PNG

 

jojozheng
Quartz | Level 8
Thank you @ChrisNZ but is doesn't work well for my case
Ksharp
Super User

Maybe you have some blanks at beginning of FLASH.

F=input(STRIP(FLASH),best32.);
jojozheng
Quartz | Level 8

Thank you all! but answers you guys provided are not  work for my situation. Flash is a character with 32 length. I also tried

to convert it to num like flash1=flash*1, but only a part of dataset change to num type, others are missing. and I got note as below.

 

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).

75:13
NOTE: Invalid numeric data, FLASH='1.04.'
why this happen? I feel very confused. Which means this flash column is not the same type of variable at beginning, so that's why some of flash can change to num, while those situation like above can't change. Also, in my output I only see 1.04, why log note display 1.04.
 
Any thought will be grateful! Thank you so much for your help!
 
 
Doc_Duke
Rhodochrosite | Level 12

JoJo,

 

This looks like you have some unprintable characters in the flash column.  Use a text editor that is capable of displaying the hex coding of the data to see if that is the case.  If you don't have one, you could also use SAS to print the text field with a HEX format.

jojozheng
Quartz | Level 8

Thank you @Doc_Duke You remind me about unprintable data. So I search online and I found a article is really useful! I want to share with all of you~

https://www.lexjansen.com/pharmasug/2010/CC/CC13.pdf

 

And thank you all! I appreciate your help!

Tom
Super User Tom
Super User

So if your variable is character then you can use the INPUT() function to convert it to a number, But you need to store the number in a new variable, since your existing variable is character.

 

data have ;
  input flash $32. ;
cards;
1.04
2.11
0.7
1
1.1
2.04
;

data want ;
  set have ;
  flash_num = input(flash,32.);
  format flash_num 8.2 ;
run;

 

Do not use too short of width on your informat.  It might be that the values having leading spaces that you don't see when you look at the output.  Do not use a decimal part on an informat. That tells SAS to divide any text values that do not have an explicit decimal point by that power of ten.

 

If you are still having trouble with the INPUT() function not generating valid numbers then check what is really in your character variable.  You could print the values using the $HEX format can check if it contains invisible characters like Carriage Return (0D), Line Feed (0A), Tab (09), Non-Breaking Space (A0), Null (00).  If so then remove those.

  flash_num = input(compress(flash,,'kdp'),32.);

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

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
  • 11 replies
  • 2824 views
  • 0 likes
  • 6 in conversation