topic DATA step issue in SAS Programming

DATA step issue

kbwork — Tue, 27 Jan 2015 16:27:02 GMT

I am trying to create a field 'respondent_id' that contains either the s_id, m_id or c_id depending on what activity the user preformed. The data step below works but the issue I'm having is that some users did multiple acts and it is only storing one ID per user. I want the code to just create a new line if the user has more than one activity instead of overwriting the other.

data act.3;

set act.2;

by user_id;

retain user_id s_id m_id c_id Respondent_id;

if user_id and act_id in (28 29) then do;

respondent_id=c_id;

end;

if user_id and act_id in (27) then do;

respondent_id=m_id;

end;

if user_id and act_id in (25) then do;

respondent_id=s_id;

end;

run;

Re: DATA step issue

Kurt_Bremser — Tue, 27 Jan 2015 16:38:30 GMT

if user_id and ...

treats user_id as a boolean variable which is considered true if not 0.

How is act_id stored? The way you handle it, there cannot be more than one activity per record, so all activities will be output.

The log of the data step might be helpful.

Re: DATA step issue

PGStats — Tue, 27 Jan 2015 17:54:28 GMT

act.3 is not a valid dataset name. This datastep cannot run, contrary to what you are saying. With valid dataset names you might try :

data three;

set two;

if user_id > 0 then do;

select (act_id);

when (28, 29) respondent_id=c_id;

when (27) respondent_id=m_id;

when (25) respondent_id=s_id;

otherwise;

end;

run;

Re: DATA step issue

Reeza — Tue, 27 Jan 2015 18:27:06 GMT

Use an OUTPUT statement to control the output.

I don't know what you're expecting the user_id statement in the IF statement to accomplish. It will evaluate to true if the user_id is greater than 0.

Perhaps something like this:

data act.three;

set act.two;

by user_id;

if user_id and act_id in (28 29) then do;

respondent_id=c_id;

output;

end;

if user_id and act_id in (27) then do;

respondent_id=m_id;

output;

end;

if user_id and act_id in (25) then do;

respondent_id=s_id;

output;

end;

run;