topic Re: find function in macro statement and macro variables in SAS Data Management

find function in macro statement and macro variables

aaaaa34 — Wed, 13 Nov 2019 22:42:20 GMT

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:

Re: find function in macro statement and macro variables

jarg — Mon, 11 Nov 2019 21:52:56 GMT

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;

Re: find function in macro statement and macro variables

Tom — Mon, 11 Nov 2019 22:03:43 GMT

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

Re: find function in macro statement and macro variables

aaaaa34 — Mon, 11 Nov 2019 22:09:27 GMT

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...

Re: find function in macro statement and macro variables

aaaaa34 — Mon, 11 Nov 2019 22:13:08 GMT

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

Re: find function in macro statement and macro variables

JackHamilton — Mon, 11 Nov 2019 22:22:21 GMT

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?

Re: find function in macro statement and macro variables

aaaaa34 — Mon, 11 Nov 2019 22:45:36 GMT

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

Re: find function in macro statement and macro variables

aaaaa34 — Mon, 11 Nov 2019 22:50:05 GMT

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

Re: find function in macro statement and macro variables

Tom — Mon, 11 Nov 2019 22:55:57 GMT

Modifiers. Read the documentation.

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p00ab6ey29t2i8n1ihel88tqtga9.htm&docsetVersion=9.4&locale=en