change to double quotes like this   %macro import(industry); FILENAME REFFILE "/folders/myfolders/Bachelorarbeit/Daten/&industry..xlsx"; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=&industry. REPLACE; GETNAMES=YES; RUN; %mend import; %import (aerodef); %import (automobiles); /*etc.*/ run; ... View more

Cross-correlations are computed over multiple time periods (ie. lags) rather than over a single time point.  Also, one typically has a single dependent variable and multiple potential inputs, and a CCF analysis is performed to help you see how correlated other potential inputs are with that dependent variable.   I wonder if a similarity analysis might be more in line with what you need… ... View more

Use by group processing and the lag functions within a data step to determine firms to delete, then merge: data del (keep=firm); set sascomm.aerospacedefense; by firm; retain flag; plag1 = lag(price); plag2 = lag2(price); if first.firm then flag = 0; if lag(firm) = lag2(firm) = firm and plag1 = plag2 = price then flag = 1; if last.firm and flag then output; run; data want; merge sascomm.aerospacedefense del (in=d) ; by firm; if not d; run; ... View more