3 Replies Latest reply: Jun 3, 2016 4:04 AM by Martin Haseneyer RSS

    Need to know how to create a variable from accross multiple files

    Mark Graham

      I am reading in multiple files with the same file layout, except for a created variable in each load statement.

       

      I want to be able to add (sum) each of the created variables, which provides me with a combination variable (combo).

       

      For example, the variables are var1, var2, var3, etc.  Var1=1, Var2=10 and Var3=100.  I want a variable that is a combination of 111.  Combo = 111 or Combo = 101.... you get the idea.

       

      Help.  So the question is:

      Do I calculate a new variable?

      Do I develop and expression?

      Do I use the “aggr” function?

       

      I am new at this so I might need detailed instructions. I have attached a brief PowerPoint description of the desired outcome.

       

      Thanks in advance.

       

      Mark