find function in macro statement and macro variables

[aaaaa34]

Hi,

I have some problems with my macro.

I created all my variables using SAS code (code below). In "schools" variable I want to find only these cases which contain at least one value from "place" variable. Then I want to add to these cases the right values of "opinion" and "country" variables. The results should look like:

[jarg]

you're not SETting anything in your last dataset - 

data &data_out;
set 
%let i_1 =1;

is this intended? i think you  just need to merge the two datasets together:

proc sort data=AAA; by SCHOOLS;
proc sort data=BBB; by place;

data &data_out;
merge BBB(rename=(place=SCHOOLS)) AAA; by place;

[aaaaa34]

Hi, It was intended. I don't know what's wrong with find function. And maybe this isn't good idea to put "opinion" and "country" variables in lists...

[Tom]

No need for any code generation. Just write the code.

data aaa;
  input  schools: $50.;
datalines;
harvard
only_harvard
cheese_cake_pizza
wse_is_for_you
;
data bbb;
  input  place: $10. opinion: 2. country: $10.;
datalines;
Harvard 8 usa
oxford 8 uk
wse 9 france
;

proc sql ;
create table want as
  select a.schools,b.opinion,b.country
  from aaa a inner join bbb b
    on find(a.schools,b.place,'it')
  order by 1,2,3
;
quit;

proc print data=want;
run;

Obs    schools           opinion    country

 1     harvard              8       usa
 2     only_harvard         8       usa
 3     wse_is_for_you       9       france

[aaaaa34]

Thanks @Tom but I don't know what's wrong with my macro... and for my big datasets (here I write only part of them) I prefer macro

[JackHamilton]

Before writing a macro that generates code, you should have an example of working code similar to what the macro should generate.

Your macro is generating 

    set find(schools,"&zm1") >0 

so SAS thinks that "find" is the name of a data set.  The parenthesis indicates that a data st option is to follow, but "schools" is not the name of a data set option.

What working code do you want to generate?

[aaaaa34]

Hi @JackHamilton, I'm new in SAS and I have to admit that I started my macro without any code... I don't know whether I think in proper way... maybe I shouldn't put "opinion" and "country" variables into lists but for example use join from SQL as Tom suggested

[aaaaa34]

@Tom what is "it" in find(a.schools,b.place,'it')?

[Tom]

Modifiers. Read the documentation.

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p00ab6ey29t2i8n1ihel88tqtga9.htm...