topic Re: SAS 9.4: NOTE: Unreferenced label defined : run in SAS Programming

SAS 9.4: NOTE: Unreferenced label defined : run.

inquistive — Thu, 07 Apr 2022 14:01:07 GMT

Hi Experts,

I have a macro like this:

%macro DETAIL(dataset, sheet);
proc export data = &dataset
outfile = "mydata..xlsx"
dbms = xlsx replace;
sheet = &sheet;
run;
%mend DETAIL;

% DETAIL(dataset_a, 'Dataset A');

When I execute the macro: % DETAIL(dataset_a, 'Dataset A');

SAS 9.4 prints -'NOTE : Unreferenced label defined : run.' and keeps running forever until I break it .The strangest part is it does not throw any error or warning messages at all.

Thanks in advance for sharing your expertise and opinion.

Re: SAS 9.4: NOTE: Unreferenced label defined : run

ballardw — Wed, 06 Apr 2022 14:32:11 GMT

SHOW the CODE from the log where you compile the macro. Copy the text with all the messages, on the forum open a text box using the </> icon and paste the text.

SAS uses a COLON, the : , following a word as a statement label. One strongly suspects that the code you submitted, not entered in the message window here, has a

Run :

%mend

not Run;

Re: SAS 9.4: NOTE: Unreferenced label defined : run

Sajid01 — Wed, 06 Apr 2022 14:32:45 GMT

I ran your code and it worked successfully. I don't see any error.
Please remove the space between % and Detail while invoking the macro.

Re: SAS 9.4: NOTE: Unreferenced label defined : run

inquistive — Wed, 06 Apr 2022 20:55:08 GMT

Thank you for suggestion. I have posted the code now.

Re: SAS 9.4: NOTE: Unreferenced label defined : run

Sajid01 — Thu, 07 Apr 2022 01:35:12 GMT

Hello

In your newly posted code I see t

2068          proc export data = &DS

I think it should be

proc export data =&dataset.

Re: SAS 9.4: NOTE: Unreferenced label defined : run

SASKiwi — Thu, 07 Apr 2022 01:41:28 GMT

From your SAS log:

2095          %excel_pause(5):

I think this should be a semicolon (;) not a colon (:).

Re: SAS 9.4: NOTE: Unreferenced label defined : run.

Kurt_Bremser — Thu, 07 Apr 2022 04:06:33 GMT

Log line 2091 shows a RUN followed by a colon instead of a semicolon. This is what causes run to be interpreted as a GO TO label.

2091          run:

Re: SAS 9.4: NOTE: Unreferenced label defined : run

inquistive — Thu, 07 Apr 2022 11:57:37 GMT

Thanks for pointing out. I had immediately rectified that but made difference.