Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- libname DDWP_PLT teradata
- user='xxxx'
- password='xxxx'
- schema='DDWP_PLT_V'
- server='phxtdpd2cop1.directv.com'
- FASTEXPORT=YES;
- PROC SQL;
- create table mob_base as
- select ctn
- , ban
- , intrxn_id
- , sasdate
- , start_time
- , sessionstarttime
- , agent_ID
- , work_group as agent_skill
- , tasktype
- , taskresolution
- , need
- , need2
- , need3
- , disposition
- , note
- from ddwp_plt.ATT_MOBILITY_CLARIFY_DTL_VW
- where start_time between '2016-12-29 00:00:00' and '2017-01-31 23:59:59'
- and start_time = sessionstarttime
- order by ctn
- , sessionstarttime
- ;
- QUIT;
- format=date9.
- INPUT(CATS(t1.column),BEST.)
- Char = char X 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement