topic Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data" in SAS Programming

PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Jake3 — Thu, 25 Jul 2019 15:01:40 GMT

Hi there

This is my first post so apologies if I'm missing anything.

I'm doing a survival analysis and one of the tasks I wish to do is to estimate survival curves for males and females after controlling for age. My mean age is 39.93673111.

First I create a dataset of covariate values in the data step. Each row contains a set of covariate values for which I would like a survival plot.

data control;
input Sex$6. Age;
datalines;
Female 39.93673111 
Male  39.93673111 
;
run;

I thus get a dataset called “control” with 2 rows of covariates

Next, I utilize the following SAS Code to run my plot

proc phreg data = Survival plots(overlay)=(survival);
class Sex;
model Time*Event(0) = Sex Age;
baseline covariates=control out=base / rowid= Sex;
run;

However, I get the following error

"ERROR: Variable Sex in WORK.CONTROL does not have the same format as in the input data."

I checked and my format, Length, and variable type are the same between the "Control" dataset and my "Survival" dataset for Age and Sex.

Is there anything wrong with my code?

Thanks!

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Reeza — Thu, 25 Jul 2019 15:18:49 GMT

Can you show a proc freq output for sex on both data sets?

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Jake3 — Thu, 25 Jul 2019 15:26:41 GMT

Sure. Here is one for the "Control" dataset

and here is the one for the "Survival" dataset

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Reeza — Thu, 25 Jul 2019 15:30:52 GMT

Sorry, can you run that again with formats stripped? I'm assuming it's a character variable? You can use an 'empty' format statement as below to do this:

proc freq data=have;
table varName;
format _character_;
run;

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

ballardw — Thu, 25 Jul 2019 15:31:00 GMT

I suspect that if you check the properties of the variable in your Survival data set you will find Sex is a numeric variable. Possibly there is format associated with it to display text like Female or Male but the variable is numeric.

If you do not know how to check properties, one way:

Proc contents data=survival;

run;

The results window will show information about the data set and list of variables and the types.

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Jake3 — Thu, 25 Jul 2019 15:43:55 GMT

Hi Reeza

Really appreciate you taking the time to help me. I figured out what the issue was. When I do that I get the same results

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Jake3 — Thu, 25 Jul 2019 15:44:38 GMT

Thank you Ballardw! It was indeed a format issue

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Jake3 — Thu, 25 Jul 2019 15:46:43 GMT

Thank you to all who helped steer me in the right direction!

Here is my SAS code

data control;
format Sex$6. Age;
input Sex$6. Age;
datalines;
Female 39.93673111 
Male  39.93673111 
;
run;

It was the format command that I needed to incorporate!

Have a wonderful day everyone!

Best

Re: PROC PHREG Error: "Variable_ does not have the same format as in the input data"

Reeza — Thu, 25 Jul 2019 15:47:54 GMT

You should mark @ballardw as the correct solution, not your own answer.