I have a variable called SCHOOL_YEAR--IT has a calendar and a clock on it, the closest way I can describe it is that it is numerical--NOT text. This variable normally looks like the bottom where it is just years. The variable character below is #. can you help me? thanks.
but I need to make it look like years
If I am understanding the question properly, you want to make the variable SCHOOL_YEAR show only the year and not the month, day or time.
All you have to do is assign it a different format. In code you could use
format school_year dtyear.;
or in the Enterprise Guide GUI, you can open the properties for SCHOOL_YEAR and assign the format DTYEAR. in the properties dialog box.
Thank you. I want to make the top look like the bottom. I am not coding. I do not know how to code.
You see? What do I add in Details? there is a syntax error.
Can you share the syntax error to here? From the little screenshot you shared it looks like you are in the Query Builder, and to me it looks like you did the right thing by applying the DTYEAR format. Perhaps something else needs attention.
I think someone else will need to help you here, as I don't use Enterprise Guide enough to give specific instructions.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.