05-22-2017 08:44 PM
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
05-22-2017 09:03 PM
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
05-22-2017 11:26 PM
@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).
05-23-2017 08:07 AM
9 Create table match_ayb as
10 Select a.*
12 From ayb_lu.lu_ayb as a
13 left join as ayb.AYB-WELLNESS CNPS_Q1 2017
ERROR 73-322: Expecting an ON.
I keep getting this error, maybe I'm missing where the on should be