topic Re: Case Statement or something else? in SAS Programming

Case Statement or something else?

IgawaKei29 — Tue, 07 Aug 2018 11:06:48 GMT

So I have a file that has the following data:

User,

Session

What I want to happen is I want to list a user and then for each of the three sessions have a "Y" or "N" if they attended. So something like this:

User	Session 1	Session 2	Session 3
Harry Crumb	Y	N	Y

I have tried this code, however I am getting three separate lines generated. So I am trying to figure out how to put everything on the 1 line.

CASE
when Session in ('Session_1') then ('Y)
else ('N')
end as Session_1,

CASE
when Session in ('Wave_2') then ('Y')
else ('N')
end as WAVE_2,

CASE
when Session in ('Session_3') then ('Y')
else ('N')
end as Session_3

I was trying to search for the answer, but I am not sure what this type of syntax is called.

Re: Case Statement or something else?

Kurt_Bremser — Tue, 07 Aug 2018 11:14:37 GMT

In a first data step, add a variable x that contains just a 'Y'.

Then transpose with

by user;

id session;

var x;

In a final data step, replace all missing character variables with 'N'.

This method is data-driven , no explicit coding for values is needed.

Note that for this to work, session must contain valid SAS names.

Re: Case Statement or something else?

IgawaKei29 — Tue, 07 Aug 2018 11:45:40 GMT

Thank you that was a big help. I have only used PROC Transpose a few times, so I didn't think of using it here. I will be using this again I'm sure!