when i merge 2 files i get:
WARNING: Multiple lengths were specified for the BY variable cusip by input data sets. This
might cause unexpected results.
i noticed that the fyear for two files are different.
file1: best12.
file2: 4.
how do i change one of the following, for ex: file2's 4. to best12.?
Issue is not format but the actual number of bytes used to store the variable in the two datasets.
If you run proc contents or examine the variables in the Explorer you will see that the LENGTH is different.
Without rebuilding the data sets generally a good approach would be to have the data set with the larger value for length first in a set or merge statement.
Or make a copy of the data set with the smaller value
data want;
length cusip 8; /* guessing the set with the larger value of length for cusip is 8 as that is a default for numeric*/
set file2; /* guessing this is the set with the smaller length*/
run;
and use want instead of file2.
If you change the order of the datasets this warning will desapear.
Also if you change the format before the "set" with format var BEST12. it will be solved too.
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 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: