Thanks for the fast replies, all. This is helping me down the path towards a solution. Although we are pulling from the same source data with the same source code, it is being read in differently for each of us. See the differences in proc contents below. Our SAS installations should theoretically have the same options. Are these kinds of defaults set somewhere, and if so, what should I look for? Thanks! Here's the code -- this pulls the initial raw data that feeds into the code I posted earlier. libname spssql odbc dsn='xxx' schema='sas' user=xxxx password=xxx data hospitaldata; set spssql.v_rawhospitaldata; where questionid in (xxx,xxx,xxx); run; When I run proc contents on set spssql.v_rawhospitaldata on my side, I get: When I run it on her machine, I get: Note that there are many differences: e.g,. my first field (AnswerText) is longer than hers; my ReportDate is being read in with DATETIME26.7 while here is $27 and so on. But they are pulling from the same place with literally the same code. Which leads back to my question -- is there a place where the defualt format/input options are set in the config? Thanks!!
... View more
