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

I have the following character variable. What is the best way to convert it to numeric?

Var1

05/15/2039

05/15/2038

05/15/2021

05/15/2020

07/02/2015

01/20/2015

11/20/2014

09/16/2014

09/15/2016

1 ACCEPTED SOLUTION

Accepted Solutions
Hima
Obsidian | Level 7

data have;
input var1 $10.;
cards;
05/15/2039
05/15/2038
05/15/2021
05/15/2020
07/02/2015
01/20/2015
11/20/2014
09/16/2014
09/15/2016
;
run;

data want;
set have;
format var2 mmddyy10.;
var2=input(var1,mmddyy10.);
run;

proc print; run;

proc contents data=want; run;

Capture.JPG

View solution in original post

2 REPLIES 2
LinusH
Tourmaline | Level 20

input() function using an appropriate date informat. See on-line doc on support.sas.com.

Data never sleeps
Hima
Obsidian | Level 7

data have;
input var1 $10.;
cards;
05/15/2039
05/15/2038
05/15/2021
05/15/2020
07/02/2015
01/20/2015
11/20/2014
09/16/2014
09/15/2016
;
run;

data want;
set have;
format var2 mmddyy10.;
var2=input(var1,mmddyy10.);
run;

proc print; run;

proc contents data=want; run;

Capture.JPG

sas-innovate-2024.png

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.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 356 views
  • 0 likes
  • 3 in conversation