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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.