topic Re: How to avoid name truncation with proc cport in SAS Programming

How to avoid name truncation with proc cport

RobP — Mon, 16 Jul 2018 15:45:47 GMT

I need to move my files from Windows -> Linux. Same version of SAS (9.4 TS1M5).

When I run proc cport, I am getting the message:

ERROR: The variable name wk_net7_start is illegal for the version 6 file DEST.DATES.DATA.
NOTE: Set the VALIDVARNAME=V6 option to enable automatic truncation of long variable names.

How can I prepare the files for transfer without any naming truncation?

Re: How to avoid name truncation with proc cport

ballardw — Mon, 16 Jul 2018 16:22:42 GMT

Do you have some actual SAS version 6 data sets? That is what the error implies. In those data sets variable names are limited to 8 characters. You may need to look at the definition of the libraries involved.

As a minimum it might not hurt to show the actual code along with the error from log.

Re: How to avoid name truncation with proc cport

RobP — Mon, 16 Jul 2018 16:33:56 GMT

Turns out the problem was with my code. I had:

proc cport library=source out=dest;
run;

... instead of...

proc cport library=source file=dest;
run;

Simple mistake to make (difficult to debug) as I previously was trying xport which uses the former convention.