DATA Step, Macro, Functions and more

How to -> Convert Variable Format From Datetime to Character Without Changing View of Variable

Reply
Super Contributor
Posts: 381

How to -> Convert Variable Format From Datetime to Character Without Changing View of Variable

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,

Occasional Contributor
Posts: 7

Re: How to -> Convert Variable Format From Datetime to Character Without Changing View of Variab

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;
Super User
Posts: 10,538

Re: How to -> Convert Variable Format From Datetime to Character Without Changing View of Variab

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?

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 187 views
  • 1 like
  • 3 in conversation