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: 
i-cant-read
‎09-26-2022
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Check if the same variables from a column exist in anotes tables a...

by Calcite | Level 5 in SAS Programming
‎09-26-2022 11:28 AM
‎09-26-2022 11:28 AM
Come on, I'll try to gather the data here... For starters, my initial base (customers who bought in September 2021) has approximately 555,000 lines and the set of customers between October 2021 and August 2022 has 8 million lines divided between these months. First we have my acrdbase_mpr_exp base table with the September purchases. it has some fields that we don't have in the others, but the customer identification field (customer_Id) we will have in all of them. Only the date part needs attention as it is in DDMMYYYY format.         The customer tables in the following months are: WORK.ACRD_OCT21 WORK.ACRD_NOV21 WORK.ACRD_DEC21 WORK.ACRD_JAN22 WORK.ACRD_FEB22 WORK.ACRD_MAR22 WORK.ACRD_APR22 WORK.ACRD_MAY22 WORK.ACRD_JUN22 WORK.ACRD_JUL22 WORK.ACRD_AUG22  And they look like     I believe you just need to cross the customer Id of the September table with the same data in the others to identify if the same customers returned, but I would still need to check how many times this customer appears ... View more

Check if the same variables from a column exist in anotes tables and s...

by Calcite | Level 5 in SAS Programming
‎09-26-2022 09:19 AM
‎09-26-2022 09:19 AM
Hello friends!   First of all, I'm a newbie in the SAS world and I'm starting my journey recently, so sorry if I don't explain very well what I need, an thanks for all support.   I have a table with various customer purchase data, divided by month. What I need is to see if the customer_Id of the cost_set20 table appears in the subsequent tables (nov20, dec20, jan21, [...] aug21)   And then whenever it appears I need to mark in another table the client_id, the last month it appeared, and the number of times it appeared in the query that was made.   The truth is that I have no idea how to do this, I understand the logical sequence, but I wouldn't know how to assemble a query that would do this for me.I have a test coming soon for a job in the area and I wanted to get there by understanding how to do this. Thank you all ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-26-2022 08:10 PM
Quick links