Groups | Search | Server Info | Login | Register

Re: informat for "£12,345.67"

From	Sas-k <sashi1985@gmail.com>
Newsgroups	comp.soft-sys.sas
Subject	Re: informat for "£12,345.67"
Date	2011-06-11 04:00 -0700
Organization	http://groups.google.com
Message-ID	<19624d95-ffee-4d8c-b0c0-dd4d5ce01693@e14g2000yqa.googlegroups.com> (permalink)
References	<c3f18aa1-bac7-491d-b18f-d4dc3455fd44@d28g2000yqf.googlegroups.com> <3d21fc6f-1b1e-409c-9af9-1ca6de0bfcb6@b21g2000yqc.googlegroups.com> <921c76fe-e607-40a2-a8fb-18b04e675a0d@l6g2000vbn.googlegroups.com>

Show all headers | View raw

On Jun 10, 10:17 am, GuyA <guya.carpen...@gmail.com> wrote:
> On Jun 10, 1:52 am, Bruno Müller <bruno.muel...@gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > On Jun 9, 10:08 pm, GuyA <guya.carpen...@gmail.com> wrote:
>
> > > Very simple (and stupid) question:
>
> > > String as follows (includes quotes): "£12,345.67"
>
> > > What informat do I need to read that in from an external text file?
>
> > > Thanks.
>
> > Try code below, it uses the NLMNY informat together with the proper
> > language and region setting for LOCALE system option
>
> > options locale = en_gb;
> > data test;
> >   infile cards ;
> >   input
> >     number  nlmny20.
> >   ;
> >   putlog _all_;
> > cards;
> > £12,345.67
> > ;
>
> Thanks Bruno. I didn't know the nlmny informat. It worked exactly as
> desired. Many thanks.

Or you can run the following code without changing system option.
data test;
  infile cards ;
  input
    number  nlmnlgbp20.
  ;
  putlog _all_;
cards;
£12,345.67
;

Back to comp.soft-sys.sas | Previous | Next — Previous in thread | Find similar

Thread

informat for "£12,345.67" GuyA <guya.carpenter@gmail.com> - 2011-06-09 13:08 -0700
  Re: informat for "£12,345.67" Bruno Müller <bruno.mueller@gmail.com> - 2011-06-09 23:52 -0700
    Re: informat for "£12,345.67" GuyA <guya.carpenter@gmail.com> - 2011-06-10 07:17 -0700
      Re: informat for "£12,345.67" Sas-k <sashi1985@gmail.com> - 2011-06-11 04:00 -0700

csiph-web