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,
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;
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?
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.
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.