SAS Transport v8's limit of 246 characters

[LECARROU]

Hi,

Thanks for this xport module.

It works but as mentionned SAS Transport v5 restricts variable names to 8 characters and labels to 40 characters.

I have files to build with label longer than 40... how can I proceed? tahns

[selik]

Can you get a free trial version of JMP? I think they'll let you try it for a month. It might allow writing XPT v9 format which permits longer variable labels.

[LECARROU]

I don’t know JMP, i will check Thanks for replying

Envoyé à partir de Courrierhttps://go.microsoft.com/fwlink/?LinkId=550986 pour Windows

De : Michael @.> Envoyé le :jeudi 23 septembre 2021 17:35 À : @.> Cc : @.>; @.> Objet :Re: [selik/xport] SAS Transport v8's limit of 246 characters (#69)

Can you get a free trial version of JMP? I think they'll let you try it for a month. It might allow writing XPT v9 format which permits longer variable labels.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/selik/xport/issues/69#issuecomment-925926964, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOZDOVG4IO2A4R4JUDAGMH3UDNCMNANCNFSM5ET6RVEA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[LECARROU]

I work in Public Health unit with Icon ; they want data to be sent in xpt format…

Envoyé à partir de Courrierhttps://go.microsoft.com/fwlink/?LinkId=550986 pour Windows

De : Mike @.> Envoyé le :jeudi 23 septembre 2021 17:32 À : @.> Cc : @.>; @.> Objet :Re: [selik/xport] SAS Transport v8's limit of 246 characters (#69)

You could try downloading a trial version of JMP and see if it can write XPT v9 format for you. I think they give a month free.

Also ... why? I've never understood the popularity of writing XPT files. This should be a dying format! Who are you sending data to?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/selik/xport/issues/69#issuecomment-925924920, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOZDOVDP5ZYXGE44FE2T5V3UDNCCTANCNFSM5ET6RVEA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[LECARROU]

Hi Michael,

I’ve opened SO question but maybe you can help me understand ? https://stackoverflow.com/questions/69347394/export-pandas-df-to-sas-xpt-xport-module-date-converted-to-string

thanks, Jérôme

Envoyé à partir de Courrierhttps://go.microsoft.com/fwlink/?LinkId=550986 pour Windows

De : Michael @.> Envoyé le :jeudi 23 septembre 2021 17:35 À : @.> Cc : @.>; @.> Objet :Re: [selik/xport] SAS Transport v8's limit of 246 characters (#69)

Can you get a free trial version of JMP? I think they'll let you try it for a month. It might allow writing XPT v9 format which permits longer variable labels.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/selik/xport/issues/69#issuecomment-925926964, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOZDOVG4IO2A4R4JUDAGMH3UDNCMNANCNFSM5ET6RVEA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[selik]

The issue is that date/time columns aren't appearing correctly? I'm not sure I understand. Could you open a new issue for this repository and paste the traceback?

[LECARROU]

Hi Michael,

Excuse me for delay… In fact, I close SO question as I found where comes my issue : numeric should be stored as 8 bytes max I confused with format lenght (19)

Thanks for your time Regards, Jérôme

Envoyé à partir de Courrierhttps://go.microsoft.com/fwlink/?LinkId=550986 pour Windows

De : Michael @.> Envoyé le :lundi 27 septembre 2021 22:15 À : @.> Cc : @.>; @.> Objet :Re: [selik/xport] SAS Transport v8's limit of 246 characters (#69)

The issue is that date/time columns aren't appearing correctly? I'm not sure I understand. Could you open a new issue for this repository and paste the traceback?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/selik/xport/issues/69#issuecomment-928235715, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOZDOVHQLS2KBKJ7BLSDHQLUEDGGLANCNFSM5ET6RVEA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.