I changed the libname but the problem is the new library keeps disappearing and I get the same error! Do you have any idea why it's happening? libname statement keeps failing to when I'm trying to assign the library with syntax too.    My sas version is SAS (r) Proprietary Software 9.4 (TS1M1).    Thanks  ... View more

Thanks. but, when I ran your code I get these errors: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement.   this is my codes: libname test pcfiles path="C:\Users\Hannah\Desktop\Literature\bavdata2.xls"; /* the exact code here may vary*/ proc copy in=test out=work; run; ... View more

Thank you! It worked perfectly! ... View more

Hello! I have uploaded a sample of my data. I want the new data set that SQL creates have company Id and sum variable for each company ID. However, as you can see in my data, for each company ID I have a range from 2007 to 2015 and daily value of each variable(images). Now, I am trying to make another data set based on some events, those events are date ranges for each company like from Dec 31st of 2007 to 30th january 2008 for company 10107. Each company may have different date ranges requiring sum variable for each of these specified ranges. So, the new  table should allow me to see a company ID and sum variable attributable to that date range which I will speicify in the command. Also, Can I see the date range in the output too? I was wonderring if I could do multiple dates and multiple companies all in one syntax.   Thanks Again!     ... View more

Thank you for replying! Your syntax works and very easy for me t understand! However, now I want to change yours to fit my multiple companies with different time frames: proc sql; create table want as select permno, sum(images) as ImagesSum from sasuser.infegysubset(where=(companyid='83976')) where date between '30dec2007'd and '30JAN2008'd where date between '27dec2008'd and '27JAN2009'd from sasuser.infegysubset(where=(companyid='10107')) where date between '30June2008'd and '30July2008'd where date between '27NoV2008'd and '27DEC2009'd group by permno; quit;   So my question is now how I can do it for each company with different dates(the one I pasted above gives me error because of second where). And how efficiently do it for multiple companies. The codes I pasted above doesnt work. I just wanted to show you what I need. So I have multiple companies each require different dates to be specified to acquire the sum variable. ... View more