Hi pcapazzi,
Unfortunately using multiple # will just result in duplication of the unique sequence number. For example if the sequence was up to 123 and you used CAMP### as the Code Format, the result would be a campaign code of CAMP123123123.
Your suggestion of starting at 10000 is the best one I can see, and it doesn't require downstream manipulation of codes in export files and macros etc, and the data in the CDM matches whats in export files.
Note that when you get to CAMP99999, then next one will be CAMP100000.
Regards
James
I would guess you know how to create a variable that increases by 1 each time, and the real question is how to keep the leading zeros.
If you need help creating a variable that increases by 1, you'll have to show more of the logic ... when should it increase by 1? Assuming you have such a variable, but its name is a secret, you could use:
campaign_code = 'C' || put(secret_variable, z5.);
I do not see anything in the Admin/User Guides to provide a format with leading zeros. The only shot in the dark I could think of is try CAMP##### as a format. Otherwise start it out at CAMP10000.
As Dmitry pointed out in another post you can change the starting number in the SAS Dataset MAMisc. Take his advice in avoiding locks if you update it.
Thanks.
Hi pcapazzi,
Unfortunately using multiple # will just result in duplication of the unique sequence number. For example if the sequence was up to 123 and you used CAMP### as the Code Format, the result would be a campaign code of CAMP123123123.
Your suggestion of starting at 10000 is the best one I can see, and it doesn't require downstream manipulation of codes in export files and macros etc, and the data in the CDM matches whats in export files.
Note that when you get to CAMP99999, then next one will be CAMP100000.
Regards
James
Thanks James.
I have updated the sequence in MAMisc.
Hi James,
Can i use the same code format for Communication Code as well ?
Because i also have same kind of requirement for Communication Code i.e. COMM+ 5digit.
However, when i changed the Sequence table for CommunicationSK it is not reflecting in MA where as for Campaign Code when i updated the Sequence table for CampaignSK it is working as expected i.e. Campaign Code is C10001.
Thanks in advance.
Hi,
Most likely, nobody can tell you what the Campaign Code should be originally in SAS MA and CDM.
Whoever asks that, needs that code to appear the way they need, somewhere.
I all the places where this code may surface, you can implement an appropriate transformation instead of using the original code:
Good luck!
Want to review SAS CI360? G2 is offering a gift card or charitable donation for each accepted review. Use this link to opt out of receiving anything of value for your review.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
Compatibility notice re: SAS 9.4M8 (TS1M8) or later
SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.
Find more tutorials on the SAS Users YouTube channel.
Want to review SAS CI360? G2 is offering a gift card or charitable donation for each accepted review. Use this link to opt out of receiving anything of value for your review.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
Compatibility notice re: SAS 9.4M8 (TS1M8) or later