Assertion failed: expression type not known at file: src/core/expressions/Expressions.cpp line 53

vebo

My SAS Community license was working properly. Something happened (not sure what). But now I get te following ERROR message. How to fix it?

wpslinks 5.25.1.0.1401-GA-release initialising




%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Assertion failed: expression type not known at file: src/core/expressions/Expressions.cpp line 53

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Assertion failed: expression type not known at file: src/core/expressions/Expressions.cpp line 53

Crash dump generated in C:\Users\xxx\AppData\Local\Crash Dumps\wpslinks-20251113-162043.dmp

vebo

Here is how I resolved the bug.

The following code bugs because the variable timeofday does not exist (I changed the name and needed to rename it as well in proc sql.

proc format;

invalue morning 'MORNING' = 1;

invalue midday 'NOON' = 1;

invalue afternoon 'AFTERNOON' = 1;

invalue evening 'EVENING' = 1;

invalue night 'NIGHT' = 1;

invalue monday 'MO' = 1;

invalue tuesday 'TU' = 1;

invalue wednesday 'WE' = 1;

invalue thursday 'TH' = 1;

invalue friday 'FR' = 1;

invalue saturday 'SA' = 1;

invalue sunday 'SU' = 1;

invalue mo_th 'MO','TU','WE','TH' = 1;

invalue fr_su 'FR','SA','SU' = 1;

run;

proc sql;

create table stat_city_showgrp_actual as

select distinct company, eventcat, showname,city

, min(show_dt) as showgrp_dt_min

, max(show_dt) as showgrp_dt_max

, count(*) as cnt_show

, sum(input(timeofday,morning.)) as cnt_morning

, sum(input(timeofday,midday.)) as cnt_midday

, sum(input(timeofday,afternoon.)) as cnt_afternoon

, sum(input(timeofday,evening.)) as cnt_abends

, sum(input(timeofday,night.)) as cnt_nachts

, sum(input(weekday,monday.)) as cnt_monday

, sum(input(weekday,tuesday.)) as cnt_tuesday

, sum(input(weekday,wednesday.)) as cnt_wednesday

, sum(input(weekday,thursday.)) as cnt_thursday

, sum(input(weekday,friday.)) as cnt_friday

, sum(input(weekday,saturday.)) as cnt_saturday

, sum(input(weekday,sunday.)) as cnt_sunday

, sum(input(weekday,mo_th.)) as cnt_monday2thursday

, sum(input(weekday,fr_su.)) as cnt_friday2sunday

from show_actual

group by company, eventcat, showname, city

order by company, calculated showgrp_dt_min;

quit;

But this also code does not bug. It just create a normal error that timeofday does not exist.

ERROR: In the SELECT clause, column timeofday was not found in the contributing tables.
NOTE: Statements not executed because of errors detected

proc sql;

create table stat_city_showgrp_actual as

select distinct company, eventcat, showname,city

, min(show_dt) as showgrp_dt_min

, max(show_dt) as showgrp_dt_max

, count(*) as cnt_show

, sum(input(timeofday,morning.)) as cnt_morning

, sum(input(show_timeofday,midday.)) as cnt_midday

, sum(input(show_timeofday,afternoon.)) as cnt_afternoon

, sum(input(show_timeofday,evening.)) as cnt_abends

, sum(input(show_timeofday,night.)) as cnt_nachts

, sum(input(weekday,monday.)) as cnt_monday

, sum(input(weekday,tuesday.)) as cnt_tuesday

, sum(input(weekday,wednesday.)) as cnt_wednesday

, sum(input(weekday,thursday.)) as cnt_thursday

, sum(input(weekday,friday.)) as cnt_friday

, sum(input(weekday,saturday.)) as cnt_saturday

, sum(input(weekday,sunday.)) as cnt_sunday

, sum(input(weekday,mo_th.)) as cnt_monday2thursday

, sum(input(weekday,fr_su.)) as cnt_friday2sunday

from show_actual

group by company, eventcat, showname, city

order by company, calculated showgrp_dt_min;

quit;

So if I have a single misspelled variable name, there is no error but if I have two mispelled variables I get the error.

I was not able to reproduce the error with a more simple dataset. I has something to do with th functions either input or sum.