Summarize Function with multiple by columns

seburke89

All,

 

I'm trying to write a script that gets a count of observations, potentially by 1 or more columns (as determined by input from the user). I can get the script to work for one column, but not for two or more. How do I adjust the code in the by step of the summarize function to handle 1+ columns?

 

Below is a sample of script:

 

 

varName = VarList <<Get selected();
numCols = nitems(varName);
n = nrow(dt);

if(numCols == 0,
	//do one thing
,numCols>0,
	summarize(dt, cat = by(Column(dt,varName)),c=count);
	//do other things
);
	

 

 

 

Thanks!

Sarah

Jeff_Perkinson

There's not quite enough information in your post to be sure I know what the problem is. It would be helpful to know what VarList is, and what the result of the <<Get Selected() message is. However, I suspect that VarList is a list of columns, liket this:

 

dt=open("$SAMPLE_DATA\Big Class.jmp");
varname={:age, :sex};

If so, then you need to put use Eval() around varname in the Summarize() function, like this:

 

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );

varname = {:age, :sex};

//varName = VarList <<Get selected();
numCols = N Items( varName );
n = N Row( dt );

If(
	numCols == 0, 
	//do one thing
,
	numCols > 0,
		Summarize( dt, cat = by( Eval( varname ) ), c = count );
	//do other things
);