After importing a SAS transport file (.xpt) into Phoenix, I like to use the Edit in Excel feature to quickly and easily filter the data by subject and inspect the data before conducting the NCA. For example, I filter the data to identify subjects who vomited and then flag their concentrations. When I am finished changing flags from 1 to 0 for exclusion, I click save and apply the changes to the Phoenix worksheet. I have noticed that this results in some columns being dropped from the worksheet and I don’t understand why this happens. I would really like to use the Edit in Excel feature to identify subjects/concentrations with issues, but it is too much of a risk to lose columns from my original dataset. Has this been encountered before? Thanks for any help you can offer!
Hi Shyeilla, Without seeing your dataset/project it’s hard to say for sure but you may have encountered a defect that will be fixed in the 1.4 release that you should see next month 13238 Tables with more than 26 columns can lose columns when using edit in excel HOWEVER my feeling is I wouldn’t use edit in excel anyway, it’s very easy to make errors and hard to track what they might be, as well as not being part of the refreshable Phoenix workflow. If you can post an example source dataset (XPT) and describe what you want to achieve., I am sure that we can propose workflow steps to achieve same -with Split Worksheet, DataWizard filters etc. (even ad hoc flag can be done by using the custom select option and at least it is trackable). Additionally it would be good if you could forward the actual project exhibiting this issue to Support@pharsight.com so we can confirm whether the issue above is the cause or there is some other problem. Best regards, Simon.