topic Re: Converting SAS DATASETS INTO XPT files for variable name length greater then 8 in SAS Procedures

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

rakeshvvv — Mon, 25 Mar 2013 20:27:38 GMT

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

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

LinusH — Mon, 25 Mar 2013 21:16:05 GMT

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.

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

rakeshvvv — Tue, 26 Mar 2013 12:49:08 GMT

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..

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

data_null__ — Tue, 26 Mar 2013 13:02:29 GMT

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

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

rakeshvvv — Tue, 26 Mar 2013 13:06:20 GMT

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........

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

LinusH — Tue, 26 Mar 2013 13:15:25 GMT

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.

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

data_null__ — Tue, 26 Mar 2013 13:16:13 GMT

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.

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

rakeshvvv — Tue, 26 Mar 2013 13:24:34 GMT

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............

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

data_null__ — Tue, 26 Mar 2013 13:27:34 GMT

No.

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

SASKiwi — Tue, 26 Mar 2013 23:14:26 GMT

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#p0p45wa0uwhgcan1e6xwi9jy53j6.htm

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

Kalyanker — Thu, 01 Dec 2016 15:30:24 GMT

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