BookmarkSubscribeRSS Feed
turcay
Lapis Lazuli | Level 10

Hello everyone,

 

I have a sample code as below, I try to see datetime27.6 format being a character format. I mean, I want to convert the format of variable but not convert view of variable.

 

Here is my sample code and desired output. Can somebody help me, please?

 

/*Sample data*/
Data Have;
Length Numeric 8;
Infile Datalines Missover;
Input Numeric ;
Format Numeric DATETIME27.6;
Datalines;
201001
201002
201003
201004
201005
201006
201007
201008
201009
201010
201011
201012
;
Run;

 

Numeric.png

Thank you,

2 REPLIES 2
BenbowL
Fluorite | Level 6

Hi turcay,

 

The put function should do this for you

 

Data Have;
Length Numeric 8;
Infile Datalines Missover;
Input Numeric ;
Format Numeric DATETIME27.6;
Datalines;
201001
201002
201003
201004
201005
201006
201007
201008
201009
201010
201011
201012
;
Run;

data want;
set have;
char = put(numeric,DATETIME27.6);
run;
ballardw
Super User

What value does this actually represent?  201001

From your displayed values, my first guess is that this is a 4-digit year and then a 2-digit month. What would you expect the displayed value to be?

 

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1868 views
  • 1 like
  • 3 in conversation