Macro - Different Data Types in Where Clause

PhillipSherlock — Tue, 07 Oct 2014 18:59:58 GMT

I am working with a transaction type data set where there are multiple observations for individual children nested within families. Each child has a unique" child_id" and an associated "familynumber." I would like to generate a count of the number of children in each family. I have attempted to use the following code, but I am receiving an error that informs me that there are different data types in the WHERE clause. Thank you for your help.

proc sql noprint;

select left(put(count(distinct(familynumber)),15.0)) into :fmcount work.time;

select distinct(familynumber) into :family1 - :family&fmcount from work.time;

quit;

%macro family_count;

%do i = 1 %to &fmcount;

proc sql noprint;

select count(distinct(child_id)) from work.time

where familynumber = "&&family&i";

quit;

%end;

%mend family_count;

%family_count;

Re: Macro - Different Data Types in Where Clause

SASKiwi — Tue, 07 Oct 2014 19:08:03 GMT

Is the familynumber column numeric? If so: where familynumber = &&family&i;

topic Re: Macro - Different Data Types in Where Clause in SAS Programming

Macro - Different Data Types in Where Clause

Re: Macro - Different Data Types in Where Clause