How does the POINT= option in the SET statement retrieve an observation? Why is the answer C? Question options:   by reading the data in sequential mode   by variable value   by observation number   by applying an index ... View more

There is a question:   Create a Macro variable for Dallas in the Location variable of Data: ALL. Use this macro variable to subset the ‘ALL’ excel data inside the proc SQL to select variables student_name, teacher, fee, days, paid, location. Write a Proc SQL query to find the ‘average fee’ and ‘total fee’ by ‘paid’ variable for Dallas. This data set of All is like: Using this following Proc SQL procedure the goal is easily achieved: Proc SQL; Select student_name, fee, days, paid, location, mean(fee) as avg_fee label = 'average fee', sum(fee) as tot_fee label = 'total fee' From All Where location = 'Dallas' and Paid = 'Y'; Quit; However, when I tried to use the following code to create a macro variable to subset the location variable into 'Dallas', it did not work:   Proc SQL; Select student_name, fee, days, paid, mean(fee) as avg_fee label = 'average fee', sum(fee) as tot_fee label = 'total fee', location into :Dallas From All Where Paid = 'Y'; Quit; Would someone like to kindly show me how I should create the macro variable so as to subset the location variable successfully?   Thank you!   ... View more

Hello. Everyone,   My code to import the file is    Proc Import Datafile = 'D:\STAT_8020_Advanced_SAS\HW4\new.year2010.csv' DBMS = csv Out = sasuser.newyear2010 Replace; Run;   Data newyear2010; Set sasuser.newyear2010; Run;    I have successfully created and stored the following macro for creating a linear regression:   libname Doc 'C:\Users\thisi\Documents'; Options mstored sasmstore = Doc; %macro slreg(dataset, dep=, indep=)/store source; Proc Reg Data= &dataset; Model &dep = &indep; Run; %mend;   It could be easily called using  %slreg(newyear2010, dep=sale, indep=day)   However, when I tried to call it using the %include procedure in this following code: %include 'C:\Users\thisi\Documents\slreg.sas' /source2; it was not successful.   The SAS log error message is  115 %include 'C:\Users\thisi\Documents\slreg.sas' /source2; WARNING: Physical file does not exist, C:\Users\thisi\Documents\slreg.sas. ERROR: Cannot open %INCLUDE file C:\Users\thisi\Documents\slreg.sas.   When I tried to call it using the Proc Catalog procedure in this following code, it was also unsuccessful: Filename slreg Catalog 'Doc.Sasmacr'; %include slreg / source2;   The SAS log is 117 Filename slreg Catalog 'Doc.Sasmacr'; 118 %include slreg / source2; ERROR: For sequential access, physical name must be at least 3 levels. ERROR: Cannot open %INCLUDE file SLREG.   Would you like to give me some hint about the possible solution? Thank you very much!   ... View more