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: 
Aldo_Leal
‎09-18-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

HOW TO MERGE WITH NO COMMON KEY IN DATABASE?

by Calcite | Level 5 in SAS Programming
‎09-10-2019 07:43 PM
‎09-10-2019 07:43 PM
Hello everybody, I have problems merging two the next information:   I have 9 tables with the next structure (CCF1-CCF9)   product   util_rank     due       credit_limit    CCF1 A                1               0                1           any value A                1               0                2 A                1               0                3 A                1               0                4 A                1               0                5 A                1               1                1           any value A                1               1                2 A                1               1                3 A                1               1                4 A                1               1                5 B                1               0                1           any value B                1               0                2 B                1               0                3 B                1               0                4 B                1               0                5       And so on with any combination of A, B, C or D products, the due can be from 0-4 and credit limit from 1-5 (adjoint at this question is the example of the table).   On the other side, I have a table (Credit_table) with the next information:   CTA_CVE       due     util_rank    credit_limit  10551212            2          1                2 56488971          1            0               3 65468447           2           4              4 ... I'm making a merge of the first table sorting it by due, util_rank and credit limit, and sorting the second one by the same variables and the merging them by the four keys, but I know there is a better way using arrays to merge that information.Here's my work so far:   DATA CRUCE_PD_CCF; MERGE CRUCE_PD_ord man2.CCF1_ord man2.CCF2_ord man2.CCF3_ord man2.CCF4_ord man2.CCF5_ord man2.CCF6_ord man2.CCF7_ord man2.CCF8_ord man2.CCF9_ord man2.CCF10_ord ; BY product Util_Rank Due Lim_Cred; IF A; RUN;   But I'm validating the information and there are no accts where there must be information of CCF.   What i'm doing wrong or how can I use arrays in order to be sure of the information is merging?   Thanks in regards!!   ... View more

HOW TO MERGE MULTIPLE DATABASES TO A COMMON DATABASE?

by Calcite | Level 5 in SAS Programming
‎09-06-2019 04:18 PM
‎09-06-2019 04:18 PM
Hello!   I've beeing build several databases in a macro as follows:   FUTURE_ORD_201601 FUTURE_ORD_201602 FUTURE_ORD_201603                .                .                . FUTURE_ORD_201903   I have created a table (ACCOUNT_NUMBER) that contains all the account numbers that are in common (it will be the key to be merged)   ACCOUNT_NUMBER 1 2 3 . . . 1894039183298219219   I'm mergin all the datasets as follows   DATA MERGE; MERGE ACCOUNT_NUMBER(IN=A);               FUTURE_ORD_:        (IN=B); BY ACCOUNT_NUMBER; IF A; RUN;   I wonder if I can include someway the FUTURE databases into the macre where is created in order to merge the FUTURE database in every single step and let fix the ACCOUNT_NUMBER database as pivot for the merging.   This is what I've beeing doing so far:   proc sql; create table future as account_number from DATABASE; RUN; %MACRO FUTURE(VAR1,VAR2,VAR3); creation of the database; order of every single database created into the macro with the name FUTURE_ORD_&DATE. %MEND; DATA MERGE; MERGE future (IN=A); FUTURE_ORD_;(IN=C); by account_number; if A; run; I want to make the merge inside the macro and be sure that in every single step the merge is beeing doing in propper order.   Thanks in regards!!   ... View more

Re: HOW TO OBSERVE IF A STRING CONTAINS ONLY CERTAIN CHARACTERS?

by Calcite | Level 5 in SAS Programming
‎09-06-2019 12:15 PM
‎09-06-2019 12:15 PM
Hello!!   Thanks for the effor but is not doing what I want, actually it checked everything in 1 even if there is no info in the database. Let me put some examples:   ACCT                        ACCT_HIST_PAYMET               HIST_PAYMENT_201803 10000000523959      543232212100000000000000     10000000654614      543211321654321000000000   999999999998765000000000 10000004621718      544322111118777000000000    10000004650329      544433221221113000000000   321212221111111000000000 10000005537491      543211232122112211212221    100112112213221121321176   NOTE: the last customer is complete CURED. NOTE: any historical payment it should be read from left to right meaning the first character represent the actual momento and from left to right the second represents the last month and so on.   The first coulmn represents the actual account number of the customer, the second column represent the historical behavior of payments which is 24 length and character and its view at 201603, the third column explains the historical behavior of payment at March201803 (I have every single historical payment for every month starting in March2016).   The third column can be missing meaning the customer is not longer (or at that time) alive or active in my database.   If I create a substring for hist_payment201803 I obtain: '321212221111' and I can conclude that this customer is not cured, because in the first number (which explains the behavior payment of March2018) is 3, so this customer is not cured.   The verify option, or the countc option only finds the exact chain of '012' but what I really want is to verify is of the substring chain contain any kind of combination of 0 or 1 or 2, e.g.:   '000000000000'----> This customer is cured '000000000001'----> This customer is cured '000021000110'----> This customer is cured '111111111111'----> This customer is cured '222222222222'----> This customer is cured '012012012012'----> Thus customer is cured '322122111111'----> THIS CUSTOMER IS NOT CURED because it contains a 3 and the substring can only contains 0 or 1 or 2, but with your example you're only looking for the exact chain of '012'.   May I please have any other idea?   If my explain is not complete please tell me.   I do appreciate your help!!! ... View more

Re: HOW TO OBSERVE IF A STRING CONTAINS ONLY CERTAIN CHARACTERS?

by Calcite | Level 5 in SAS Programming
‎09-06-2019 12:14 PM
‎09-06-2019 12:14 PM
Hello!!   Thanks for the effor but is not doing what I want, actually it checked everything in 1 even if there is no info in the database. Let me put some examples:   ACCT                        ACCT_HIST_PAYMET               HIST_PAYMENT_201803 10000000523959      543232212100000000000000     10000000654614      543211321654321000000000   999999999998765000000000 10000004621718      544322111118777000000000    10000004650329      544433221221113000000000   321212221111111000000000 10000005537491      543211232122112211212221    100112112213221121321176   NOTE: the last customer is complete CURED. NOTE: any historical payment it should be read from left to right meaning the first character represent the actual momento and from left to right the second represents the last month and so on.   The first coulmn represents the actual account number of the customer, the second column represent the historical behavior of payments which is 24 length and character and its view at 201603, the third column explains the historical behavior of payment at March201803 (I have every single historical payment for every month starting in March2016).   The third column can be missing meaning the customer is not longer (or at that time) alive or active in my database.   If I create a substring for hist_payment201803 I obtain: '321212221111' and I can conclude that this customer is not cured, because in the first number (which explains the behavior payment of March2018) is 3, so this customer is not cured.   The verify option, or the countc option only finds the exact chain of '012' but what I really want is to verify is of the substring chain contain any kind of combination of 0 or 1 or 2, e.g.:   '000000000000'----> This customer is cured '000000000001'----> This customer is cured '000021000110'----> This customer is cured '111111111111'----> This customer is cured '222222222222'----> This customer is cured '012012012012'----> Thus customer is cured '322122111111'----> THIS CUSTOMER IS NOT CURED because it contains a 3 and the substring can only contains 0 or 1 or 2, but with your example you're only looking for the exact chain of '012'.   May I please have any other idea?   If my explain is not complete please tell me.   I do appreciate your help!!! ... View more

HOW TO OBSERVE IF A STRING CONTAINS ONLY CERTAIN CHARACTERS?

by Calcite | Level 5 in SAS Programming
‎09-05-2019 07:42 PM
‎09-05-2019 07:42 PM
Good afternoon.   I have the next 24 lentgh string like this:   hist_payment='012212201223456789999999'   Where every character represents the past due number for every single month, so the first number represents the most recent month and their past due number asociated to the number.   I have to define if a customer has been cured, and a cured customer is the one who has only 0, 1 or 2 in the first 12 characters (months) of the hist_payment string.   This is my work so far:   if input(first(compress('9876543210',substr(HIST_PAYMENT,1,12),'k')),15.) <3 then flag_cure=1; else flag_cure=0; But is not working at all.   What I exactly need is to obeserve if the first 12 substring contains ONLY 0, 1 or 2, if this true then I can create the flag_cured as 1, otherwise the flag_cured is zero.   Please help, I've beeing trying to solve this problem for a long time. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-18-2019 02:56 PM
Quick links