topic Re: Renaming datasets during code execution only in SAS Programming

Renaming datasets during code execution only

maryami — Thu, 02 Sep 2021 21:06:56 GMT

Hello, I am running a code that access a series of datasets in read-only mode to be used later in several computations.

The datasets are named like ABC_yyyymm:

ABC_201501

ABC_201502

ABC_201601

ABC_201602

ABC_201701

ABC_201702

However some sets have their original name as EFY_yyyymm, e.g. EFG_201801, EFG_201802

How can I temporarily assign the names ABC_201801 to EFG_201801, and ABC_2018_02 to EFG_201802 so that the files data can be used during the code execution?.

-I am using SAS v7.13 HF5

Thanks in advance.

Re: Renaming datasets during code execution only

ballardw — Thu, 02 Sep 2021 21:33:02 GMT

I think the safest would be to create views of those data sets, unless you are looking for an "automagic" process to guess which files need the exception to handling.

data abc_201801/ view=abc_201801;
   set EFG_201801;
run;

As an example. When you use the set Abc_201801 it pulls the data from the EFG named set.

Performance issue is that every use of the Abc version will read EFG version.

The view is just the instructions to get the data. If the EFG file is deleted or renamed the view won't work.

Re: Renaming datasets during code execution only

Tom — Fri, 03 Sep 2021 03:32:42 GMT

How complex is the code?
Why not modify the code to store the prefix of the dataset name in a macro variable. Then you just need to change the macro variable.

%let prefix=ABC;
*** Rest of code ***;
data x;
 set &prefix._201501;
...

PS There is no way you are running SAS 7.13. There was not SAS 7.13 there was barely ever a SAS 7 as the real usable version of SAS went straight from 6.12 to 8.1. You have probably posted the version of Enterprise Guide or some other tool you are using to help you send code to SAS to run. To see what version of SAS you are running check the top of the FULL SAS log. Or check the automatic macro variable SYSVLONG.

Re: Renaming datasets during code execution only

Sajid01 — Fri, 03 Sep 2021 12:25:19 GMT

Perhaps @maryami meant SAS EG 7.13 with Hot fix HF5

Re: Renaming datasets during code execution only

maryami — Fri, 03 Sep 2021 13:26:21 GMT

Indeed I was referring to EG, i.e. SAS EG 7.13 HF5, thanks