Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. libname DDWP_PLT teradata
  2. user='xxxx'
  3. password='xxxx'
  4. schema='DDWP_PLT_V'
  5. server='phxtdpd2cop1.directv.com'
  6. FASTEXPORT=YES;
  7.  
  8. PROC SQL;
  9. create table mob_base as
  10. select ctn
  11. , ban
  12. , intrxn_id
  13. , sasdate
  14. , start_time
  15. , sessionstarttime
  16. , agent_ID
  17. , work_group as agent_skill
  18. , tasktype
  19. , taskresolution
  20. , need
  21. , need2
  22. , need3
  23. , disposition
  24. , note
  25. from ddwp_plt.ATT_MOBILITY_CLARIFY_DTL_VW
  26. where start_time between '2016-12-29 00:00:00' and '2017-01-31 23:59:59'
  27. and start_time = sessionstarttime
  28. order by ctn
  29. , sessionstarttime
  30. ;
  31. QUIT;
  32.  
  33. format=date9.
  34. INPUT(CATS(t1.column),BEST.)
  35. Char = char X 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement