When I try to save a work.dataset as a sas.dataset I get the following warning message:
Multiple lengths were specified for the variable X by input data set(s). This can cause truncation of data.
The dataset (WIO) has 2467 columns (C, D, E etc.) and 36960 rows. IIOdat is the library.
Code:
%macro setlist;
%do i=2000 %to 2014;
WIO&i
%end;
%mend setlist;
data IIOdat.WIO;
set %setlist;
run;
Log:
58 %macro setlist;
59 %do i=2000 %to 2014;
60 WIO&i
61 %end;
62 %mend setlist;
63
64 data IIOdat.WIO;
65 set %setlist;
66 run;
WARNING: Multiple lengths were specified for the variable JU by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable OC by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable SK by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable UO by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable ABA by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AFI by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AJQ by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable ALU by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AQC by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AUG by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AWO by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable AYS by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BAW by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BFE by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BHI by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BJM by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BNI by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BNM by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BNU by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BSC by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable BWK by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable CHE by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable CJI by input data set(s). This can cause
truncation of data.
WARNING: Multiple lengths were specified for the variable CNL by input data set(s). This can cause
truncation of data.
NOTE: There were 2464 observations read from the data set WORK.WIO2000.
NOTE: There were 2464 observations read from the data set WORK.WIO2001.
NOTE: There were 2464 observations read from the data set WORK.WIO2002.
NOTE: There were 2464 observations read from the data set WORK.WIO2003.
NOTE: There were 2464 observations read from the data set WORK.WIO2004.
NOTE: There were 2464 observations read from the data set WORK.WIO2005.
NOTE: There were 2464 observations read from the data set WORK.WIO2006.
NOTE: There were 2464 observations read from the data set WORK.WIO2007.
NOTE: There were 2464 observations read from the data set WORK.WIO2008.
NOTE: There were 2464 observations read from the data set WORK.WIO2009.
NOTE: There were 2464 observations read from the data set WORK.WIO2010.
NOTE: There were 2464 observations read from the data set WORK.WIO2011.
NOTE: There were 2464 observations read from the data set WORK.WIO2012.
NOTE: There were 2464 observations read from the data set WORK.WIO2013.
NOTE: There were 2464 observations read from the data set WORK.WIO2014.
NOTE: The data set IIODAT.WIO has 36960 observations and 2467 variables.
NOTE: DATA statement used (Total process time):
real time 35.36 seconds
cpu time 11.51 seconds
What does this mean, and what can I do to fix it?
All help is very appreciated!!