@vazmena1 wrote: Please could you provide the code? I have the same problem. Thanks Please post a new question, not add on to a several year old one.    Build your code using the query builder and then copy the code to a code node. Then manually add in the calcuations you want.    It follows the format below, in red, with the BMI calculation.    proc sql; create table WANT as select age, name, weight, weight/height**2 as BMI from sashelp.class; quit;      ... View more

Hi All entire column is missing on import even though every cell in the column in the spreadsheet is populated with a character string. You say avoid using Excel as a direct import and go via a text file but that is exactly what Enterprise Guide does - it get Excel to write the data out as a tab delimited file and then reads it in via a data step. If I open the text file it creates the data is missing in that. If create a similar text file from Excel via 'File->Save as...' then the column is not full of missing values. Just a bug or fixable? P.S. Using SAS EG 4.3 against a local install of SAS9.4M1 on Windows. ... View more

I don't have SAS EG but I do have PC SAS with SAS/Connect and the performance is very different. SAS Tech support suggest this is because SAS is giving a record count - running a count(*) query when it starts which might be slow for a view. They say this is different in SAS Studio version 3.5. It doesn't explain why it is slow simply producing a lst of tables to browse. ... View more