Thanks! Will keep it in mind.   I fixed the things everyone mentioned above and changed "to_chat" since its used only in SQL app, not in SAS Enterprise Guide. However, now I have problem with the Where section.   24         Proc sql; 25         Select 26          27         smlo.cislo_smlouvy, 28         smlo.cislo_ramcove_smlouvy, 29         Skud.cislo_skodni_udalosti, 30         vznik =year(datepart(skud.datum_vzniku)), 31         Scov.kod_scov 32          33         From dwh.bcdf_smlo_smlouvy smlo 34         Inner join dwh.bcdf_skud_skodni_udalosti skud on skud.smlo_pk=smlo.smlo_pk 35         Inner join dwh.bcdd_pssu_podslozky_su pssu on pssu.skud_pk=skud.skud_pk 36         Inner join dwh.bcdd_scov_subcover scov on scov.scov_pk=pssu.scov_ok 37          38         Where smlo.cislo_ramcove_smlouvy = ’898306813’                                               _                                               22                                               200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,               a missing value, (, *, +, -, ALL, ANY, BTRIM, CALCULATED, CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE,               USER.    ERROR 200-322: The symbol is not recognized and will be ignored.   39          40         ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 40       !  quit   The number in Where line refers to agreement number. Is there any solution to resolve the problem? ... View more

Thanks! That helped ... View more