Intergrate proc format into regression

[KRHE]

Hi,

I am having issues with doing a regression since my dep var is string. I've recoded the variable but it won't intergrate into my regression.

Everything is successful but I think that my format and my data do not connect. Perhaps since they are on different paths?

libname x xlsx 'C:\Users\BF3513\Desktop\DATA\info1.xls';
run;

proc contents data=info1;
run;

proc format library=WORK;

proc format;
value $stat
'REJECTED' = "1"
'APPROVED' = "0"
other = .;
run;

proc print data=info1;
format status $stat.;
run;

options fmtsearch=(WORK);

proc format library=WORK fmtlib;
run;

proc freq data=info1;
format status $Status.;
tables status;

[ChrisNZ · Accepted solution]

---

@KRHE wrote:

Hi,

I am having issues with doing a regression since my dep var is string. I've recoded the variable but it won't intergrate into my regression.

Everything is successful but I think that my format and my data do not connect. Perhaps since they are on different paths?

libname x xlsx 'C:\Users\BF3513\Desktop\DATA\info1.xls';
run;

proc contents data=info1;
run;

proc format library=WORK;

proc format;
value $stat
'REJECTED' = "1"
'APPROVED' = "0"
other = .;
run;

proc print data=info1;
format status $stat.;
run;

options fmtsearch=(WORK);

proc format library=WORK fmtlib;
run;

proc freq data=info1;
format status $Status.;
tables status;

---

1. I don't see a regression here

2. You create format $stat and use format $status . 

[KRHE]

God bless you @ChrisNZ