topic Re: Filtering variables from a redcap dataset in New SAS User

Filtering variables from a redcap dataset

gloriarhyne — Wed, 06 Oct 2021 21:46:19 GMT

Hi,

I am working in a previously made SAS code that integrates redcap datasets.

I am trying to filter out a certain answer (essentially trying to filter out variables of people who had completed the full timeline of a study vs all others who did not for various reasons for a report) to make it easier when it auto regerates into an Excel spreadsheet for a report.

I've tried doing some simple WHERE commands, some IF commands, etc. (like "WHERE endstatus=0 endreason=0"; run; and changing it to "WHERE endstatus=1,2,3,4 endreason=1,2,3,4"; run;) but it keeps bringing up the variables of "0" which is the complete variable.

Any ideas? Thanks in advance.

Re: Filtering variables from a redcap dataset

Reeza — Wed, 06 Oct 2021 21:59:30 GMT

Your syntax is incorrect - the log should be telling you that as well?
Something like this may work instead:

WHERE endstatus in (1,2,3,4) and endreason in (1,2,3,4);

Re: Filtering variables from a redcap dataset

AMSAS — Thu, 07 Oct 2021 17:30:41 GMT

Go read the WHERE statement documentation, there are several examples that will help explain the syntax