topic Re: problem sas import !! in Statistical Procedures

Problem with SAS software depot

michshoot — Mon, 07 May 2018 14:59:11 GMT

Re: Problem with SAS software depot

jklaverstijn — Mon, 07 May 2018 15:16:41 GMT

Oh, where to start! This is just not the way to ask for help. Could you make an effort and describe what you have, what you're expecting and put that in the form of a question? And make it text instead of image so others can copy/paste and add suggestions?

And how does your picture relate to issues with a software depot as the title suggests?

Cheers,

- Jan.

problem sas import !!

michshoot — Mon, 07 May 2018 15:29:37 GMT

hello everyone in the topic below I put images, my problem that does not read the variables variables as numerical variables are those in red in the log.
thank you

Re: problem sas import !!

Kurt_Bremser — Mon, 07 May 2018 15:34:07 GMT

CODE, LOG AND DATA IN TEXT FORM!

PLEASE.

See my footnotes for help how to post these.

Re: Problem with SAS software depot

ballardw — Mon, 07 May 2018 15:54:50 GMT

Proc Reg requires all variables on the MODEL statement to be numeric. You show variable REPARTO on the model statement and it is obviously not numeric.

The viewtable image of Ora_Analizi and ID_paziente appearing left justified likely means that they are character variables. ID numbers are very poor candidate variables in Proc Reg models even if numeric as likely the only thing I would expect is newer ID values are larger than older for any given source sequence.

I am going to guess that you are running code against a data set generated using PROC IMPORT.

Proc Import has to guess what type a variable is. Just because you think it should be a number does not mean that the guessing rules involved will match. Things like blank rows or how the data was entered in the file can affect how import treats the values.

Run Proc contents on the input data set and examine the variable types for all of the variables you are having issues with. I suspect they will appear as CHAR. At which point you will have to back to the source of the data and regenerate it so that the variable types are as expected.

Often when we see this the data started in a spreadsheet and insufficient attention was paid when the data was brought into SAS that variable types were correct.