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

in my dataset i have dates which are like 

2005-09-16T13:30

2005-09-23

2005-09-30

 

in these i want to remove iso date and keep as yymmdd10. format.

i used the below code but

exstdtc1= input(exstdtc,yymmdd10.);

format exstdtc1 yymmdd10.;

I get the correct format but it is numeric. how to make it in character

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

You are probably better off leaving it numeric.  But you can make it character:

 

exstdtc1= put( input(exstdtc,yymmdd10.), yymmdd10.);

View solution in original post

1 REPLY 1
Astounding
PROC Star

You are probably better off leaving it numeric.  But you can make it character:

 

exstdtc1= put( input(exstdtc,yymmdd10.), yymmdd10.);

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 1 reply
  • 1193 views
  • 0 likes
  • 2 in conversation