topic Re: Create new empty table in SAS ESP and store values from Source in SAS Programming

Create new empty table in SAS ESP and store values from Source

jovic92 — Thu, 20 Sep 2018 13:21:27 GMT

Hi everyone,

I need help with SAS Event Stream Processing studio programming. Not sure if I select the right location for question.

Maybe I will have two or three questions, but also, maybe after this one everything will be more clear for me.

I need to create some trigger for first call of user in a day. I have phone number, id, call start time, call end time, etc. I have CDRs files (csv format) coming every 3 minutes into Data Source window in ESP.

Was thinking about creating a new, empty table to store USER ID right after some USER appears in CDRs and for each record checking if it's already stored (triggered) or not.

All data in that table need to be deleted in 11:59 PM.

Not sure where to started or which windows to use. Is it possible to create that through Compute or Procedural windows and if someone has any example would be really helpful.

I hope I didn't break any rules of posting a questions in community, if I do, I will edit.

Any kind of help is welcomed.

Thanks in advance.

Re: Create new empty table in SAS ESP and store values from Source

ChrisNZ — Fri, 21 Sep 2018 04:07:52 GMT

This

I have phone number, id, call start time, call end time, etc. I have CDRs files (csv format) coming every 3 minutes into Data Source window in ESP.

Was thinking about creating a new, empty table to store USER ID right after some USER appears in CDRs and for each record checking if it's already stored (triggered) or not.

All data in that table need to be deleted in 11:59 PM.

is not enough information.

Please provide example input data and expected output.

Re: Create new empty table in SAS ESP and store values from Source

LinusH — Fri, 21 Sep 2018 06:32:07 GMT

@ChrisNZ ESP doesn't build upon SAS Foundation so the usual sample input/output data requirement might not be applicable here.

@jovic92 to me it sounds you need direction to get started. The communities might not be the best place to get a wide set of knowledge. It's more suited for specific problems.
If you not have already done so, check out all the ESP resources at support.sas.com, like documentation, training, demos, papers etc. You can also contact your local SAS they should be more than happy to get you going.

Re: Create new empty table in SAS ESP and store values from Source

jovic92 — Fri, 21 Sep 2018 09:55:25 GMT

@LinusH Yes, you are right, not sure how can I provide a input/output data/

There is only columns with names I provided, that's all.

Now I have a more specific question. I have started something on my own and found another approach, but there is a problem with getting the current time. With function today() I can get current datetime, but there is no example to extract hour and minutes from that.

I have tried everything I run into it but nothing really works. Expression language, Data Flux is used in Compute window in ESP.

Here is the documentation, but all examples are about date (year, month, day) not even one is about time.

https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.3/dfU_ELRG.pdf

Are you in SAS ESP?

Thanks,

Re: Create new empty table in SAS ESP and store values from Source

LinusH — Fri, 21 Sep 2018 10:39:27 GMT

No, I'm not.

According to that documentation, you can use the formatdate function, and chose a time format.

Even if there is no example for time, I would guess that you use the parameters you want, and format accordingely (similar to the date examples). I would try "HH:MM" for instance if you want to extract that part.

Can you show what you have tried, and result/how it's not working?

Re: Create new empty table in SAS ESP and store values from Source

jovic92 — Fri, 21 Sep 2018 10:57:46 GMT

I have tried with:

Time_flag = today()

formatdate('Time_flag',"hh:mm")

formatdate('Time_flag',"mm")

formatdate(today()',"mm")

formatdate('Time_flag',"hh")

But I got empty cells. Only Time_flag = today() works as expected.

Re: Create new empty table in SAS ESP and store values from Source

LinusH — Fri, 21 Sep 2018 13:02:42 GMT

And it's not that simple that you need to supply upper case literals...?

Re: Create new empty table in SAS ESP and store values from Source

jovic92 — Fri, 21 Sep 2018 13:05:21 GMT

Actually, here is docs:

Details

The format parameter can include any string, but the following strings are replaced with the specified values:

YYYY: four-digit year

YY: two-digit year

MMMM: full month in proper case

MMM: abbreviated three-letter month

MM: two-digit month

DD: two-digit day

hh: hour

mm: minute

ss: second

ms: millisecond

Note: The format parameters are case sensitive.

Re: Create new empty table in SAS ESP and store values from Source

LinusH — Fri, 21 Sep 2018 13:36:36 GMT

Ah, sorry.

if you are following the documentation thoroughly, try open a ticket to SAS tech support.