topic Re: Note 484-185: Format YYYY was not found or could not be loaded in New SAS User

Note 484-185: Format YYYY was not found or could not be loaded

Toni2 — Tue, 22 Jun 2021 10:52:17 GMT

Hi, i would appreciate any help on this one

i am trying to format the year variable in the format YYYY using the below. However, when i run it i get the below note and i am not sure how i can fix it?

"NOTE 484-185: Format YYYY was not found or could not be loaded."

data ONS_y_pre;
set ONS_y_raw;
year1 = input(year,anydtdte32.);
format year1 yyyy4.;
run;

my data is :

Obs Year

2	1988
3	1989
4	1990
5	1991
6	1992
7	1993
8	1994
9	1995
10	1996
11	1997
12	1998
13	1999
14	2000
15	2001
16	2002
17	2003
18	2004
19	2005
20	2006
21	2007
22	2008
23	2009
24	2010

Re: Note 484-185: Format YYYY was not found or could not be loaded

Kurt_Bremser — Tue, 22 Jun 2021 10:58:18 GMT

If you need to convert a 4-digit string to a SAS date, do not use the ANY.... informat.

In fact, I always advise strongly against using these informats.

See this short code example:

data test;
year = "2021";
year1 = mdy(1,1,input(year,4.));
format year1 year4.;
run;

You can find other interesting date formats here.

Re: Note 484-185: Format YYYY was not found or could not be loaded

PaigeMiller — Tue, 22 Jun 2021 11:34:15 GMT

Your variable named YEAR is already displayed as a year, four digits, human readable. Do not format it.

Re: Note 484-185: Format YYYY was not found or could not be loaded

Toni2 — Tue, 22 Jun 2021 12:02:38 GMT

thanks for the response. Since i am new here could you please expand a little bit the code to apply this for the years 1987 to 2000?

Re: Note 484-185: Format YYYY was not found or could not be loaded

Kurt_Bremser — Tue, 22 Jun 2021 12:11:40 GMT

@Toni2 wrote:

thanks for the response. Since i am new here could you please expand a little bit the code to apply this for the years 1987 to 2000?

Just use my function call and FORMAT statement in your original code.

Re: Note 484-185: Format YYYY was not found or could not be loaded

Toni2 — Tue, 22 Jun 2021 12:23:14 GMT

oh! of course...thank you 🙂

Re: Note 484-185: Format YYYY was not found or could not be loaded

Toni2 — Tue, 22 Jun 2021 12:24:29 GMT

thanks for your response. The solution from @Kurt_Bremser worked for me