Dear all, I am facing a strange issue here which I currently cannot resolve - please help. A piece of code I've written imports a CSV file into a temporary dataset, which works perfectly fine. After that, I want to convert some of the values I have imported into numeric data. I am using DI Studio, so I use a "SAS Extract" and the code that gets produced looks like this: proc sql;    create view work.W5O43ACY as       select          (input(fld1,11.)) as NR length = 8             format = 11.             informat = 11.             label = 'NR',          fld2 as ABLAUFDATUM,          fld3 as ENTITAET,          (input(fld4,11.)) as TEC_ID length = 8             format = 11.             informat = 11.             label = 'TEC_ID',     [...]          (input(fld34,11.)) as TEC_LCR_AK_GP_ID_ALT length = 8             format = 11.             informat = 11.             label = 'TEC_LCR_AK_GP_ID_ALT',          (input(fld35,11.)) as TEC_LCR_AK_GP_ID_NEU length = 8             format = 11.             informat = 11.             label = 'TEC_LCR_AK_GP_ID_NEU'    from &SYSLAST    ; quit; Now, everything from fld1 to fld34 gets transferred and (if required) converted - only fld35 does not and I have absolutely no clue why. FLD35 does not seem like a reserved syntax. I am using SAS 9.2 M3. Thanks, Thomas ... View more

Dear all, I am trying to find a quick way to check if a dataset (with all its columns and observations) is still looking the same as after a change to the code. Let's say a dataset with 1mio observations and 1 row contains just an "a" in each observation. Now I change something to my code (which in my case is some PRXPARSE action) and run the job again...I would expect that the result is the same. How do I check that efficiently? How do I e.g. build a hash over everything a dataset contains...or a checksum? Thanks a lot, Thomas ... View more