topic Re: SAS Visual Analytics create a Sequence variable in SAS Visual Analytics

SAS Visual Analytics create a Sequence variable

gabras — Sun, 05 Aug 2018 08:47:52 GMT

Hi,

i would like to create a sequence column in VA. Is it possible?

ID	Object	Sequence
1	A	1
1	A	2
1	A	3
1	B	1
2	B	1
2	B	2
2	B	3
1	A	4

I have to create it in VA because that matrix has to change based on filter someone might choose.

For example, if i choose a shorter period of time it could change like this (and the sequence accordingly):

ID	Object	Sequence
1	A	1
1	B	1
2	B	1
2	B	2
1	A	2

Can someone help me?

Thank you

Re: SAS Visual Analytics create a Sequence variable

akash1088 — Sun, 05 Aug 2018 10:52:23 GMT

you want to show as a list table ?

Re: SAS Visual Analytics create a Sequence variable

gabras — Sun, 05 Aug 2018 12:00:31 GMT

Hi @akash1088,

yes.

Can i ask you why are you asking me this question? Would you suggest something else?

Thanks

Re: SAS Visual Analytics create a Sequence variable

akash1088 — Sun, 05 Aug 2018 12:08:19 GMT

hold ctrl key + press sequence + id + object.
may this can help ur requirment.

Basically you want to sort data on multiple variable in sas va right ?

Re: SAS Visual Analytics create a Sequence variable

gabras — Sun, 05 Aug 2018 12:21:33 GMT

Yes.

I have to enumerate the record based on ID and Object.

I'm sorry but i'm new on sas VA: i don't understand your piece of code. 😞

Re: SAS Visual Analytics create a Sequence variable

akash1088 — Sun, 05 Aug 2018 12:47:26 GMT

Holding CTRL key click on the column name in list table as per the sequence you want.

Re: SAS Visual Analytics create a Sequence variable

gabras — Sun, 05 Aug 2018 13:40:40 GMT

@akash1088

i have to create the Sequence column, not just order the table.

One more question, do you know if i can take the value of a variable of the previous row?

In SAS Base i would use:

data want;
set have;
prev_date = lag(created);
if first.id then prev_date = created;
run;

Re: SAS Visual Analytics create a Sequence variable

akash1088 — Sun, 05 Aug 2018 15:11:24 GMT

can you just show one sample what exactly you want.

and sorry I don't know how to create that sequence column in sas va but in base sas you can use this one.

hope this gonna help u.

Data have;
Infile datalines dlm='	';
input ID:1 Object:$1. ;	
datalines;
1	A	
1	A	
1	A	
1	B	
2	B	
2	B	
2	B
1	A
;
run;

Proc Sort data=have;
by ID Object;
Run;


data new;
set have;
by ID Object;
if first.object then sequence=0;
Sequence+1;
run;

Re: SAS Visual Analytics create a Sequence variable

gabras — Sun, 05 Aug 2018 15:21:44 GMT

@akash1088

Thank you, but the problme is to create it in SAS VA.

In BASE is quite simple as you posted, but in VA it seems impossible.

Any workaround?

Re: SAS Visual Analytics create a Sequence variable

FalkoSchulz — Sun, 05 Aug 2018 22:23:38 GMT

Unfortunately the VA query engine doesn't allow such sequence or row based calculation and I'm not aware of a work-around other than calculating such as part of the data preparation step.