Jump to content


Photo

Format G8 in exported output

export formatting

  • Please log in to reply
1 reply to this topic

#1 ltecrs

ltecrs

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 09 August 2019 - 06:27 PM

Is there any way to preserve the custom format G8 when exporting to CSV?

 

Barring that, is there any documentation around the format G8 so it could be replicated when pulling a Final Parameters file into SAS?

 

The 'Final Parameters' dataset from a NCA analysis I ran does not match the 'Final Parameters Pivoted' in terms of value formatting when exported (in either excel or csv). The former would be much more useful to pull into SAS, but seems to inappropriately add trailing zeroes on a number of estimates.

 

The pivoted values appear to maintain the formatting as displayed, but are much more difficult to work with.



#2 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,316 posts

Posted 10 August 2019 - 06:18 AM

Hi Liz, can you confirm the version of phoenix you are using and perhaps illustrate it with a project and exports you are obtaining. 

I just performed a simple export to CSV from 8.2, (I do not normally choose cell formatting but export the full precision values) and as you can see these both seem to match pivoted and unpivoted?

What is it you want to achieve?  Simon.







Also tagged with one or more of these keywords: export, formatting

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users