comp.soft-sys.sas - The SAS statistics package.
Dear All: I am importing a CSV file format into SAS. The values of one of the variables is "01-JUN-2006 16:00:00" and when I import the file, SAS gives an error and the import is unsuccessful. My presumption is that SAS does not "like" the space in the value of this variable. Are there any suggestions for me to allow importation, perhaps by separating the the values into two variables: date -- "01-JUN-2006" and time -- "16:00:00". Is there any code available for this procedure. Thanks
Hello All, I am attempting to import an excel csv data file into SAS and am encountering a strange problem. the first few variables are importing just fine, but after say the third variable, the variable names become var4,var5, var6 in the SAS data set. so for example the dataset in sas looks like: id lastname firstname age var5 var6 var7 etc.. even thought there are valid column headings for these variables (var5,var6,var7)..when i convert the file to excel, the file imports just fine. I am trying to automate the import of these files, so i hope to avoid having to convert the csv to excel. has anyone experienced this type of problem? here is the import statement i am using. proc import out= work.form&i datafile= "e:\forms\&dsn" dbms=csv replace; getnames=yes; datarow=2; guessingrows=20; run; Thank you for all your help, nevin