Presently we are using EG 4.1 and I see I that even though we dont have SAS/Access we can read excel files using menu options. The resulting code it generates is a datastep code which probably references to a temporary text file. 2 points:-
a) Im not sure of the usability of this code for future data reads as the infile reference it creates would not be useful even if am reading the same excel file again through code.
b) I see that writing my own Proc Import code doesnt work as we dont have SAS/Access. Why is SAS allowing reading of excel files through menu options and not through code when we dont have SAS/Access. Shouldnt it allow Proc import without SAS/Access?