Suppose you import data on a monthly basis, and store them as
data_202201 data_202202 data_202203
and so on.
You can then create views like this:
data data_2022 / view=data_2022;
set
data_202201
data_202202
data_202203
/* ... */
;
run;
The names of the individual datasets can be created and stored in a macro variable in a SQL (SELECT INTO) or DATA (CALL SYMPUTX) step dynamically, as needed.
There are no support for partitions for SAS Base engine files.
From a performance perspective, I suggest that you try out SPDE engine, which phisically divide data sets into smaller filer, so multi-threaded reads could happen.
With an additional license (SPD Server) you can use logical partitions (so called clusters) which i similar to DBMS partitions.
That said, there is an ongoing transition towards Viya, where SPDE will still be accessible (only RO for backward compability).
So far, no SPD Server client have been released AFAIK for Viya.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.