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

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

turcay — Mon, 14 Nov 2016 14:34:00 GMT

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;

Thank you,

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

BenbowL — Mon, 14 Nov 2016 16:28:32 GMT

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;

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

ballardw — Wed, 16 Nov 2016 22:18:19 GMT

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?