Prev: sas data xport problem
Next: how to caluculate time between two different hours?
From: Tom Abernathy on 26 Jan 2010 21:06
On Jan 26, 6:32 pm, brian_c_wall...(a)YAHOO.COM (Brian Wallace) wrote:
> Sorry I haven't been able to post recently.  The security at work is pretty strict.  I have a simple, I guess stupid, question.
> I always thought the maximum length for a character field in a SAS transport file was 200 characters.  Is this a correct statement?
> Also, if this true, can you get around this restriction by using PROC CPORT?
> I believe the answers to these questions are 'Yes' and 'No' respectively, but I defer to the knowledge of this forum.
> Thank you very much for any help or pointing me to a resource that assists me.
> Brian Wallace

Brian -

The version 5 transport format used by the XPORT libname engine does
have the a maximum character length of 200 as you say. It also does
not support long variable names. But the CPORT/CIMPORT procedures use
a new format (or many new formats as it seems to change with each
version of SAS) and so it will support long variable names and long
character variables.

- Tom
From: Andre Wielki on 27 Jan 2010 04:49
Brian

file issued from proc copy + libname ... XPORT ".....xpt" ;
are limited to the v6 rules 8 positions for variable names, 40 for
labels and 200 for char variables

BUT proc cport is used to pass from one system sas to another
and produce too a "transport" file
so the limits are linked ( i suppose as i never test a backward from v9
to v6)
to the rules of the travel and "Customs" at landing!

from v8.2 windows to v9.2.2 linux you may land with 32000 length for
a char field with a cport fly
and the key for a good opening of the pack is proc cimport!

Andre


Brian Wallace a �crit :
> Sorry I haven't been able to post recently. The security at work is pretty strict. I have a simple, I guess stupid, question.
>
> I always thought the maximum length for a character field in a SAS transport file was 200 characters. Is this a correct statement?
>
> Also, if this true, can you get around this restriction by using PROC CPORT?
>
> I believe the answers to these questions are 'Yes' and 'No' respectively, but I defer to the knowledge of this forum.
>
> Thank you very much for any help or pointing me to a resource that assists me.
>
> Brian Wallace
>
>

--
Andr� WIELKI
INED (Institut National d'Etudes D�mographiques)
Service Informatique
133 Boulevard Davout 75980 Paris Cedex 20
m�l : wielki(a)ined.fr t�l : 33 (0) 1 56 06 21 54
 | 
Pages: 1
Prev: sas data xport problem
Next: how to caluculate time between two different hours?