topic SAS Programming help in SAS Programming

topic SAS Programming help in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/351488#M273729 <P>Hi,</P><P> </P><P>I have two datasets and want to produce third dataset like mentioned below.</P><P> </P><P>1st Dataset:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key1</TD><TD>key2</TD></TR><TR><TD>101</TD><TD>901</TD></TR><TR><TD>101</TD><TD>902</TD></TR><TR><TD>101</TD><TD>903</TD></TR><TR><TD>101</TD><TD>904</TD></TR><TR><TD>101</TD><TD>905</TD></TR><TR><TD>102</TD><TD>801</TD></TR><TR><TD>102</TD><TD>802</TD></TR><TR><TD>102</TD><TD>803</TD></TR><TR><TD>102</TD><TD>804</TD></TR></TBODY></TABLE><P> </P><P>2nd Dataset:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key1</TD><TD>key3</TD><TD>key4</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>var5</TD><TD>varn</TD></TR><TR><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P> </P><P>Desired output dataset:</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key2</TD><TD>key1</TD><TD>key3</TD><TD>key4</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>var5</TD><TD>varn</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P> </P><P>Thanks for your time and help.</P><P>John</P> Thu, 20 Apr 2017 00:34:25 GMT InnovativeMinds 2017-04-20T00:34:25Z SAS Programming help https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/351488#M273729 <P>Hi,</P><P> </P><P>I have two datasets and want to produce third dataset like mentioned below.</P><P> </P><P>1st Dataset:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key1</TD><TD>key2</TD></TR><TR><TD>101</TD><TD>901</TD></TR><TR><TD>101</TD><TD>902</TD></TR><TR><TD>101</TD><TD>903</TD></TR><TR><TD>101</TD><TD>904</TD></TR><TR><TD>101</TD><TD>905</TD></TR><TR><TD>102</TD><TD>801</TD></TR><TR><TD>102</TD><TD>802</TD></TR><TR><TD>102</TD><TD>803</TD></TR><TR><TD>102</TD><TD>804</TD></TR></TBODY></TABLE><P> </P><P>2nd Dataset:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key1</TD><TD>key3</TD><TD>key4</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>var5</TD><TD>varn</TD></TR><TR><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P> </P><P>Desired output dataset:</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>key2</TD><TD>key1</TD><TD>key3</TD><TD>key4</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>var5</TD><TD>varn</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>901</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>902</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a1</TD><TD>b1</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a2</TD><TD>b2</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>903</TD><TD>101</TD><TD>a3</TD><TD>b3</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>801</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>802</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>803</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a4</TD><TD>b4</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a5</TD><TD>b5</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>804</TD><TD>102</TD><TD>a6</TD><TD>b6</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P> </P><P>Thanks for your time and help.</P><P>John</P> Thu, 20 Apr 2017 00:34:25 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/351488#M273729 InnovativeMinds 2017-04-20T00:34:25Z Re: SAS Programming help https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/351495#M273730 This is a duplicate post I believe, a similar post has been responded. Thu, 20 Apr 2017 01:04:57 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/351495#M273730 Jagadishkatam 2017-04-20T01:04:57Z Re: SAS Programming help https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/352010#M273731 <P>Do no post several times please.</P> Fri, 21 Apr 2017 03:49:56 GMT https://communities.sas.com/t5/SAS-Programming/SAS-Programming-help/m-p/352010#M273731 ChrisNZ 2017-04-21T03:49:56Z