topic Re: Create a sas variable using select statement in SAS Programming

Create a sas variable using select statement

abuanuazu — Sun, 24 Jan 2016 00:07:11 GMT

Objective:

I was interested to create a new variable "treat" , to read the data, and provide information about cancer patient frequency of those taking chemotherapy or not.

data chemo1;
set adph;

select(Chemotherapy);
    when(0) treat="No chemo";
    when (1) treat="Yes Chemo";
   otherwise;
   end;

run;

proc freq data=chemo1;
table treat/chisq;run;

After I ran the above code, produce all the data as missing with the new variable "treat". I need your help.Thanks.

Re: Create a sas variable using select statement

Reeza — Sun, 24 Jan 2016 00:15:31 GMT

Without data we can't really comment. But you can change your proc freq to help diagnose the issue.

Post the results from the following code:

proc freq data=chemo1;
  table chemotherapy*treat/chisq missing list;
run;

Re: Create a sas variable using select statement

abuanuazu — Sun, 24 Jan 2016 01:47:16 GMT

Dear Reeza,

Thank you for prompt response. Still I need more assistance. As per your code, the result attached. It picks all the patients as "No chemo". Please find here is attached the sub-variables under Chemotherapy and the data type is boolean as 1 or 0.Thank you again.

Abuanuazu

Re: Create a sas variable using select statement

abuanuazu — Sun, 24 Jan 2016 02:22:05 GMT

Dear All,

Thank you for your help. Finally, I got the solution to the problem

Data chemo;

set adph;

select (Chemotherapy);
   when('"chemoth') chemo='Yes chemo';
   when('"recomme') chemo='Yes chemo';
   otherwise chemo='No chemo';
end;

Re: Create a sas variable using select statement

Reeza — Sun, 24 Jan 2016 05:28:49 GMT

Awesome. You can list multiple conditions in your WHEN statement.

Data chemo;
  set adph;
select (Chemotherapy);
   when('chemoth', 'recoome') chemo='Yes chemo';
   otherwise chemo='No chemo';
  end;
run;