topic Re: NotacoderHelp Please and thank you. Question on changing values of a variable for SAS Enterprise in New SAS User

Please and thank you.Question on changing values of a variable for SAS Enterprise 8.3

SAS_V_R — Wed, 31 Aug 2022 14:06:29 GMT

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

Re: Please and thank you.Question on changing values of a variable for SAS Enterprise 8.3

PaigeMiller — Wed, 31 Aug 2022 14:18:54 GMT

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.

NotacoderHelp Please and thank you. Question on changing values of a variable for SAS Enterprise 8.3

SAS_V_R — Wed, 31 Aug 2022 14:20:57 GMT

Thank you. I want to make the top look like the bottom. I am not coding. I do not know how to code.

Re: NotacoderHelp Please and thank you. Question on changing values of a variable for SAS Enterprise

SAS_V_R — Wed, 31 Aug 2022 14:28:09 GMT

You see? What do I add in Details? there is a syntax error.

Re: NotacoderHelp Please and thank you. Question on changing values of a variable for SAS Enterprise

PaigeMiller — Wed, 31 Aug 2022 14:31:57 GMT

I think someone else will need to help you here, as I don't use Enterprise Guide enough to give specific instructions.

Re: NotacoderHelp Please and thank you. Question on changing values of a variable for SAS Enterprise

ChrisHemedinger — Fri, 02 Sep 2022 11:45:20 GMT

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.