I have SAS Enterprise Guide 3.4. I am trying to change the date format to 1/1/2013. Every format I pick the results are ********. Is there another place to change the date format to 1/1/2013 - MMDDYYYYY
Sometimes the ******** shows up because the display columns are to narrow to display the 10 characters of the formatted result. If you can create a wider column to display the values that could correct the issue. You don't mention where you are seeing this so only a guess.
The column is wide enough. I am in the query builder and I click on a date field and it gives me the option to change format. Presently, there is nothing in the format and the results show 01MAR2013:00:00:00. I want to show 3/1/2013 but when I choose one of the other date formats, all I get is ****** no matter how big the column.
You have a date time variable, not a date variable.
You need a format such as dtdate9. or dtmmddyy10. to show the date.
dtmmddyy10 is not one of the options in the dropdown list under the date time
Here are some to try on for size:
IS8601DN10.
MDYAMPM27.
DTDATE9.
Beyond that, you have more date-related formatting options with a DATE variable, which you can get by running the data through Query Builder and calculate a new column with the DATEPART() function.
Chris
I did finally use a calculated column - put(datepart(cl_eff_frm_dt), mmddyy10.)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.