@dleal90 wrote:
Yes, because I know that a certain column is supposed to be numeric, but using proc contents i see that it assigned character. To import I used proc import datafile=datafile dbms=csv replace; getnames=yes;
I am not sure what procedure to use so that I can specify numeric type. Im new to SAS,
thanks,
I would be more likely to suspect no actual data in the first rows then that the data type is creating missing values. If the column is treated as Character then numbers merely appear as text.
Look in your raw data file for sequential commas like: somevalue ,, another value.
The variable that should appear between the commas is missing. And proc import usually assgns those as $1 if there is not any value within the guessingrow range.
If that is the case however the solution is VERY easy. The proc import generated datastep code that should appear in the log.
Copy that code from the long into the editor (or code node or whatever) and change the informat for that variable from $1. to an appropriate numeric such as best12.
... View more