Hi, I have a very large file showing subhourly generation by various customers. This file is stored as a csv file. The fields are: ID, dtid, engo, engo_f. ID is the customer id, dtid is a date/time of measurement, engo is generation amount, engo_f is a flag variable. This is how the fields are suppose to be ordered per the documentation I was given from our consultant (please note this contract ended some time ago). This is the program i used to read this file with a data step: data Engo ; attrib dtid format = datetime16. ; infile '--blankedout---.csv' dlm = ',' dsd obs = 1000000 firstobs = 2 missover ; input Id $ Dtid datetime16. Engo Engof $ ; run ; After submitting this program, I seem to be getting correct values for ID, Dtid, and engo_f. I keep getting missing values for the field "engo". When I try to read the same file with proc import, I get much better results. options obs = 1000000 ; proc import datafile = '--blankedout---.csv' out = Engo replace dbms = csv ; guessingrows = 125 ; run ; Except for one strange thing: the column order under proc import becomes (well this is how the output file looks): ID, Dtid, engo_f, engo. My question: 1.) did our consultant make a mistake in their documentation and 2.) if the correct order of the fields are as givne in the output of the second program, then why did the field "engo_f" get picked up correctly in the first program? Are there some options that I am missing and that I should use in the first program?
... View more