reading a date coloum

[Aexor]

How can i read the given updated (date) coloum?

id  name salary updated

1 John   35000.00   2018-05-01
2 Peter  42000.00   2019-04-01
3 Peter  54000.00   2017-01-22
4 Sam   58000.00   2018-01-01
5 John   62000.00    2016-01-01

Thanks!

[AMSAS]

You need to use an informat

data have;
	input id $ name $ amount date : yymmdd10. ;
	put id= name= amount= date= date=date7. ;
datalines;
1 John   35000.00   2018-05-01
2 Peter  42000.00   2019-04-01
3 Peter  54000.00   2017-01-22
4 Sam   58000.00   2018-01-01
5 John   62000.00    2016-01-01
;

[ballardw · Accepted solution]

data example;
   input id  name $ salary updated :yymmdd10.;
   format updated yymmdd10.;
datalines;
1 John   35000.00   2018-05-01
2 Peter  42000.00   2019-04-01
3 Peter  54000.00   2017-01-22
4 Sam   58000.00   2018-01-01
5 John   62000.00    2016-01-01
;

The Informat you should use is yymmdd10. That creates a SAS date value which for people to understand should have a date type format assigned of which there are many.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/... has a PDF with much information about dates.