topic Student with SAS problems in Statistical Procedures

topic Student with SAS problems in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167671#M8744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are two students, and we need SAS for our thesis. We've been working a lot with the program, but now we are stuck.</P><P>I have our end dataset, and now I want to use a model, but I always get an error, and I don't know what I am doing wrong.</P><P></P><P>I use the following code: </P><P></P><P>data TEST_01;</P><P>set WORK.QUERY_FOR_END_DATASET_SAS7BDAT; /*DIT IS DE BEGINDATASET -OAS  </P><P>DEZE NAAM AAN*/</P><P>YEAR = YEAR(DATE);</P><P>MONTH = MONTH(DATE);</P><P>run;</P><P></P><P></P><P>proc sort data=TEST_01 out=TEST_2;</P><P>by ISIN YEAR;</P><P>run;</P><P>proc reg data=TEST_2 outest=est noprint;</P><P>model RET_FUND = MARKET SMB HML ; /*SMB AND HML KAN JE WEGLATEN*/</P><P>by ISIN YEAR;</P><P>output out=b;</P><P>run;</P><P>quit;</P><P></P><P>If i do this i get the following error:</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0026535543(RI) YEAR=1988</P><P>2                                                          The SAS System                              20:23 Thursday, April 3, 2014</P><P></P><P></P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0058643553(RI) YEAR=2001</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0126900241(RI) YEAR=1988</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0172903495(RI) YEAR=1999</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0946696730(RI) YEAR=2006</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0949010590(RI) YEAR=2009</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6212469074(RI) YEAR=2010</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6213172313(RI) YEAR=2010</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6218515391(RI) YEAR=2011</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6226567400(RI) YEAR=2011</P><P>NOTE: Interactivity disabled with BY processing.</P><P>NOTE: PROCEDURE REG used (Total process time):</P><P></P><P></P><P>Does anyone know that we are doing wrong?</P><P></P><P>Thanks in advance!</P><P>      real time           1.95 seconds</P><P>      cpu time            1.95 seconds</P></BODY></HTML> Thu, 03 Apr 2014 18:38:16 GMT bjinge 2014-04-03T18:38:16Z Student with SAS problems https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167671#M8744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are two students, and we need SAS for our thesis. We've been working a lot with the program, but now we are stuck.</P><P>I have our end dataset, and now I want to use a model, but I always get an error, and I don't know what I am doing wrong.</P><P></P><P>I use the following code: </P><P></P><P>data TEST_01;</P><P>set WORK.QUERY_FOR_END_DATASET_SAS7BDAT; /*DIT IS DE BEGINDATASET -OAS  </P><P>DEZE NAAM AAN*/</P><P>YEAR = YEAR(DATE);</P><P>MONTH = MONTH(DATE);</P><P>run;</P><P></P><P></P><P>proc sort data=TEST_01 out=TEST_2;</P><P>by ISIN YEAR;</P><P>run;</P><P>proc reg data=TEST_2 outest=est noprint;</P><P>model RET_FUND = MARKET SMB HML ; /*SMB AND HML KAN JE WEGLATEN*/</P><P>by ISIN YEAR;</P><P>output out=b;</P><P>run;</P><P>quit;</P><P></P><P>If i do this i get the following error:</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0026535543(RI) YEAR=1988</P><P>2                                                          The SAS System                              20:23 Thursday, April 3, 2014</P><P></P><P></P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0058643553(RI) YEAR=2001</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0126900241(RI) YEAR=1988</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0172903495(RI) YEAR=1999</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0946696730(RI) YEAR=2006</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE0949010590(RI) YEAR=2009</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6212469074(RI) YEAR=2010</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6213172313(RI) YEAR=2010</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6218515391(RI) YEAR=2011</P><P>ERROR: No valid observations are found.</P><P>NOTE: The above message was for the following BY group:</P><P>      ISIN=BE6226567400(RI) YEAR=2011</P><P>NOTE: Interactivity disabled with BY processing.</P><P>NOTE: PROCEDURE REG used (Total process time):</P><P></P><P></P><P>Does anyone know that we are doing wrong?</P><P></P><P>Thanks in advance!</P><P>      real time           1.95 seconds</P><P>      cpu time            1.95 seconds</P></BODY></HTML> Thu, 03 Apr 2014 18:38:16 GMT https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167671#M8744 bjinge 2014-04-03T18:38:16Z Re: Student with SAS problems https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167672#M8745 <HTML><HEAD></HEAD><BODY><P>The error messages are telling you that there are no valid observations for certain BY groups. For example, run this code:</P><P></P><P>proc print data=test_2;</P><P>where (ISIN="BE0026535543(RI)" AND YEAR=1988);</P><P>run;</P><P></P><P>You will see that the BY group has only one observation. The response variable is missing, which means that you have ZERO observations on which to conduct your regression analysis. </P></BODY></HTML> Thu, 03 Apr 2014 19:02:15 GMT https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167672#M8745 Rick_SAS 2014-04-03T19:02:15Z Re: Student with SAS problems https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167673#M8746 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for the reply. Indeed we miss an observation for ISIN <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">BE0026535543</SPAN>. </P><P>Is there a solution to get rid of this error?</P><P>I mean can we remove the observations with a variable missing in SAS?</P></BODY></HTML> Thu, 03 Apr 2014 19:06:59 GMT https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167673#M8746 bjinge 2014-04-03T19:06:59Z Re: Student with SAS problems https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167674#M8747 <HTML><HEAD></HEAD><BODY><P>A quick way, depending on your actual data, may be to use a where clauseas that doesn't require changing your data.</P><P>If it is only the RET_FUND variable missing</P><P></P><P>Change</P><P> proc reg data=TEST_2</P><P>to</P><P>     proc reg data=TEST_2 (where=( RET_FUND ne .))</P></BODY></HTML> Thu, 03 Apr 2014 19:52:07 GMT https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167674#M8747 ballardw 2014-04-03T19:52:07Z Re: Student with SAS problems https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167675#M8748 <HTML><HEAD></HEAD><BODY><P>Thank you a lot! It works!</P></BODY></HTML> Thu, 03 Apr 2014 20:04:06 GMT https://communities.sas.com/t5/Statistical-Procedures/Student-with-SAS-problems/m-p/167675#M8748 bjinge 2014-04-03T20:04:06Z