Informat "05.02.2010 17:10"
in [SAS]
|
Prev: Titles and footnotes on every page using proc report and ods rtf
Next: Informat "05.02.2010 17:10"
From: "Data _null_;" on 5 Feb 2010 12:03 Interesting. Why doesn't it work for us. Do we need to change locale too? On 2/5/10, Joe Matise <snoopy369(a)gmail.com> wrote: > I'm guessing NLDATM is separate from datestyle (which I was thinking of, > yes), then, as the OP replied offlist that it worked. > > -Joe > > > On Fri, Feb 5, 2010 at 10:51 AM, Data _null_; <iebupdte(a)gmail.com> wrote: > > I believe the option you are referring to is datestyle. But it > > doesn't seem to help. I think the ANY informats should be renamed > > MAYBE or SOME. > > > > 7913 options DATESTYLE=DMY; > > 7914 data _null_; > > 7915 input dt & ANYDTDTM16.; > > 7916 put dt=datetime.; > > 7917 list; > > 7918 datalines; > > > > dt= > > RULE: ----+----1----+----2- > > 7919 05.02.2010 17:10 > > > > > > > > > > > > > > > > On 2/5/10, Joe Matise <snoopy369(a)gmail.com> wrote: > > > Try ANYDTDTM. > > > > > > data _null_; > > > informat dt ANYDTDTM.; > > > input @1 dt ANYDTDTM16.; > > > format dt DATETIME.; > > > put dt=; > > > datalines; > > > 05.02.2010 17:10 > > > ;;;; > > > run; > > > > > > This doesn't work properly on my machine as my PC interprets it as MDY, > not > > > DMY, but I believe that is an NLS setting and may work on your machine. > I > > > also don't know what informat it's actually using - if it's using > MDYAMPM > > > that might not work for DMY under any circumstance, but if it's using > some > > > variant of NLDATM it might work. > > > > > > -Joe > > > > > > On Fri, Feb 5, 2010 at 10:30 AM, <pohl(a)axis.de> wrote: > > > > > > > day-month-year-hour-minute > > > > > > > > HRH > > > > > > > > THX > > > > > > > > Stefan > > > > > > > > > > > > ------------------------------ > > > > > > > > *Von:* Joe Matise [mailto:snoopy369(a)gmail.com] > > > > *Gesendet:* Freitag, 5. Februar 2010 17:28 > > > > *An:* Pohl, Dr. Stefan > > > > *Cc:* SAS-L(a)listserv.uga.edu > > > > *Betreff:* Re: Informat "05.02.2010 17:10" > > > > > > > > > > > > > > > > Month-day-year or day-month-year? > > > > > > > > -Joe > > > > > > > > On Fri, Feb 5, 2010 at 10:11 AM, Dr. Stefan Pohl <pohl(a)axis.de> wrote: > > > > > > > > Dear list, > > > > > > > > > > > > > > > > Which datetime informat do I have to use in this case: > > > > > > > > > > > > > > > > 05.02.2010 17:10 > > > > > > > > > > > > > > > > Best regards > > > > > > > > > > > > > > > > Stefan > > > > > > > > > > > > > > > > > > >
From: "Pashi, Arthur" on 5 Feb 2010 12:14 Stephan, You may want to look at nls_ug_7618[1].pdf. The document is SAS 9.1 National Language Support (NLS) User's Guide (Ch. 8) from http://support.sas.com/dsearch?qt=SAS+informat+for+European+date+time&ct=&col=suppprd&nh=10&qp=&qc=suppsas&ws=1&qm=1&st=1&lk=1&rf=0&oq=&rq=0 For Germany/Deutschland, here are the equivalents of the English formats: DATETIME. EURDFDT. DDMMYY. EURDFDD. I hope you find the above helpful. Arthur K. Pashi -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Joe Matise Sent: Friday, February 05, 2010 10:54 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: Informat "05.02.2010 17:10" Copy the list - way more intelligent people than myself on the whole list :) I'd guess you're not using an NLS version of SAS, or a new enough version. What version are you using, and specifically what language configuration, both of SAS and your operating system? There are different language configurations (NLS), so you might be using a version not intended for UTF-8 character set or whatnot. Or it just doesn't work ... not my area of expertise certainly. -Joe On Fri, Feb 5, 2010 at 10:49 AM, <pohl(a)axis.de> wrote: > Works fine. > > > > But another problem: > > > > Her is my code snip: LAST_MODIFIED = input( finfo( fid , 'Ge�ndert am') , > ANYDTDTM16.); > > > > I have problems with the German "�". How can I read in correctly 'Ge�ndert > am'? > > > > THX > > > > Stefan > > > ------------------------------ > > *Von:* Joe Matise [mailto:snoopy369(a)gmail.com] > *Gesendet:* Freitag, 5. Februar 2010 17:41 > *An:* Pohl, Dr. Stefan; SAS-L(a)LISTSERV.UGA.EDU > > *Betreff:* Re: Informat "05.02.2010 17:10" > > > > Try ANYDTDTM. > > data _null_; > informat dt ANYDTDTM.; > input @1 dt ANYDTDTM16.; > format dt DATETIME.; > put dt=; > datalines; > 05.02.2010 17:10 > ;;;; > run; > > This doesn't work properly on my machine as my PC interprets it as MDY, not > DMY, but I believe that is an NLS setting and may work on your machine. I > also don't know what informat it's actually using - if it's using MDYAMPM > that might not work for DMY under any circumstance, but if it's using some > variant of NLDATM it might work. > > -Joe > > On Fri, Feb 5, 2010 at 10:30 AM, <pohl(a)axis.de> wrote: > > day-month-year-hour-minute > > HRH > > THX > > Stefan > > > ------------------------------ > > *Von:* Joe Matise [mailto:snoopy369(a)gmail.com] > *Gesendet:* Freitag, 5. Februar 2010 17:28 > *An:* Pohl, Dr. Stefan > *Cc:* SAS-L(a)listserv.uga.edu > *Betreff:* Re: Informat "05.02.2010 17:10" > > > > Month-day-year or day-month-year? > > -Joe > > On Fri, Feb 5, 2010 at 10:11 AM, Dr. Stefan Pohl <pohl(a)axis.de> wrote: > > Dear list, > > > > Which datetime informat do I have to use in this case: > > > > 05.02.2010 17:10 > > > > Best regards > > > > Stefan > > > > >
From: "Pashi, Arthur" on 5 Feb 2010 12:32 Stephan, From the same document (SAS 9.1 National Language Support, NLS), I have referred you to, you will find more detailed information in ch. 9. For example, it says EURDFDDw. format writes international date values in the form dd.mm.yy or dd.mm.yyyy Good luck, Arthur K. Pashi -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Dr. Stefan Pohl Sent: Friday, February 05, 2010 10:12 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Informat "05.02.2010 17:10" Dear list, Which datetime informat do I have to use in this case: 05.02.2010 17:10 Best regards Stefan
From: Joe Matise on 5 Feb 2010 12:44 Yep! options locale=de_de; data _null_; informat dt ANYDTDTM.; input @1 dt ANYDTDTM16.; format dt DATETIME.; put dt=; datalines; 05.02.2010 17:10 ;;;; run; dt=05FEB10:17:10:00 -Joe On Fri, Feb 5, 2010 at 11:03 AM, Data _null_; <iebupdte(a)gmail.com> wrote: > Interesting. Why doesn't it work for us. Do we need to change locale too? > > On 2/5/10, Joe Matise <snoopy369(a)gmail.com> wrote: > > I'm guessing NLDATM is separate from datestyle (which I was thinking of, > > yes), then, as the OP replied offlist that it worked. > > > > -Joe > > > > > > On Fri, Feb 5, 2010 at 10:51 AM, Data _null_; <iebupdte(a)gmail.com> > wrote: > > > I believe the option you are referring to is datestyle. But it > > > doesn't seem to help. I think the ANY informats should be renamed > > > MAYBE or SOME. > > > > > > 7913 options DATESTYLE=DMY; > > > 7914 data _null_; > > > 7915 input dt & ANYDTDTM16.; > > > 7916 put dt=datetime.; > > > 7917 list; > > > 7918 datalines; > > > > > > dt= > > > RULE: ----+----1----+----2- > > > 7919 05.02.2010 17:10 > > > > > > > > > > > > > > > > > > > > > > > > On 2/5/10, Joe Matise <snoopy369(a)gmail.com> wrote: > > > > Try ANYDTDTM. > > > > > > > > data _null_; > > > > informat dt ANYDTDTM.; > > > > input @1 dt ANYDTDTM16.; > > > > format dt DATETIME.; > > > > put dt=; > > > > datalines; > > > > 05.02.2010 17:10 > > > > ;;;; > > > > run; > > > > > > > > This doesn't work properly on my machine as my PC interprets it as > MDY, > > not > > > > DMY, but I believe that is an NLS setting and may work on your > machine. > > I > > > > also don't know what informat it's actually using - if it's using > > MDYAMPM > > > > that might not work for DMY under any circumstance, but if it's using > > some > > > > variant of NLDATM it might work. > > > > > > > > -Joe > > > > > > > > On Fri, Feb 5, 2010 at 10:30 AM, <pohl(a)axis.de> wrote: > > > > > > > > > day-month-year-hour-minute > > > > > > > > > > HRH > > > > > > > > > > THX > > > > > > > > > > Stefan > > > > > > > > > > > > > > > ------------------------------ > > > > > > > > > > *Von:* Joe Matise [mailto:snoopy369(a)gmail.com] > > > > > *Gesendet:* Freitag, 5. Februar 2010 17:28 > > > > > *An:* Pohl, Dr. Stefan > > > > > *Cc:* SAS-L(a)listserv.uga.edu > > > > > *Betreff:* Re: Informat "05.02.2010 17:10" > > > > > > > > > > > > > > > > > > > > Month-day-year or day-month-year? > > > > > > > > > > -Joe > > > > > > > > > > On Fri, Feb 5, 2010 at 10:11 AM, Dr. Stefan Pohl <pohl(a)axis.de> > wrote: > > > > > > > > > > Dear list, > > > > > > > > > > > > > > > > > > > > Which datetime informat do I have to use in this case: > > > > > > > > > > > > > > > > > > > > 05.02.2010 17:10 > > > > > > > > > > > > > > > > > > > > Best regards > > > > > > > > > > > > > > > > > > > > Stefan > > > > > > > > > > > > > > > > > > > > > > > > > > >
First
|
Prev
|
Pages: 1 2 Prev: Titles and footnotes on every page using proc report and ods rtf Next: Informat "05.02.2010 17:10" |