topic Macro not getting resolved in SAS Programming

Macro not getting resolved

sahoositaram555 — Sun, 05 Apr 2020 22:15:31 GMT

Hi experts,

I have libname statements for folder1...folder10. Each folder have some .sas7bdat files.

I need to pick some .sas7bdat files of my interest from the folder of my choice and merge them later. So, for the below written macro statements i need help to figure out why the macro is not getting resolved.

%let file_a=randomisation;

%let file_b=Screening;

data rand;
merge folder5.&file_a.(in=a) folder6.&file_b.(in=b);
by PatientInitials;if a=1;
run;

ERROR: User does not have appropriate authorization level for file FOLDER5.RANDOMISATION.DATA.

ERROR: User does not have appropriate authorization level for file FOLDER6.SCREENING.DATA.

but it works,when i do below:

data a;set folder5.randomisation;run;

data b;set folder6.screening;run;

then, data rand;merge a b;by var;run;

Can anybody explain why merge statement doesn't directly resolves folder5.&file_a. and folder6.&file_b?

Re: Macro not getting resolved

Tom — Sun, 05 Apr 2020 22:22:52 GMT

Show the lines from the LOG. Make sure to use the Insert Code button (looks like < / > ) so you get a pop-up window to paste the lines so the formatting is preserved.

The error message makes it sound like you let the semi-colon off the end of your data statement so that it thought you wanted to create those datasets instead of read from those datasets.

Code like this

data rand merge folder5.&file_a. folder6.&file_b. ;

is instructions to create four datasets: rand, merge and the other two.

Re: Macro not getting resolved

ChrisNZ — Sun, 05 Apr 2020 22:59:39 GMT

You are not showing the problem.

The macro variables get resolved as indicated by the error messages.

Show us the codes and the logs.

The error points to an authorisation issue, so I suspect the libname folders are different, or the table creators are different, or something along these lines.