topic Re: How to multiple variables from two different datasets? in SAS Programming

How to multiple variables from two different datasets?

igsteo — Wed, 14 Apr 2021 08:19:51 GMT

Variables in totalmktcap: mktcap16--mktcap20

Variables in decme2_all: stock me16--me20

I am trying to calculate the weightage of every stock per year i.e. from 2016 to 2020. However, that means dividing values from two different data sets. I need help to code this. It would be much appreciated

Thank you everyone!

Re: How to multiple variables from two different datasets?

japelin — Tue, 13 Apr 2021 03:39:58 GMT

The response will vary depending on what kind of calculation you want to do.
rename, merge, or...

Can you give us a specific calculation using the variable name?

Re: How to multiple variables from two different datasets?

igsteo — Tue, 13 Apr 2021 03:46:27 GMT

Example:
mktweight16=m16/mktcap16
by stock

i will carry this out for data from 2016 - 2020

Re: How to multiple variables from two different datasets?

japelin — Tue, 13 Apr 2021 04:10:17 GMT

Try this code.

proc sql;
  create table have as
    select * from totalmktcap, decme2_all;
  ;
quit;

data want;
  set have;
  array mw{*} mktweight16-mktweight20;
  array me{*} me16-me20;
  array mk{*} mktcap16-mktcap20;
  do i=1 to dim(mw);
    mw{i}=me{i}/mk{i};
  end;
  drop i;
run;

I don't have the data set, so I haven't tested it yet.

Re: How to multiple variables from two different datasets?

igsteo — Tue, 13 Apr 2021 05:47:16 GMT

thank you so much!