topic Re: Subset By and accessing the :col values used in the subset in Discussions

Subset By and accessing the :col values used in the subset

johnm — Sat, 10 Jun 2023 23:51:41 GMT

Hello,

When subset by is performed, the Table Panel will show the :cols and their values for the given subset data table.

How does user access this information using script command?

Example:

mysubdt = mymaindt << Subset (by ( :first_var, :sec_var, :third_var));  // each var has multiple levels, aka several values. 
// then mysubdt[1] through mysubdt[n] with n being the number of subset data tables created.

For each mysubdt[i], the Panel would show for example for one of the subset data tables:

first_var abc

sec_var xyz

third_var 123

The objective here is to then save each mysubdt[i] by doing a save that uses these variables' values.

mysubdt[1] << save ("dt_abc_xyz_123.jmp");

Just can't seem yet to find this table property information.

Other approaches?

Thanks,

John

Re: Subset By and accessing the :col values used in the subset

txnelson — Mon, 25 Jul 2022 16:42:24 GMT

x=dt<<get table variable("first_var")

Re: Subset By and accessing the :col values used in the subset

johnm — Mon, 25 Jul 2022 17:04:30 GMT

Hi Jim,

Thanks for quick reply!

I subsequently create a string and filename variable:

fld1 = mysubdtt[1] << get table variable ("first_var");
fld2 = mysubdtt[1] << get table variable ("sec_var");
fld3 = mysubdtt[1] << get table variable ("third_var");

filename = "dt_"||(fld1)||"_"||(fld2)||"_"||(fld3);

in an attempt to then save as follows:

mysubdtt[1] << save ("$mypath\$filename.jmp");

but not quite working as the file saved to the mypath is "$filename.jmp".

John

Re: Subset By and accessing the :col values used in the subset

txnelson — Mon, 25 Jul 2022 17:06:04 GMT

Try

mysubdtt[1] << save ("$mypath\" || filename || ".jmp");

Re: Subset By and accessing the :col values used in the subset

johnm — Mon, 25 Jul 2022 17:42:43 GMT

Thanks again Jim!