I haven't used arrays recently but I would've sworn that data in them didn't retain.  But then I wrote some code using arrays and was getting unexpected answers and I finally figured out it was because the data was being retained when it went to the next observation.  It took me awhile to figure it out because I didn't even consider that a possibility because I was so sure that that wasn't how arrays work in SAS.   So the question is, is there a simple way to tell SAS to not retain data when I'm using arrays?  Any info is appreciated. ... View more

Know how you see the programs you've used recently on the bottom of the Edit menu so you can easily get them?  When I close SAS then open it later, those go away.   Also, I change the icons across the top to customize it for myself.  Specifically, I put the little running man to the far left and then put a few separators on either side of it so when I click it to run code I don't accidently hit to the left or right of it and run something I shouldn't.  But that too reverts to default when I close SAS then re-open it.   Also, in the little white rectangular box where I type in "Program" to get to the program window or "Nums" to get numbers in the program window....that too goes away when I close and then re-open SAS, so I can't just select it each time and instead have to type it in.   You get the idea.  These things are supposed to stay how I set them but instead they go away.    In case it helps, here is some info.  I recently changed from 64-bit SAS to 32-bit SAS, although I don't see why it shouldn't work in 32-bit SAS.  (The reason for the shift is I was connecting to a database here on campus, and then I got a new work computer because my old work computer was old, and then the new work computer would not connect to the database and after much investigation the IT people here said the solution was to change to 32-bit SAS, so I did that at their behest.)   Any info is appreciated. ... View more

Here is the code:   proc import datatable = 'FIELDRULES' out = work.FIELDRULES DBMS = ACCESS REPLACE; database = "J:\path\accessfilename.accdb"; run;   Here is the error.  I have seen this one so many times over the years and it is always a giant pain in the rump.   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connection Failed. See log for details.   I'm using 64-bit SAS as well as 64-bit Microsoft Office.  I think I have PC Files too.  Any help is appreciated.  This stuff drives me crazy. ... View more