topic Re: Questions about create new data sets and merge them into one in SAS Programming https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124266#M25445 <HTML><HEAD></HEAD><BODY><PRE __jive_macro_name="quote" class="jive_text_macro jive_macro_quote" modifiedtitle="true"> <P>MisoLee wrote:</P> <P></P> <P>Hi!</P> <P>(1) why did it mention variable PERWT04F is uninitialized while my commands are dealing with PERWT05F</P> </PRE><P>The variables reported as uninitialized are appearing in your length statement, so they are created. They are not initialized because 1) the dataset in the set statement does not contain them and 2) you do not assign a value to them.</P><P></P><P>The number of variables differes because some of the variables created by the length statement exist in the data set and match the Keep list but not in the first data step. In the first date step you have keep variables with 05 in the name that will not appear in the second data set because they were not on the keep statement of the second..</P></BODY></HTML> Mon, 29 Apr 2013 20:08:37 GMT ballardw 2013-04-29T20:08:37Z Questions about create new data sets and merge them into one https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124263#M25442 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I am trying to create 7 new data sets from 2004 to 2010. Then I hope to merge them into one. The result for the first data (i.e. 2004) is fine. But from 2005, the log shows weird results as the attachment. So my questions are:</P><P></P><P>(1) why did it mention variable PERWT04F is uninitialized while my commands are dealing with PERWT05F</P><P>(2) why there are 35 variables in the first part of commands but only 27 variables left after the second part of command</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 29 Apr 2013 17:13:01 GMT https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124263#M25442 MisoLee 2013-04-29T17:13:01Z Re: Questions about create new data sets and merge them into one https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124264#M25443 <HTML><HEAD></HEAD><BODY><P>Why are those variables in your length statement?</P></BODY></HTML> Mon, 29 Apr 2013 17:16:40 GMT https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124264#M25443 Reeza 2013-04-29T17:16:40Z Re: Questions about create new data sets and merge them into one https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124265#M25444 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Firstly, from your log your second data table has the same name as the first and the SET statement is for the same table.&nbsp; I think you need to change the names of each of your tables to something like DATA MEPS0<STRONG>5</STRONG>, for the first, DATA MEPS0<STRONG>6</STRONG> for the second. and so on.&nbsp; also each table should have the same set (source table).</P><P></P><P>Then use:</P><P></P><P>WHERE YEAR=2005;&nbsp;&nbsp; for the first,.</P><P>WHERE YEAR=2006;&nbsp; for the second,</P><P></P><P>etc.</P></BODY></HTML> Mon, 29 Apr 2013 17:43:31 GMT https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124265#M25444 OS2Rules 2013-04-29T17:43:31Z Re: Questions about create new data sets and merge them into one https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124266#M25445 <HTML><HEAD></HEAD><BODY><PRE __jive_macro_name="quote" class="jive_text_macro jive_macro_quote" modifiedtitle="true"> <P>MisoLee wrote:</P> <P></P> <P>Hi!</P> <P>(1) why did it mention variable PERWT04F is uninitialized while my commands are dealing with PERWT05F</P> </PRE><P>The variables reported as uninitialized are appearing in your length statement, so they are created. They are not initialized because 1) the dataset in the set statement does not contain them and 2) you do not assign a value to them.</P><P></P><P>The number of variables differes because some of the variables created by the length statement exist in the data set and match the Keep list but not in the first data step. In the first date step you have keep variables with 05 in the name that will not appear in the second data set because they were not on the keep statement of the second..</P></BODY></HTML> Mon, 29 Apr 2013 20:08:37 GMT https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124266#M25445 ballardw 2013-04-29T20:08:37Z Re: Questions about create new data sets and merge them into one https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124267#M25446 <HTML><HEAD></HEAD><BODY><P>I figured it out now. Thank everyone for your help!!</P></BODY></HTML> Mon, 29 Apr 2013 20:46:52 GMT https://communities.sas.com/t5/SAS-Programming/Questions-about-create-new-data-sets-and-merge-them-into-one/m-p/124267#M25446 MisoLee 2013-04-29T20:46:52Z