No, I was not using the university edition . . . my previous efforts led me to SAS Studio. Thank you for this link; I'm in process of installing it now. Regards, eljay ... View more

thank you . . . looks like SAS Studio is worthless to me since i have no idea where the server is. Ordinarily I use LIMDEP and Eviews for my statistical analysis but they are coming up short with a regression diagnostic I need.  I will investigate SAS on campus a bit more before checking out SPSS.  ... View more

What's your question? how do i import excel data to SAS studio? What's the issue your having with import i get this error: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 data opeb; 57 infile 'E:\000000pensionopeb\april19small.csv' DLM=',' firstobs=2; 58 input GFOA lopeb lpop nuobs1 logliab mc urate ustat logplus1 yr lav st$ name$ posnad; 59 60 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/E:\000000pensionopeb\april19small.csv. WARNING: The data set WORK.OPEB may be incomplete. When this step was stopped there were 0 observations and 14 variables. WARNING: Data set WORK.OPEB was not replaced because this step was stopped. 72       and how are you doing it? typing the code as per above       How is your SAS set up? I am using SAS studio.   FYI CSV are text files that Excel knows how to read, they are not Excel files. The SAS tutorial video emphasized the need to use csv format.   thank you for help ... View more

Thank you for anwering! I am following the tutorial as closely as I can but the tutorial seems to assume that the excel SS is already resident within SAS. My data are in a flash drive as e: Here are my code lines data opeb; infile 'E:\000000pensionopeb\april19small.csv' DLM=',' firstobs=2; input GFOA lopeb lpop nuobs1 logliab mc urate ustat logplus1 yr lav st$ name$ posnad; ... View more