topic Re: Intergrate proc format into regression in SAS Programming

Intergrate proc format into regression

KRHE — Thu, 19 Aug 2021 07:42:03 GMT

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;

Re: Intergrate proc format into regression

ChrisNZ — Thu, 19 Aug 2021 07:55:29 GMT

@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 .

Re: Intergrate proc format into regression

KRHE — Thu, 19 Aug 2021 08:10:11 GMT

God bless you @ChrisNZ