topic Re: XPORT--"variable too long" in SAS Procedures

XPORT--"variable too long"

SuzyG_ — Mon, 07 Apr 2014 16:35:23 GMT

I'm getting the following error when reading in a dataset for XPORT:

ERROR: The character variable PARAMCD has too long a value for the XPORTOUT library.

I manually checked the incoming dataset, and the length of PARAMCD is $8. Is there something else that could be triggering this error?

It goes through CPORT just fine, but OpenCDISC will not recognize a .xpt file created by CPORT.

Thanks!

Suzy

Re: XPORT--"variable too long"

data_null__ — Mon, 07 Apr 2014 17:13:50 GMT

Check again. Run PROC CONTENTS and show the result here.

Re: XPORT--"variable too long"

SuzyG_ — Mon, 07 Apr 2014 17:58:23 GMT

data_null_;, you rock!! That's exactly it. The length is > 200, and only formatted to $8.

And I love the pic of your dog. My daughter has a beagle mix.

Thanks a million!

Suzy

Re: XPORT--"variable too long"

data_null__ — Mon, 07 Apr 2014 19:39:01 GMT

Glad you got it figured.

You might be interested in a program to re-size all your character variables. Here are a couple of choices

https://communities.sas.com/message/163032#163032

Merry Bell (rescued on Christmas day) is, according the the neighbor who called us about the stray dog she saw at her house, is a Red Bone Walker Hound Mix. Sort of a tall beagle.