while merging data i got following error, can anyone look at it and tell me how to deal with it.
This message is telling you that COMPANY is part of both data sets that you are merging. However, it has a different length in the two data sets. You would need to examine the length (probably running PROC CONTENTS on both data sets), select the longer length, and use that to define COMPANY. You would do that by adding this sort of statement (using the longer length rather than 20):
length company $ 20;
It has to go BEFORE the MERGE statement.
This message is telling you that COMPANY is part of both data sets that you are merging. However, it has a different length in the two data sets. You would need to examine the length (probably running PROC CONTENTS on both data sets), select the longer length, and use that to define COMPANY. You would do that by adding this sort of statement (using the longer length rather than 20):
length company $ 20;
It has to go BEFORE the MERGE statement.
Or if the first dataset in the merge statement (E1 in your case) has company with the longer length, it will prevail.
In general the first encounter with a variable establishes its attributes (length, format, label), while the last encounter establishes the value.
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.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.