Date:         Wed, 27 Jan 2010 09:58:13 +0100
Reply-To:     Andre Wielki <wielki@INED.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andre Wielki <wielki@INED.FR>
Subject:      Re: sas data xport problem
Comments: To: Arthur Tabachneck <art297@NETSCAPE.NET>
In-Reply-To:  <201001270200.o0QM6pNS005228@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

from documentation
The UPLOAD and DOWNLOAD procedures in SAS/CONNECT and PROC COPY with the
XPORT engine are the only strategies available for regressing a data set
to SAS 6.

In order to transport SAS 9 and SAS 8 files back to SAS 6, set the
portable VALIDVARNAME system option to the value V6 in the SAS session
in which you are transporting the file.

so use

options validvarname=v7;
Data class;
set sashelp.class;
accession_no=1;
run;
options validvarname=v6;
libname out xport 'd:/temp/outdata.xpt';
proc copy in=work out=out;select class;
run;

HTH
Andre



Arthur Tabachneck a écrit :
> Orange,
>
> While I really don't know, I would at least suggest that you change the
> second line to read:
>
> libname in 'c:/home;
>
> And, if you are really running version 6, long variable names (over 8
> characters) aren't allowed.
>
> Art
> --------
> On Tue, 26 Jan 2010 20:49:52 -0500, help ly <help.ly2005@GMAIL.COM> wrote:
>
>
>> Hi Everyone,
>>
>> I am trying to convert a current sas data file to the xpt format, which I
>> can work with R.  However, I tried many times with some modifications on
>>
> the
>
>> code, without any success. The error message I am getting is:
>> *" ERROR: The variable name accession_no is illegal for the version 6 file
>> OUT.OUTDATA.DATA."*
>>
>> Here is my sas code:
>>
>>
>> libname out xport 'c:/home/outdata.xpt';
>> libname in 'c:home;
>> data out.outdata;
>>   set in.indata;
>> run;
>>
>>
>> Anyone see what's the problem?  Thanks a million for help!
>>
>> --
>> Thanks so much!
>>
>> Orange
>> help.ly2005@gmail.com
>>
>
>

--
   André WIELKI
   INED (Institut National d'Etudes Démographiques)
   Service Informatique
   133 Boulevard Davout      75980 Paris Cedex 20
   mél : wielki@ined.fr      tél :  33 (0) 1 56 06 21 54