DATA Step, Macro, Functions and more

Create a sas variable using select statement

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Create a sas variable using select statement

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.

 


Accepted Solutions
Solution
‎01-24-2016 06:09 PM
Super User
Posts: 17,829

Re: Create a sas variable using select statement

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;

View solution in original post


All Replies
Super User
Posts: 17,829

Re: Create a sas variable using select statement

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;

 

Occasional Contributor
Posts: 13

Re: Create a sas variable using select statement

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

Occasional Contributor
Posts: 13

Re: Create a sas variable using select statement

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;

 

 

Solution
‎01-24-2016 06:09 PM
Super User
Posts: 17,829

Re: Create a sas variable using select statement

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;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 379 views
  • 2 likes
  • 2 in conversation