how to change variable format

Reply
Frequent Contributor
Posts: 102

how to change variable format

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.?

Super User
Posts: 11,343

Re: how to change variable format

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.

Frequent Contributor
Posts: 144

Re: how to change variable format

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.

Ask a Question
Discussion stats
  • 2 replies
  • 224 views
  • 0 likes
  • 3 in conversation