Numeric data imported from excel appears as Char

[desireatem]

I imported an excel data but all the numeric variables appears as character.

How do I change all the variables to numeric. They are more than 200.

[pink_poodle]

Please provide more information. What is the code? What is the structure of the data that you are importing? Which variables are character when they should be numeric?

[Reeza · Accepted solution]

You can't control that from SAS, at least not easily. If this is one time, check the Excel file and make sure that if you test with isnumber() the fields return TRUE.

Otherwise, convert to CSV and write a data step to read the data.