Put it in as a code node (File | New | Program), link the output dataset from your "Split Columns" to it, and replace the dataset name "have" with the name of the dataset created by your split columns. Tom ... View more

You might be running into this issue: http://support.sas.com/kb/36/656.html Chris ... View more

Thanks Scott. It worked perfectly. ... View more

Try in step 2 of the import wizard "Rename columns to comply with SAS naming conventions". That should resolve the issue. ... View more

Yes - the OP posted a reply in a different FORUM - see link below: http://support.sas.com/forums/message.jspa?messageID=32511 Scott Barry SBBWorks, Inc. ... View more

FYI I was able to solve my own problem. Here is my solution to the problem. I am posting it so that others can use it if they need it. libname lib1 odbc DATASRC=server USER=userID PASSWORD="&dbpass" readbuff=1000 schema='dbo' ; libname lib2 odbc DATASRC=server USER=userID PASSWORD="&dbpass" readbuff=1000 schema='Floro' ; libname lib3 (lib1 lib2); libname lib1 clear; libname lib2 clear; ... View more