I need to import an excel file. My excel file contains column which has numeric as well as character values. Alhough I have mentioned "MIXED=YES", the column is read as numeric so my character values became period(.). I know that sas will read first some rows and decide the type of variable.
Is there any proc import statement which tells sas to scan all the values and then decide variable type???
The way you change it is by changing the "typeguessrows" parameter in the registry. How you do it is SAS version dependent. Search support.sas.com for it and your SAS version.
Message was edited by: Doc@Duke