Dear all,
I would like to import a SAS file (.xpt file) in Phoenix for NCA analysis by automatically importing the units. I know that this is possible with other file formats (.xls or.csv) but I don’t know if with an.xpt file it is possible to import the SAS labels directly to avoid manually entering them and thus remove a potential source of error.
Thanks for your help,
Best regards,
Séverine
Dear Severine,
If you have a SAS transport file in CDISC format (and a CDISC navigator license) you can do this via
Custom Import>CDISC SDTM Data or
Custom Import>CDISC SEND Data
Otherwise, I don’t know off hand of an easy way to import units directly into the Phoenix header labels from a SAS transport file. However, you can handle the units after importing the file in several ways. For example:
If you have a column that has the units, use a data wizard, transformation. You can assign the column that contains the units to a variable. This does create a bunch of new columns
Use data wizard, properties, and manually assign the units.
Maybe others know of others ways.
Ana
I’d like to expand on Ana’s suggestion, if your data has a separate column for the units then you can use Column properties to set the units for eg. PCORRES from the CONTENTS of another column e.g. PCORRESU, see attached image. Note I have also addded a filter afterwards to remove the now redundant PCORRESU.
Simon.
Thanks to both of you for your feedback,
I will actually ask to receive the units in a new column to specify them with the data wizard to avoid doing it manually.
Thanks,
Séverine
Hi, I am trying to import SAS .XPT file to winnonlin but its showing error. Do i need to follow extra step?
What is the error message? To be honest the best thing to do would be to email support@certara.com with the PHXPROJ file, error log and error message and versions of Phx and SAS being used,
