Desktop productivity for business analysts and programmers

Appending data

Reply
Occasional Contributor
Posts: 18

Appending data

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

 

 

Esteemed Advisor
Posts: 7,301

Re: Appending data

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#p02xs0q9ihz3k1n1jfm...

 

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

 

Art, CEO, AnalystFinder.com

Super User
Posts: 1,256

Re: Appending data

@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).

Occasional Contributor
Posts: 18

Re: Appending data

          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

Super User
Posts: 1,256

Re: Appending data

compare last line - you made some typos or changes.

Ask a Question
Discussion stats
  • 4 replies
  • 147 views
  • 1 like
  • 3 in conversation