How to create a table using proc sql based on meeting certain conditions for at least one wave

statsgal — Fri, 17 Mar 2023 20:24:46 GMT

I have a dataset from a longitudinal study where we collected data by waves. I want to create a new table. I want to keep participants (who are organized by id) who answered all questions (labeled a, b, c, and d) for at least one wave. This was my previous code:

proc sql;
	create table only as select * from full group by id having 
		not (a eq . and b eq . and c eq . and d eq .)
		order by id, wave;
quit;

However, with this code, I filter by keeping participants who answered any of these questions by at least one wave. . How can I go about fixing this?

Re: How to create a table using proc sql based on meeting certain conditions for at least one wave

PGStats — Fri, 17 Mar 2023 20:41:25 GMT

Try this:

proc sql;
	create table only as 
	select * from full 
	where id in (
		select id
		from full 
		where cmiss(a, b, c, d) = 0 )
	order by id, wave;
quit;

topic Re: How to create a table using proc sql based on meeting certain conditions for at least one wave in SAS Software for Learning Community

How to create a table using proc sql based on meeting certain conditions for at least one wave

Re: How to create a table using proc sql based on meeting certain conditions for at least one wave