topic Re: 2 Tables - Need to update 1 with values from another in SAS Programming

2 Tables - Need to update 1 with values from another

Jyuen204 — Thu, 17 Sep 2020 13:18:06 GMT

I have 2 tables
Table 1 has data that will get refreshed daily so 1 day could have 3 records, next day could have 5

Table 2 has 250 static values

I want to update Table 1 with a value for each row from Table 2. Table 2 has no matching value to Table 1. I just want to assign one of the values to each record in Table 1

Re: 2 Tables - Need to update 1 with values from another

PaigeMiller — Thu, 17 Sep 2020 13:57:07 GMT

Can you give us a small example so we can see what you want?

Re: 2 Tables - Need to update 1 with values from another

ballardw — Thu, 17 Sep 2020 14:24:54 GMT

@Jyuen204 wrote:

I have 2 tables
Table 1 has data that will get refreshed daily so 1 day could have 3 records, next day could have 5

Table 2 has 250 static values

I want to update Table 1 with a value for each row from Table 2. Table 2 has no matching value to Table 1. I just want to assign one of the values to each record in Table 1

Do you want some random value from table 2? Any value? Does it have to be the same or forced to be different on day 2 than on day 1?

Does each row of set 1 get the same or do the values from table 2 have to be different?

You might describe what the value of this added variable might have if there isn't a match and you don't seem to care what the value added might be.

Re: 2 Tables - Need to update 1 with values from another

Jyuen204 — Thu, 17 Sep 2020 14:30:26 GMT

Here is an example. So Table1 is the daily list of records that can vary day to day. This example has 3 records (Cust1, Cust2, Cust3). I want to assign a value from Table2.CODES to Table1.CODES.

data table1;
Length CustID $5;
input CustID $ CODES;
datalines;
Cust1
Cust2
Cust3
run;

data table2;
input CODES;
cards;
123
456
789
101
111
121
run;