On Jun 13, 12:23=A0am, Bruce Weaver <bwea...@[EMAIL PROTECTED]
> wrote:
> On Jun 12, 5:39 am, "A.A.A" <ayaf...@[EMAIL PROTECTED]
> wrote:
>
> --- snip ---
>
>
>
>
>
> > And it works without errors but the problem is that I want to save
> > the
> > excel files so that the columns are with a certain order v1 then
> > @[EMAIL PROTECTED]
then @[EMAIL PROTECTED]
(these are the names of the columns)so
I=
put
> > after the save translate command
> > the "keep" command as follows:
>
> > SAVE TRANSLATE OUTFILE=3D!QUOTE(!concat('E:\simuldata1\', 'datag', !i,
> > '.xls'))
>
> > =A0 /TYPE=3DXLS /VERSION=3D8 /MAP /REPLACE /keep v1 =A0@[EMAIL PROTECTED]
@[EMAIL PROTECTED]
v3
> > v4 v5 =A0v6 V14_mean1 v7 V14_mean2 v8 V14_mean3 v9 V14_n.
>
> > But unfortunately the excel files were saved without the order of
> > columns I need: v1 then @[EMAIL PROTECTED]
then @[EMAIL PROTECTED]
where is
th=
e
> > problem??????????????????????????????
>
> > Great thanks
>
> Assuming there is no blank line in the middle of the SAVE TRANSLATE
> command, I don't see any obvious problems. =A0If you're not able to
> figure out why it's not working as expected, you could always use
> MATCH FILES (or ADD FILES) to rearrange the order of variables in the
> working data file (and delete unwanted variables) before writing out
> to Excel via SAVE TRANSLATE. =A0That would look something like this:
>
> match files file =3D * /
> =A0keep =3D v1 =A0@[EMAIL PROTECTED]
@[EMAIL PROTECTED]
v2 v3 v4 v5 =A0v6
> =A0 =A0 V14_mean1 v7 V14_mean2 v8 V14_mean3 v9 V14_n .
> exe.
>
> SAVE TRANSLATE
> =A0 OUTFILE=3D!QUOTE(!concat('E:\simuldata1\', 'datag', !i, '.xls')) /
> =A0 TYPE=3DXLS /VERSION=3D8 /MAP /REPLACE .
>
> By the way, when posting the same question to more than one group,
> please cross-post rather than doing separate posts to the different
> groups.
>
> HTH.
>
> --
> Bruce Weaver
> bwea...@[EMAIL PROTECTED]
> "When all else fails, RTFM."- Hide quoted text -
>
> - Show quoted text -
Hi,
The error was the space
Thank you for your help
|
