Basically if you want to know if they took multiple classes you need to make a flag for the taking the class and then choose your students based on that. Also if you want it to show up in a table, put create table _____ as prior to the select statement. proc sql; create table want as select distinct student_id, max(case when course="Math 1" then 1 else 0 end) as math_1, max(case when course="Math 3" then 1 else 0 end) as math_3 from have group by student_id; create table want2 as select distinct student_id from want where math_1=1 and math_3 = 1; quit; ... View more

Rasheed, Why not automate it through SQL to give you the different type names and the number of different types and then pass that back through a data step? The nice thing about this method is that if the type variable ever was a character it also would collect it properly, however this method tends to fail if the character string created as &typen exceeds a character limit (however I can't remember what that limit is). %macro qk; proc sql noprint;     select distinct type into: typen separated by '*' from have; quit; %let typenn = &sqlobs; %do i = 1 %to &typenn; %let typ = %scan(&typen,&i,'*'); data type_&i;     set have;     where type = &typ; run; %end; %mend; %qk; Robert ... View more

Navin, I had the same problem with 9.3, but it resolved with 9.4, but only when the SAS/Microsoft Office Plugin was properly installed. At the moment the issue that you likely are currently having though is you need to use dbms=excel. Hope this helps ... View more

I have used the redcap SAS import before and its straight forward. The last time I did it it gave me a csv file and a sas program which will important everything including enforced formats, if you used a radio button it will output correctly. However if you used a check all that apply response the file can get quite expansive, and then you need to recode things so that multiple columns of responses will be in a single column. Otherwise its a really nice feature. ... View more

What does the data actually look like? The ratios don't really indicate anything other than the paired groups are similar, but there may be something that you are missing. If you could post even 10 lines of data which when you run this should up incorrectly that would help. Additionally what does the output look like when you run proc means data = forttest; class loan_price_cat y9c; var aggr_roll_on_rate roll_on_rate; run; This at least will give us an idea of what the means of the two groups are and it the means in this case are drastically different may explain why you are being told to reject H0 ... View more

Or you can just stack them data final;      set     Directa                Folios; run; As long as they are in the same positions, ie the data that you had presented earlier this will just stack the two of them on top of each other. ... View more

Since you saved it to your hard drive you have to trick EG into realizing what your local computer is called. I have found that the easiest way to do this it to open up SAS in this case I guess it is EG, so I don't know exactly how or where you will have to ask the file to open, but then go to my computer and open up your hard drive. Using our schools virtual SAS (on a UNIX platform), my hard drive shows up under \\Client\C$ which is what would replace C: in most of your requests, so if you have saved the file to your desktop your file path would be \\Client\C$\Desktop. But once again it all depends on where things are located and the operating system. One last thing, the reason that the libname statement you wrote didn't work was because you included custfm.xls in the libname, a libname should be a folder not a file. If you wanted to point at the file and read it in your best bet may be to write it like this: filename serv ( '/tutorials/eg/data/ecprg1/custfm.xls'); data readable; infile serv; input; run; or just write it in a proc import statement proc import      out = want                          datafile =  '/tutorials/eg/data/ecprg1/custfm.xls'                          dbms = excel                          replace;                          getnames=yes;                          guessingrows=1000; run; Hope this helps. ... View more

proc sql; create table have as select distinct company_id, (sum(case when year = 2001 then wage else 0 end)) as wage_2001, (sum(case when year = 2002 then wage else 0 end)) as wage_2002, (sum(case when year = 2003 then wage else 0 end)) as wage_2003 from want group by company_id; quit; But I am sure that there is also a way to do this with Proc Summary or Proc Report, those just aren't things that I typically write code in. Granted you said something about weighted average, but didn't really include what it should be weighted by, or even how it should be evaluated. If you wanted the mean salary for each of these years by the company_id you could change sum to avg or mean. Hope this helps ... View more