topic Joining the datasets in New SAS User

Joining the datasets

Sandeep77 — Fri, 27 May 2022 10:21:31 GMT

Hi Experts,

I have exported a CSV file from a location to SAS and now I am adding some information from the database. But I am not able to link that CSV file information from the database. I am missing something to link the information. Can you please guide? Here is the import step:

Proc import
datafile='\\test2.local\shares\public\Trace\Full_manual_trace_book.csv'
out=Manual_trace_full
dbms=csv
replace;
run;

Then I run this code to add further information to the accounts in imported file

proc sql;
connect to oledb (provider=sqlncli11.1
properties = ("Integrated Security" = SSPI
"Persist Security Info" = False
"Initial Catalog" = pinsys
prompt = NO
"Data Source" = 'ELECTRA'
read_lock_type = no));
create table Manual_tracing as
select t2.debt_code,
t2.tran_code,
t2.td_altdescrn,
t2.td_stddescrn

from (select * from connection to oledb
(select
b.debt_code,
b.tran_code,
c.td_altdescrn,
c.td_stddescrn

from [Pinsys].[dbo].[debt_trans] as b
inner join [Pinsys].[dbo].[transdescrn] as c
on b.Tran_code = c.Tran_code
where b.tran_code in ('JO741','JO742',);)) as t2

order by t2.debt_code;
quit;

When I run the 2nd code, it takes the data from the database in thousands but my file just have few accounts. I am looking to add those extra information to those few accounts.

Re: Joining the datasets

LinusH — Tue, 31 May 2022 09:05:56 GMT

It's all about understanding the information and the data that you work with.

It's very hard for outsiders to chime in here.

Please try to connect with persons at your site that has insight in the data, and can help you specify the desired outcome of your work.

Re: Joining the datasets

Tom — Tue, 31 May 2022 10:22:43 GMT

Are you asking how to push the information you got from the CSV file back into the remote database?

Or perhaps you asking how to the extract some type of list of key identifiers from the CSV file and use that list to control which observations you pull from the remote database so that SAS does not try to pull all of the observations from the remote database?