It seems as if you tried to create a table using proc sql without defining at least one variable.
Without seeing the log, i can't say anything else.
Special offer for SAS Communities members
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.