topic Re: How to replace M/B column values(character) to 0/1(numeric) in SAS? in New SAS User

How to replace M/B column values(character) to 0/1(numeric) in SAS?

VishnuSoman — Tue, 13 Apr 2021 09:30:26 GMT

I am analyzing the Breast Cancer Wisconsin (Diagnostic) Data Set, in order to run the logistic regression I have to replace the value of the Diagnosis variable M&B with 0&1.

I have tried the below code and some has error occurred:

proc format;
invalue infmt 'B' = 1
              'M' = 0;
run;

data BreastCancer_1;
   set Learn.Oirginal (rename = (cancer_diagnosis=diagnosis));
   cancer_diagnosis = input(diagnosis,infmt.);
   drop diagnosis;  
run;

Error:

 78         data BreastCancer_1;
 79            set Learn.Oirginal (rename = (cancer_diagnosis=diagnosis));
 ERROR: Variable cancer_diagnosis is not on file LEARN.OIRGINAL.
 ERROR: Invalid DROP, KEEP, or RENAME option on file LEARN.OIRGINAL.
 80            cancer_diagnosis = input(diagnosis,infmt.);
 81            drop diagnosis;
 82         run;

Old Dataset - Learn.Oirginal

New Dataset - BreastCancer_1

Old Variable - diagnosis

New Variable - cancer_diagnosis

Re: How to replace M/B column values(character) to 0/1(numeric) in SAS?

KachiM — Tue, 13 Apr 2021 09:48:53 GMT

Rename = (old1=new1)

In your case, do not use RENAME.

Simply use:

set Learn.Oirginal;

Re: How to replace M/B column values(character) to 0/1(numeric) in SAS?

japelin — Tue, 13 Apr 2021 09:53:16 GMT

try this code.

data BreastCancer_1;
   set Learn.Oirginal;
   cancer_diagnosis = input(diagnosis,infmt.);
   drop diagnosis;  
run;

Re: How to replace M/B column values(character) to 0/1(numeric) in SAS?

VishnuSoman — Tue, 13 Apr 2021 11:25:16 GMT

Thank you so much, the code has worked.