topic Re: how to use a global variable/list for a column assignment? in SAS Programming

In JMP/JSL, how to use a global variable/list for a column assignment?

zxu1 — Mon, 05 Nov 2012 22:13:12 GMT

I like to replace the following column name assignment:

x = {:Name("Lot name"));

by a variable list which contains a list of column names from a table. Say the list is:

var_list = {"Lot name", "Location", "Cost", ...}.

All following are giving me errors:

x = {:Name(var_list[1])};

x = {:Name(char(eval(var_list[1]))};

...

Any good suggestion?

Thanks.

John

Re: how to use a global variable/list for a column assignment?

art297 — Mon, 05 Nov 2012 22:31:31 GMT

What type of SAS system or proc are you running and how is var_list being created?

Re: how to use a global variable/list for a column assignment?

zxu1 — Mon, 05 Nov 2012 22:37:14 GMT

Oops! I mean: using JMP/JSL scripting. Not in SAS.

Re: how to use a global variable/list for a column assignment?

art297 — Mon, 05 Nov 2012 22:46:08 GMT

You will probably have more success, then, reposting your question in the JMP forum.

Re: In JMP/JSL, how to use a global variable/list for a column assignment?

Reeza — Mon, 05 Nov 2012 23:26:56 GMT

Is this useful:

http://www.jmp.com/support/help/Manipulating_Columns.shtml

Re: In JMP/JSL, how to use a global variable/list for a column assignment?

zxu1 — Mon, 05 Nov 2012 23:52:13 GMT

Reeza - thank you for providing the reference link, but not exactly what I need, or at least I cannot find the solution from it yet. Here is what I like to do:

For example, I have a table dt with n columns, X1, X2, ..., Xn. I need to draw distributions for EACH column, X(i), like below (repeat n times):

Distribution(

Continuous Distribution(

Column( :X1),

Horizontal Layout( 1 ),

Vertical( 0 ),

Normal Quantile Plot( 1 ),

Capability Analysis( LSL( 4 ), USL( 22 ), Target( 13 ) )

)

);

How can I use a loop to do this? I tried the following, but it is not successful :-(.

ColNameList = dt << Get Column Names(Nominal, String);

for (k=1, k<=n, k++,

Distribution(

Continuous Distribution(

Column( :ColNameList),

Horizontal Layout( 1 ),

Vertical( 0 ),

Normal Quantile Plot( 1 ),

Capability Analysis( LSL( 4 ), USL( 22 ), Target( 13 ) )

)

);

Re: In JMP/JSL, how to use a global variable/list for a column assignment?

zxu1 — Sat, 17 Nov 2012 02:16:03 GMT

It is useful. Thanks.