@Dataminer wrote:
Hi all
I have a problem with SAS Guide - it reads data formats incorrectly - numeric data (values from 0 to 9) format is character/string.
Can you suggest any code expression which converts variable format with values from 0 to 9 to numeric in the whole table?
Many thanks
Do you mean Enterprise Guide? That is a tool for running SAS code.
SAS has two variable types, floating point numbers and fixed length character strings. The format attached to a variable is just instructions for how to display to values as text.
If you are reading an existing SAS dataset then it will NOT change the type of the variable (or the format attached to it either).
Did you convert some other file type into a SAS dateset? If so what type of file? If you asked EG to import a text file it will guess how to define each variable based on what it sees in that field of the text file. If you asked EG to import a spreadsheet then any character value in any cell in the column will force SAS to treat that variable as text.
... View more