Converting SAS DATASETS INTO XPT files for variable name length greater then 8

[rakeshvvv]

Hi,

I have to convert my sas datasets into Xpt files.

Some of the varaiblenames are greater then 8 like ABCEDFGH.

Can someone explain the way to convert those sas datasets into xpt

Thanks in advance

[LinusH]

First explain why do you want to create XPT-files?

There are other ways to migrate data between SAS hosts/versions that doesn't have the 8 char variable name restriction.

[rakeshvvv]

For FDA submission,

we need to submit the data XPT format only. Can you help if there is any way we could convert sas files to xpt files for variablename greater then 8..

[data_null__]

Are you sure that renaming a few variables is the only problem?  What about LABEL and char variable length. 

[rakeshvvv]

It is not about renaming variable.........XPT files were not able created quoting reason as varaiblename in sas datset is more then 8 characters in length........

[LinusH]

Well, you do need to rename variables if they are longer than 8 char. The same goes for format names, label length etc. You need to make your data V6 compliant.

[data_null__]

Well in order process the existing data with the XPORT engine you are doing to need to create a data set that has the proper V6 names.  You might get it to work by renaming the existing variables but that may not be the only problem.  You should probably spend some time with the SAS documentation concerting the XPORT engine and the restrictions associated with it.

[rakeshvvv]

The problem here is not renaming the variables.....our client has given few variable names(greater then 8 charactesr length). He is very parcticular about having only  those variablenames in final xpt file....he doent want the varaibles to be renamed........any way to do this............

[data_null__]

No.

[Kalyanker]

Hello,

If you had solved this, can I get code over here?

I also would like to convert my SAS data set to .XPT for FDA, please lemme know.

Thanks

[SASKiwi]

If you want to transport SAS datasets, containing variable names longer than 8 characters then you should check out the CPORT and CIMPORT procedures. These handle them fine.

Here is a good starting point: http://support.sas.com/documentation/cdl/en/movefile/63050/HTML/default/viewer.htm#p0p45wa0uwhgcan1e...