Pinnacle21 Community not extracting all datasets from SAS XPORT files

Sergiy

on July 6, 2022

P21

Please confirm that you have one dataset per XPT file

Hi Yihong, 

Please confirm that you have one dataset per XPT file.

Thank you,
Sergiy

yes, I put 30 xpt datasets…

yes, I put 30 xpt datasets in P21,and P21 only recognize 1 dataset.I found out this was caused by Chinese character in XPT dataset,could P21 use XPT dataset contain Chinese charcter to Create Excel Specification?

yes, I put 30 xpt datasets…

Did the chinese characters appear in the (minimal) metadata part (see the TS-140 specification of SAS-XPT) or in the clinical data part of the XPT files?
Once again a very nice demonstration that SAS Transport (as well version 5 as version 8) XPT was never designed for non-US-ASCII characters, and should already have been banned at least 10 years ago.
You can also try with other software offerings that generate a prototype define.xml and then allow to add/change/improve the metadata in a very user-friendly (GUI with wizards) way.
It is high time that regulatory authorities move to modern formats such as CDISC own's Dataset-XML or Dataset-JSON.

Sergiy

on July 7, 2022

P21

Hi Yihong,  So you have 30…

Hi Yihong, 

So you have 30 XPT files. Each of them includes only a single SAS dataset with the same name as a name of XPT file. For example, ae.xpt includes only ae dataset.

Is it SAS XPORT v5 or v8?

What Encoding do you use?

Thank you,
Sergiy

thank you both, I use UTF-8…

thank you both, I use UTF-8 encoding and upload new XPT , P21 can recognize 30 xpt datasets now.