topic Re: Making and list of columns and create another list dynamically in SAS Programming

Making and list of columns and create another list dynamically

achufa — Tue, 30 Jun 2015 12:35:51 GMT

I would like to get the list of columns from a group named "GROUP" (Column 1, Column 2, etc); then create another list on columns, dynamically as a loop, in which I would take each column from list "GROUP", assign a new name such as "Column 1 Duplicated", "Column 2 Duplicated", etc. and assign a formula for each new column, like = "Column 1" / 10

thanks

Alex

Re: Making and list of columns and create another list dynamically

Haikuo — Tue, 30 Jun 2015 13:37:31 GMT

The answers would have been much prompt if you can provide a dummy sample input data, and expected outcome. Description alone is too vague.

Re: Making and list of columns and create another list dynamically

achufa — Tue, 30 Jun 2015 13:48:16 GMT

Hi Hai.kuo

ok, here is what I would like to do

I have an original table, containing the following columns:

Population, Test1, Test2, Test3, etc.

Columns 2, 3 and 4 are conbined in a group called "TARGETS".

All Test... columns are numeric, continuous values.

I would like to make a script which would do the following

1. Get a list of columns from a group "TARGETS" (will contain columns Test1, Test2, Test3)

2. Will create 3 new columns, calling each column New_Test1, New_Test2, New_Test3

3. Will assign a formula for each of the new columns, such as New_Test1 = Test1/10.

hope this explains my case

thanks

Re: Making and list of columns and create another list dynamically

ballardw — Tue, 30 Jun 2015 14:55:37 GMT

Example data should be in a tabular form indicating the variable names. Input data is best provided as a data step code so that we can manipulate the examples.

Output should look show what the final result would look like and the rules provided.

Your example looks like an array process. Arrays are the basic method for handling groups of related variables especially for identical or very similar processes.

data want;

set have;

array test test1-test3; /* or names of variables if different*/

array newtest New_test1 - New_test3; /* make sure the number of elements match the number of "test" variables*/

do j=1 to dim(test);

new_test = test/10;

end;

drop j;

run;

Re: Making and list of columns and create another list dynamically

achufa — Tue, 30 Jun 2015 17:21:50 GMT

Hi ballardw

thanks for reply. But I am new to JSL and can't realy understand your suggestion.

Here is an example, please see two tables below. Could you please kindly make a JMP table with the script and send to me?

thanks

Alex

Original data: contains 3 columns of numeric values

POPULATION TEST 1 TEST 2 TEST3

TRAIN 0.65 0.62 0.63

TEST 0.67 0.64 0.68

TEST 0.65 0.62 0.65

TRAIN 0.69 0.64 0.67

TRAIN 0.69 0.66 0.66

TRAIN 0.67 0.66 0.66

TEST 0.69 0.66 0.68

TRAIN 0.65 0.62 0.63

TRAIN 0.67 0.66 0.66

TRAIN 0.65 0.62 0.64

TRAIN 0.65 0.64 0.64

TRAIN 0.65 0.62 0.64

TEST 0.65 0.62 0.66

TRAIN 0.65 0.64 0.65

TEST 0.71 0.64 0.67

TEST 0.65

TRAIN 0.69 0.66 0.66

TRAIN 0.63 0.62 0.63

TRAIN 0.67 0.62 0.65

TRAIN 0.67 0.64 0.65

TRAIN 0.67 0.64 0.66

TEST 0.65 0.64 0.65

TRAIN 0.65 0.64 0.65

Need data:

based on each of 3 test data columns, I need to make 3 additional columns, one for each test column, which will contain the formula, for example DELTA 1 = :TEST 1 / 10; DELTA 2 = :TEST 2 / 10; DELTA 3 = :TEST 3 / 10;

as following:

POPULATION TEST1 TEST2 TEST3 DELTA1 DELTA2 DELTA3

TRAIN 0.65 0.62 0.63 0.065 0.062 0.063

TEST 0.67 0.64 0.68 0.067 0.064 0.068

TEST 0.65 0.62 0.65 0.065 0.062 0.065

TRAIN 0.69 0.64 0.67 0.069 0.064 0.067

TRAIN 0.69 0.66 0.66 0.069 0.066 0.066

TRAIN 0.67 0.66 0.66 0.067 0.066 0.066

TEST 0.69 0.66 0.68 0.069 0.066 0.068

TRAIN 0.65 0.62 0.63 0.065 0.062 0.063

TRAIN 0.67 0.66 0.66 0.067 0.066 0.066

TRAIN 0.65 0.62 0.64 0.065 0.062 0.064

TRAIN 0.65 0.64 0.64 0.065 0.064 0.064

TRAIN 0.65 0.62 0.64 0.065 0.062 0.064

TEST 0.65 0.62 0.66 0.065 0.062 0.066

TRAIN 0.65 0.64 0.65 0.065 0.064 0.065

TEST 0.71 0.64 0.67 0.071 0.064 0.067

TEST 0.65 0.065

TRAIN 0.69 0.66 0.66 0.069 0.066 0.066

TRAIN 0.63 0.62 0.63 0.063 0.062 0.063

TRAIN 0.67 0.62 0.65 0.067 0.062 0.065

TRAIN 0.67 0.64 0.65 0.067 0.064 0.065

TRAIN 0.67 0.64 0.66 0.067 0.064 0.066

TEST 0.65 0.64 0.65 0.065 0.064 0.065

TRAIN 0.65 0.64 0.65 0.065 0.064 0.065

Re: Making and list of columns and create another list dynamically

ballardw — Tue, 30 Jun 2015 19:44:21 GMT

By JSL are running JUMP by any chance? There is a different forum for that.