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
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
@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).
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
compare last line - you made some typos or changes.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.