Create a sas variable using select statement

[abuanuazu]

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.

[Reeza]

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;

[abuanuazu]

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

[abuanuazu]

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;

[Reeza · Accepted solution]

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;