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: 
SNAG
‎02-01-2023
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: FIND VALUES FROM ANOTHER TABLE AND REPLACE

by Calcite | Level 5 in SAS Programming
‎02-01-2023 07:19 PM
‎02-01-2023 07:19 PM
What I mean is that this could change, for example: TABLE REGLAS: CVE_CONCEPTO | FORMULA 3                             | 1+2-4 6                             | (4+5)*2   And I want the same desired tables: CVE_CONCEPTO | FORMULA 3                             | 10+20-20 6                             | (20+50)*20 ... View more

Re: FIND VALUES FROM ANOTHER TABLE AND REPLACE

by Calcite | Level 5 in SAS Programming
‎02-01-2023 06:46 PM
‎02-01-2023 06:46 PM
It works, and I´m grateful. Just one last question, the + could change to any operator (+,-,*,/....); how could this be implemented? ... View more

Re: FIND VALUES FROM ANOTHER TABLE AND REPLACE

by Calcite | Level 5 in SAS Programming
‎02-01-2023 01:01 PM
‎02-01-2023 01:01 PM
I get another result, like this: CVE_CONCEPTO | FORMULA | NEW FORMULA | INDEX 3                             | 1+2            | 1+2                      | 3 6                             | 4+5            | 4+5                      | 3 1                             |                   |                             | 2 2                             |                   |                             | 2 4                             |                   |                             | 2 5                             |                   |                             | 2   The tables I do are an example, but the real one has 1,000 observations. You are right; in table REGLAS CVE_CONCEPTO is numeric, and FORMULA is char.   CVE_CONCEPTO | FORMULA 3                             | 1+2 6                             | 4+5 On the other hand in table INFO both are numeric. CVE_CONCEPTO | SALDO 1                             | 10 2                             | 20 3                             |  4                             | 20 5                             | 50 6                             |    So I don´t mind if in the desired result it gives me EX. 10+20 as a string that has been replaced or the value of that operation 30 CVE_CONCEPTO | FORMULA 3                             | 10+20 or 30 6                             | 20+50 or 70 ... View more

Re: FIND VALUES FROM ANOTHER TABLE AND REPLACE

by Calcite | Level 5 in SAS Programming
‎02-01-2023 12:12 PM
‎02-01-2023 12:12 PM
Yes, sorry for the first explanation. I´ve two tables REGLAS AND INFO, where I used the import wizard because they are XLSX. Table REGLAS is like this: CVE_CONCEPTO | FORMULA 3                             | 1+2 6                             | 4+5   Then I have INFO table like this: CVE_CONCEPTO | SALDO 1                             | 10 2                             | 20 3                             |  4                             | 20 5                             | 50 6                             |    Desired Result: CVE_CONCEPTO | FORMULA 3                             | 10+20 6                             | 20+50   I wish this is more clear, if not please let me know and I would try to explain it better   Thank you     ... View more

FIND VALUES FROM ANOTHER TABLE AND REPLACE

by Calcite | Level 5 in SAS Programming
‎02-01-2023 10:51 AM
‎02-01-2023 10:51 AM
I have used the import wizard, so now I have these tables: Reglas- Here, we have CVE_CONCEPTO and FORMULA, the last mentioned are the ones that I want to replace with the values in the other table. INFO-Here, we have CVE_CONCEPTO and SALDO, the last mentioned are the ones that would replace the FORMULA depending on the CVE_CONCEPTO.   But when I tried with this code, it only replaced the first value, not the ones after the + character. DATA want; SET Reglas; DO i=1 to _nobs; SET INFO nobs=_nobs point=i; IF findw(FORMULA,Strip(CVE_CONCEPTO)) THEN FORMULA=tranwrd(FORMULA,Strip(CVE_CONCEPTO),Strip(SALDO)); END; DROP CVE_CONCEPTO SALDO; RUN;   The result I´m looking for is the following: CVE_CONCEPTO| FORMULA 3 | 10+20 6 | 20+50   I´ll be very grateful if you could help me with this. Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-01-2023 09:32 PM
Quick links