Hi, I want to export 10 tables from SAS to an Access database. Names are similar, though not all (Color1, Color2, Color3, Colorall). Other than writing 10 PROC EXPORT statements, what is an efficient way to export them? Note, they do not represent all the tables in my SAS library, so I can't just export the entire library. My backup plan would be to move them into a separate library and export that en masse, but I'm hoping people can give me a macro/other solution so I don't have to do that. Thanks.
... View more