BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

hi guys.

When trying to convert this number x=123199  to a date using format date9. i get 4/22/97 but if i use the put + input functions i get different results :

x=123199 ;

xchar = put(x,z6.) ;

xdate = input (xchar, mmddyy6.) ;

format xdate date9. ;

so xdate=31/dec/99 in this case.

So how come?

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

Hi,

The string "123199" is read like the date 12/31/99 whereas the number 123199 is the number of days between 01JAN1960 and 22APR2297, which is the date you get when converting 123199 into a date.

PG

PG

View solution in original post

2 REPLIES 2
PGStats
Opal | Level 21

Hi,

The string "123199" is read like the date 12/31/99 whereas the number 123199 is the number of days between 01JAN1960 and 22APR2297, which is the date you get when converting 123199 into a date.

PG

PG
Tal
Pyrite | Level 9 Tal
Pyrite | Level 9

right right,did not think of it!

Thanks so much

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 720 views
  • 2 likes
  • 2 in conversation