https://communities.sas.com/t5/SAS-Programming/Multiplying-single-observations-from-one-dataset-to-many-in/m-p/439521#M109676 <P>This is known as scoring a data set. Look at PROC SCORE and I believe the example section has one specifically on using Factors /principal components/eigenvectors.&nbsp;</P> <P>&nbsp;</P> <P><A href="http://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_score_examples01.htm&amp;docsetVersion=14.3&amp;locale=en" target="_blank">http://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_score_examples01.htm&amp;docsetVersion=14.3&amp;locale=en</A></P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/195077">@smcelroy</a> wrote:<BR /> <P>Hello Everyone!</P> <P>I am trying to create a wealth index using the eigenvectors obtained from a principal component analysis and multiple other variables. My data looks like this&nbsp;</P> <P>Dataset 1:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dataset 2:</P> <P>&nbsp;</P> <P>Prin1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;V1&nbsp; &nbsp; &nbsp;V2&nbsp; &nbsp; V3&nbsp; &nbsp; &nbsp;V4&nbsp; &nbsp; &nbsp;V5&nbsp; &nbsp; &nbsp;V6&nbsp; &nbsp;V7 ....(other variables that are not related but I need to keep)</P> <P>.23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> <P>.43&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>.62&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> <P>.09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> <P>.67&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P> <P>.82&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7</P> <P>&nbsp;</P> <P>I would like to calculate&nbsp; &nbsp; &nbsp; INDEX=0.23(V1)+.43(V2)+.62(V3)+.12(V4)+.09(V5)+67(V6)+.82(V7)</P> <P>So I would like to multiply the first observation of dataset 1 by the entire column V1 of dataset 2 and repeat this for all the observations in dataset 1.</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Thu, 22 Feb 2018 23:47:56 GMT Reeza 2018-02-22T23:47:56Z https://communities.sas.com/t5/SAS-Programming/Multiplying-single-observations-from-one-dataset-to-many-in/m-p/439517#M109674 <P>Hello Everyone!</P><P>I am trying to create a wealth index using the eigenvectors obtained from a principal component analysis and multiple other variables. My data looks like this&nbsp;</P><P>Dataset 1:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dataset 2:</P><P>&nbsp;</P><P>Prin1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;V1&nbsp; &nbsp; &nbsp;V2&nbsp; &nbsp; V3&nbsp; &nbsp; &nbsp;V4&nbsp; &nbsp; &nbsp;V5&nbsp; &nbsp; &nbsp;V6&nbsp; &nbsp;V7 ....(other variables that are not related but I need to keep)</P><P>.23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>.43&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>.62&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P><P>.09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P><P>.67&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>.82&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7</P><P>&nbsp;</P><P>I would like to calculate&nbsp; &nbsp; &nbsp; INDEX=0.23(V1)+.43(V2)+.62(V3)+.12(V4)+.09(V5)+67(V6)+.82(V7)</P><P>So I would like to multiply the first observation of dataset 1 by the entire column V1 of dataset 2 and repeat this for all the observations in dataset 1.</P><P>&nbsp;</P> Thu, 22 Feb 2018 23:18:40 GMT https://communities.sas.com/t5/SAS-Programming/Multiplying-single-observations-from-one-dataset-to-many-in/m-p/439517#M109674 smcelroy 2018-02-22T23:18:40Z https://communities.sas.com/t5/SAS-Programming/Multiplying-single-observations-from-one-dataset-to-many-in/m-p/439521#M109676 <P>This is known as scoring a data set. Look at PROC SCORE and I believe the example section has one specifically on using Factors /principal components/eigenvectors.&nbsp;</P> <P>&nbsp;</P> <P><A href="http://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_score_examples01.htm&amp;docsetVersion=14.3&amp;locale=en" target="_blank">http://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_score_examples01.htm&amp;docsetVersion=14.3&amp;locale=en</A></P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/195077">@smcelroy</a> wrote:<BR /> <P>Hello Everyone!</P> <P>I am trying to create a wealth index using the eigenvectors obtained from a principal component analysis and multiple other variables. My data looks like this&nbsp;</P> <P>Dataset 1:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dataset 2:</P> <P>&nbsp;</P> <P>Prin1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;V1&nbsp; &nbsp; &nbsp;V2&nbsp; &nbsp; V3&nbsp; &nbsp; &nbsp;V4&nbsp; &nbsp; &nbsp;V5&nbsp; &nbsp; &nbsp;V6&nbsp; &nbsp;V7 ....(other variables that are not related but I need to keep)</P> <P>.23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> <P>.43&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>.62&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>.12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> <P>.09&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> <P>.67&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P> <P>.82&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7</P> <P>&nbsp;</P> <P>I would like to calculate&nbsp; &nbsp; &nbsp; INDEX=0.23(V1)+.43(V2)+.62(V3)+.12(V4)+.09(V5)+67(V6)+.82(V7)</P> <P>So I would like to multiply the first observation of dataset 1 by the entire column V1 of dataset 2 and repeat this for all the observations in dataset 1.</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Thu, 22 Feb 2018 23:47:56 GMT https://communities.sas.com/t5/SAS-Programming/Multiplying-single-observations-from-one-dataset-to-many-in/m-p/439521#M109676 Reeza 2018-02-22T23:47:56Z