As @LinusH has stated, structure your data correctly. Access is (a rather poor sibling to anyway), a Relational Database. What this means is that data elements only appear once, these distinct lists as simple to merge back together but are not stored in one table. Attached is a picture which shows an example. You will see that the data is split out into separate tables, each with links to other tables. This is what "relational" means, once they are merged together by the variables then you get the full data.
There are many reasons for this setup. I would suggest you read up on what a Relation Database is, and how your data should look:
https://en.wikipedia.org/wiki/Relational_database
For example as a starter.
Then plan out your database schema -> much like the picture attached, draw each table, what distinct values it will contain, how they link together, then its just a matter of processing your one dataset in SAS to create each of the required datasets, which in turn can then be inserted into the respective table in Access. Note that SAS is not a Relational Database, so the structure is slighty different.
... View more
