Hello all, i am creating tables with some prompts...in these steps i´m creating some variables with :INTO and with them the output table gets created.   If i am "clicking" my way to the output table i get about 22M columns, but with my code version i get 22M minus 15k.   I compared the "clicked" code with my code via prompts and code, its the same code @ the end (checked it with %put).   Its a simple code CREATE TABLE work... as SELECT t1.columns t2.columns from work.x t1 LEFT JOIN y t2 ON (t1.key = t2.key)   Like i said, i compared the clicked code with sas eg with my written...at the end its the same, but i´m missing 15k on colums. The output data is i think the same, i compared some rows...(btw is there a function, where i can compare 2 Tables, if the data is the same?)   So...why?   ... View more