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.
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;
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;
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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.