topic Re: Load Current SAS Program Name to macro variable in SAS Programming

Load Current SAS Program Name to macro variable

vandhan — Tue, 28 Aug 2018 07:18:51 GMT

Hello,

I am working on some comparing datasets and wanted to make sure compare program using the correct datasets.

EX: my program name is A. I want to compare A dataset with AA. But issue arised here is programmer compared B with BB and compare report showing all matched in program A.

I wanted to make sure in A program they compared only A dataset with AA.

so I wanted mitigation plan here and load program (A) name into pgm macro variable in A program. and call pgm macro variable as input dataset in compare setp.

Please help.

Re: Load Current SAS Program Name to macro variable

Kurt_Bremser — Tue, 28 Aug 2018 08:16:13 GMT

It depends on the way you run your program.

In batch mode, there is a macro variable SYSPROCESSNAME that you can use.

From EG, you can see the current node name from within the project tree as _CLIENTTASKLABEL.

Re: Load Current SAS Program Name to macro variable

RW9 — Tue, 28 Aug 2018 08:17:13 GMT

What software are you using, e.g. Base, Enterprise Guide etc. How do you call the proc compare? Surely you would have a paramter from that you can use?

%comp (inds=abc,compds=abcd);
  title "Dataset=&inds.  Comp=&Comp.";
...

Need some information to proceed.

Re: Load Current SAS Program Name to macro variable

vandhan — Tue, 28 Aug 2018 08:20:00 GMT

I am using EG only. i wanted to load A value to inds macro variable in this case.

Re: Load Current SAS Program Name to macro variable

RW9 — Tue, 28 Aug 2018 08:22:33 GMT

Please present an example of what you mean, show some code, show what you want to see.

Re: Load Current SAS Program Name to macro variable

vandhan — Tue, 28 Aug 2018 08:24:18 GMT

I have program name ABC. I want to create a macro variable name PGM and it should have a value ABC. Do we have any system option or automatic macro variable for that?

Re: Load Current SAS Program Name to macro variable

RW9 — Tue, 28 Aug 2018 08:26:54 GMT

Well in Base there is:

http://support.sas.com/kb/24/301.html

Don't know if that works in EG. Why should the filename drive parameter though? Would it not be better to generalise the compare and use paramters.

Re: Load Current SAS Program Name to macro variable

Kurt_Bremser — Tue, 28 Aug 2018 08:43:21 GMT

@vandhan wrote:
I have program name ABC. I want to create a macro variable name PGM and it should have a value ABC. Do we have any system option or automatic macro variable for that?

Look at the log as returned to EG. You'll find the variables created by EG right at the top:

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='mytest';
4          %LET _CLIENTPROJECTPATH='';
5          %LET _CLIENTPROJECTNAME='';
6          %LET _SASPROGRAMFILE=;

With EG after 7.13 (or 7.13 with a hotfix applied), _SASPROGRAMFILE will also be populated.