Plan, execute, measure and optimize customer experiences

How to set the sequence number campaign code & communication code?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

How to set the sequence number campaign code & communication code?

[ Edited ]


The current campaign code structure is C##### (5 digits). The current used number is around 55000.
The client would like to continue the number in the new system. Therefore, e.g.: starting from 55001.
This also applies to the communication.Please also advise if any other sequence number need to be updated. As I remember, there is a .sas file containing those numbers, which stored in the SAS application folder. please advise me 


Accepted Solutions
Solution
‎09-22-2017 01:49 AM
Contributor
Posts: 51

Re: How to set the sequence number campaign code & communication code?

Yes, the current sequence numbers are stored in a SAS dataset "MAMisc.Sequence"   MAMisc library is stored somewhere down the line from sasconfig/Lev1/Applications/..., (the actual path changes with versions) and often times it is pre-assigned in your EG sessions (not always though).

 

It's the only place these numbers need to be updated, and in my opinion, it's relatively safe to do so. We have done such update from time to time (often it is needed when some migration is happening to avoid IDs overlapping). 

 

Make sure you don't screw up this dataset encoding (prefer in-place updates, try not to "rewrite" it completely unless you're certain there is no encoding mismatch) and don't leave it open in your EG session after the change - it will lock the dataset and you will be getting an error in SAS CI Studio doing things like campaign creation, runs, saves etc.

 

 

-------
Dmitriy Alergant, Tier One Analytics

View solution in original post


All Replies
Solution
‎09-22-2017 01:49 AM
Contributor
Posts: 51

Re: How to set the sequence number campaign code & communication code?

Yes, the current sequence numbers are stored in a SAS dataset "MAMisc.Sequence"   MAMisc library is stored somewhere down the line from sasconfig/Lev1/Applications/..., (the actual path changes with versions) and often times it is pre-assigned in your EG sessions (not always though).

 

It's the only place these numbers need to be updated, and in my opinion, it's relatively safe to do so. We have done such update from time to time (often it is needed when some migration is happening to avoid IDs overlapping). 

 

Make sure you don't screw up this dataset encoding (prefer in-place updates, try not to "rewrite" it completely unless you're certain there is no encoding mismatch) and don't leave it open in your EG session after the change - it will lock the dataset and you will be getting an error in SAS CI Studio doing things like campaign creation, runs, saves etc.

 

 

-------
Dmitriy Alergant, Tier One Analytics
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 192 views
  • 1 like
  • 2 in conversation