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;
Is the familynumber column numeric? If so: where familynumber = &&family&i;
Is the familynumber column numeric? If so: where familynumber = &&family&i;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.