Hi everyone, I´m trying to import a database form a .csv, one of the variables contains the code of a route of public transportation, this code can be numeric or alphanumeric. When importing the database, SAS turns this variable into numeric and each alphanumeric observation is turned to missing value. I tried with proc import and i also tried importing with the option you find in file. I also tried proc import datafile="E:\Datos_Historicos\Plan_Itinerarios_Historico.csv" dbms=dlm out=plan_itinierarios_2017 replace; delimiter=','; getnames=no; DBDSOPTS= "DBTYPE=(var2='CHAR(20)' var7='CHAR(5)')"; run; But it seems DBDSOPTS doesn't work How can i correct this? THANK YOU!
... View more