Programming the statistical procedures from SAS

Invalid or missing data forBlock and Y

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Invalid or missing data forBlock and Y

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,


Accepted Solutions
Solution
‎01-25-2017 11:23 AM
SAS Super FREQ
Posts: 3,551

Re: Invalid or missing data forBlock and Y

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.

 

View solution in original post


All Replies
SAS Super FREQ
Posts: 3,551

Re: Invalid or missing data forBlock and Y

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;
Occasional Contributor
Posts: 9

Re: Invalid or missing data forBlock and Y

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

SAS Super FREQ
Posts: 3,551

Re: Invalid or missing data forBlock and Y

[ Edited ]

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
;
Occasional Contributor
Posts: 9

Re: Invalid or missing data forBlock and Y

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?

Solution
‎01-25-2017 11:23 AM
SAS Super FREQ
Posts: 3,551

Re: Invalid or missing data forBlock and Y

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.

 

Occasional Contributor
Posts: 9

Re: Invalid or missing data forBlock and Y

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,

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 323 views
  • 2 likes
  • 2 in conversation