Hello, i am getting this error if i do for example a substr(xx,1,4) AS xx2. I implemented the code in a prompt associated with an EG programm file, and it doenst work with BIGINT, table gets not created...but it does work on an other colum(VARCHAR), with the same error. The BIGINT column code works on a same generated prompt in a stored process and the log doenst show me the error (didnt tested if the VARCHAR works, but i assume it works too). So im a bit confused?! How to clean the errors on the normal EG project programm and get this work with the BIGINT column? I tried it with %sysfunc(%quote(substr(xx,1,4) AS xx2)) but that doesnt work. Just to understand, i put the whole substr(xx,1,4) AS xx2 in the prompt (unformated value), its in a static list and then i chose the value(formated displayed value) and take the function behind it, in this case the substr... This works in a stored process with a simple prompt, but not 100% in a normal SAS EG promp associated with a program.
... View more