cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Bharat_P
‎01-23-2020
  • 8 Posts
  • 14 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: case when when applying in hash object

by Fluorite | Level 6 in New SAS User
‎01-20-2020 06:05 AM
‎01-20-2020 06:05 AM
Actually the msg got misinterpreted.Sorry for that. My task is to convert this code to hash object from SQL. This code is running fine but my job is to look for ways to convert the codes into hash objects ... View more

case when when applying in hash object

by Fluorite | Level 6 in New SAS User
‎01-20-2020 01:27 AM
‎01-20-2020 01:27 AM
proc so; create table sample as select make ,type ,count(case when flag="euro" then MEET end) as Euro ,sum(case when flag="euro" then Invoice end) as Done from help.cars group by 1,2 ; quit; need to convert this to hash coding. if someone can help the it will be great( writing sql as so, sashelp as help,msrp as Meet as I am not being able to paste codes which are grammatically incorrect. ... View more

Re: SQL JOINS TO HASH OBJECT WITH MULTIPLE CONDITIONS

by Fluorite | Level 6 in SAS Programming
‎01-14-2020 04:56 AM
1 Like
‎01-14-2020 04:56 AM
1 Like
You guys are unbelievably helpful. You guys make our worklife so easy.. thank you from the bottom of my heart ... View more

SQL JOINS TO HASH OBJECT WITH MULTIPLE CONDITIONS

by Fluorite | Level 6 in SAS Programming
‎01-14-2020 03:51 AM
‎01-14-2020 03:51 AM
proc sql; create table temp as select A.CNCPT_NM , A.TRRTRY_SHRT_NM , A.LMG_MEM_CARD_NUMBER , case when missing(B.REVENUE) then 'CHURN' end as FLG from PREV_CUST_LST A left join CURR_CUST_LST B on A.CNCPT_NM=B.CNCPT_NM and A.TRRTRY_SHRT_NM=B.TRRTRY_SHRT_NM and A.LMG_MEM_CARD_NUMBER=B.LMG_MEM_CARD_NUMBER ; create table CHURN_CUST as select CNCPT_NM , TRRTRY_SHRT_NM , count(case when FLG='CHURN' then LMG_MEM_CARD_NUMBER end) as CHURN_CUST from temp group by 1,2 ; quit; I have the basic idea of how hash coding works but struggling to resolve this with the case when missing part. ... View more

Re: Joining multiple table with the help of hash object

by Fluorite | Level 6 in SAS Programming
‎01-03-2020 01:03 AM
‎01-03-2020 01:03 AM
they are all one to one and I want to restrict the output table to join that have a match. And there are duplicate values in the key (CNCPT_NM/TRRTRY_SHRT_NM) ... View more

Joining multiple table with the help of hash object

by Fluorite | Level 6 in SAS Programming
‎01-02-2020 01:29 AM
‎01-02-2020 01:29 AM
proc sql; create table SUMM7_DIGITAL_CUST as select M.CNCPT_NM , M.TRRTRY_SHRT_NM , (C.APPDWLD_CUST/M.CUST_CY) as APPDWLD_CUST_PER_CY format=percent8.2 , (L.APPDWLD_CUST/M.CUST_LY) as APPDWLD_CUST_PER_LY format=percent8.2 , (calculated APPDWLD_CUST_PER_CY - calculated APPDWLD_CUST_PER_LY) as APPDWLD_CUST_PP_CHNG , (C.APPACTV_CUST/M.CUST_CY) as APPACTV_CUST_PER_CY format=percent8.2 , (L.APPACTV_CUST/M.CUST_LY) as APPACTV_CUST_PER_LY format=percent8.2 , (calculated APPACTV_CUST_PER_CY - calculated APPACTV_CUST_PER_LY) as APPACTV_CUST_PP_CHNG from SUMM1_REV_TREE M left join APP_DWLD_ACTV_CUST_CY C on M.CNCPT_NM=C.CNCPT_NM and M.TRRTRY_SHRT_NM=C.TRRTRY_SHRT_NM left join APP_DWLD_ACTV_CUST_LY L on M.CNCPT_NM=L.CNCPT_NM and M.TRRTRY_SHRT_NM=L.TRRTRY_SHRT_NM order by 1,2 ; quit;   this table needs to be converted to hash table to cut the runtime. Can someone please help me with the hash table version of the codes mentioned above  ... View more

Re: how to use hash object for data integration & data aggregation

by Fluorite | Level 6 in SAS Programming
‎12-31-2019 12:14 AM
‎12-31-2019 12:14 AM
Forget the integration part I wrote.I want to join the same tables with hash objects. The code I shared is a part of many such joining I want to do with Hash coding. If I get a solution for this then based on this code I can manage to do the other joining as well. If you or anyone can manage to help me..it will be great   ... View more

how to use hash object for data integration & data aggregation

by Fluorite | Level 6 in SAS Programming
‎12-30-2019 06:18 AM
‎12-30-2019 06:18 AM
proc sql; create table SUMM3_REPEAT_CUST as select M.CNCPT_NM , M.TRRTRY_SHRT_NM , (C.REPEAT_CUST/M.CUST_CY) as REPEAT_CUST_PER_CY format=percent8.2 , (L.REPEAT_CUST/M.CUST_LY) as REPEAT_CUST_PER_LY format=percent8.2 , (calculated REPEAT_CUST_PER_CY - calculated REPEAT_CUST_PER_LY) as REPEAT_CUST_PP_CHNG , (C.REPEAT_CUST_REV/M.REV_CY) as REPEAT_CUST_REV_PER_CY format=percent8.2 , (L.REPEAT_CUST_REV/M.REV_LY) as REPEAT_CUST_REV_PER_LY format=percent8.2 , (calculated REPEAT_CUST_REV_PER_CY - calculated REPEAT_CUST_REV_PER_LY) as REPEAT_CUST_REV_PP_CHNG from SUMM1_REV_TREE M left join REPEAT_CUST_CY C on M.CNCPT_NM=C.CNCPT_NM and M.TRRTRY_SHRT_NM=C.TRRTRY_SHRT_NM left join REPEAT_CUST_LY L on M.CNCPT_NM=L.CNCPT_NM and M.TRRTRY_SHRT_NM=L.TRRTRY_SHRT_NM order by 1,2 ; quit;   This is a sample code which I want to covert to hash objects but due to few study materials available online regarding Hash coding. I'm not being able to find a solutaion. someone please help me out ASAP ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-23-2020 10:50 AM
Likes given to
View All
Likes from
View All
Quick links