Hi, I have a problem using a date with monyy5 format.
I created the from a ddmmyy10. using this code:
FECHA2=put(fecha,monyy7.); /*FECHA2 is the original date variable with ddmmyy10. format*/ MES=input(fecha2,monyy7.); /*MES is my variable for an only month year date*/
format MES monyy5.; /*Format for my new date variable*/
After that, I have a variable that only has month and year, but my problem is when I want to do a select distinct. For example, for the original date variable has two dates in april: 10/04/2017 and 18/04/2017. The new variable shows apr17 for both obs. When I run a select distinct query, it should appear only 1 obs showing apr17 (the rest of the variables are the same), but this not happens... I think internally SAS keeps the day of the date?
How could I created a date variable that only has month and year? Thanks in advance!
... View more