topic Re: Invalid or missing data forBlock and Y in Statistical Procedures

Invalid or missing data forBlock and Y

Thanhlong — Thu, 05 Jan 2017 12:54:30 GMT

Please help me,

I don t knnow why it usually say error : invalid or missing error

I send you my code and data

Excuse me if i write wrong somethings. I don t speak very well english.

Thank you so much,

Re: Invalid or missing data forBlock and Y

Rick_SAS — Thu, 05 Jan 2017 13:30:21 GMT

Give a name to your data set. Then refer to the data by its name.

Data Experiment;
Input P $ M $ Block Y;
cards;
P0 M20 1 215
P0 M25 1 215
P0 M30 1 250
... more data here ...
;
proc glimmix data=Experiment;
 class P M Block;
 model Y = P M P*M;
 random Block P*Block;
 lsmeans P*M / adjust=simulate lines;  /* change P|M to P*M */
 run;

Re: Invalid or missing data forBlock and Y

Thanhlong — Fri, 06 Jan 2017 04:06:49 GMT

Thank you for your reply Rick-SAS,

I tried to give the name of data but it still does not work with the same error.

I attach here the error record for you.

Help me to solve this situation, please .

Tran

Re: Invalid or missing data forBlock and Y

Rick_SAS — Fri, 06 Jan 2017 11:18:26 GMT

Your DATA step is not working, so the data set is corrupted. In particular, the BLOCK variable is always set to missing, which is why PROC GLIMMIX is complaining. Try this:

Data Coibang;
length P $4. M $3.;
Input P $ M $ Block Y;
cards;
P0 M20 1 215
P0 M25 1 215
P0 M30 1 250
P0 M20 2 215
P0 M25 2 195
P0 M30 2 230
P0 M20 3 193
P0 M25 3 190
P0 M30 3 245
P50 M20 1 300
P50 M25 1 345
P50 M30 1 350
P50 M20 2 310
P50 M25 2 334
P50 M30 2 325
P50 M20 3 340
P50 M25 3 360
P50 M30 3 330
P100 M20 1 370
P100 M25 1 395
P100 M30 1 340
P100 M20 2 340
P100 M25 2 380
P100 M30 2 300
P100 M20 3 335
P100 M25 3 375
P100 M30 3 315
P150 M20 1 300
P150 M25 1 295
P150 M30 1 325
P150 M20 2 250
P150 M25 2 310
P150 M30 2 320
P150 M20 3 298
P150 M25 3 320
P150 M30 3 315
;

Re: Invalid or missing data forBlock and Y

Thanhlong — Mon, 09 Jan 2017 13:19:27 GMT

Thank you so much Rick-SAS. I tried and I found that there are somethings wrong when I copy the data from excel to SAS. Now it s ok.

But now I have another question, the results are exported in french, not in english. I don't know why and how I can change it? Can you help me?

Re: Invalid or missing data forBlock and Y

Rick_SAS — Mon, 09 Jan 2017 14:30:53 GMT

Most likely the system LOCALE option is set to French.

You can check your LOCALE option by running the following statements and then looking in the SAS log.

proc options option=LOCALE value;
run;

You can try to change your locale by using an OPTIONS statement such as

options locale=en_US;

You might need to check with your SAS administrator to see which locales.languages are supported on your SAS system.

Re: Invalid or missing data forBlock and Y

Thanhlong — Tue, 10 Jan 2017 01:16:24 GMT

Hi Rick-SAS,

I tried to check the local language who are supported on my SAS system base on your guide.

The results is:

SAS (r) Proprietary Software Version 9.4 TS1M4

Informations sur la valeur de l'option SAS LOCALE

Valeur :FR_FR

Etendue : IOM ROOT COMP ENV

Comment la valeur d'option est définie : Options Statement

It's the french?. How can I try to change the language of output data to english now?

I'm new in SAS, it's completely dificult for me.

Please help me, it's very important for me now.

Thank you,