topic Re: Appending data in SAS Enterprise Guide

Appending data

Rsadiq1 — Tue, 23 May 2017 00:44:23 GMT

Hello

I am a new programmer and I need help with a task. I was given data (in excel)which I imported into sas, itcontains ayb id (which I need to match).I need to append that to another file(ICUE data), to see which member_id is associated with each ayb_id. I'm not sure how to go about this

Thanks alot

Re: Appending data

art297 — Tue, 23 May 2017 01:03:34 GMT

It can be done in a datastep. You can find step-by-step instructions at: http://support.sas.com/documentation/cdl/en/basess/68381/HTML/default/viewer.htm#p02xs0q9ihz3k1n1jfmzhy0sk1cw.htm

It can also be done, as a join, using PROC SQL

Art, CEO, AnalystFinder.com

Re: Appending data

Shmuel — Tue, 23 May 2017 03:26:45 GMT

@Rsadiq1 wrote: " I was given data (in excel)which I imported into sas, it contains ayb id (which I need to match).I need to append that to another file(ICUE data), to see which member_id is associated with each ayb_id."

You asked for appending data while actually you want to merge the two datasets by ayb_id.

If this is the case use SQL:

proc sql;
   create table want as 
   select a.*, b.*
   from ICUE as a
   full join XL as b
   on a.ayb_id = b.ayb_id;
quit;

XL is yout imported dataset from excel.

You need adapt libname.datasetname of the two tables to merge (join).

Re: Appending data

Rsadiq1 — Tue, 23 May 2017 12:07:10 GMT

          Proc sql;
9          Create table match_ayb as
10         Select a.*
11         ,b.*
12         From ayb_lu.lu_ayb as a
13         left join as ayb.AYB-WELLNESS CNPS_Q1 2017
                            _
                            73
                            76
ERROR 73-322: Expecting an ON.

I keep getting this error, maybe I'm missing where the on should be

Re: Appending data

Shmuel — Tue, 23 May 2017 12:10:30 GMT

compare last line - you made some typos or changes.