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: 19,870

Re: Create a sas variable using select statement

Posted in reply to abuanuazu

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: 19,870

Re: Create a sas variable using select statement

Posted in reply to abuanuazu

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

Posted in reply to 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;

 

 

Solution
‎01-24-2016 06:09 PM
Super User
Posts: 19,870

Re: Create a sas variable using select statement

Posted in reply to abuanuazu

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
  • 389 views
  • 2 likes
  • 2 in conversation