topic Re: Help on sas investigation in SAS Programming

Help on sas investigation

sasuser86 — Thu, 11 Oct 2018 11:24:24 GMT

Hi
Please help on the below query for one of my investigation.

Data: student indicator1 indicator2
A 0 N
A 0 Y
A 1 N
A 1 Y
B 0 N
B 0 N
C 1 N
C 0 Y

I want to segregate the unique rows of students who have indicator 1 as
NOT 0 or indicator 2 as NOT N in my output. Please help to guide.

Re: Help on sas investigation

Amir — Thu, 11 Oct 2018 11:42:11 GMT

Hi,

This looks a bit like homework. What have you tried so far? Share any code you have tried and show the log with any error messages.

If you haven't tried anything yet then try looking at the if statement documentation, which includes examples:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202239.htm

then you can post back your findings.

What you have said could almost be put into SAS:

if indicator1 ne 0 or indicator2 ne 'N'

Edit: For the "unique" requirement, you could test for "first.variable" and "last.variable".

Regards,

Amir.

Re: Help on sas investigation

novinosrin — Thu, 11 Oct 2018 15:59:28 GMT

what do you mean by

who have indicator 1 as
NOT 0 or indicator 2 as NOT N in my output.

Can you post the output for your input sample plz