Your BY processing by 3 variables, Fund ID, Firm ID and Year. For the records indicated the Firm ID's are different so they get put into different groups and each will be the last. Check the documentation on BY processing. Check the proc sort with nodupkey option and sort descending options. HTH! ... View more

There's WPS (google it) if you're trying to learn, though I've never used it. Been fortunate enough to have SAS at most places I've worked. The 30 day trial is probably a good enough time period to practice. Its been mentioned before that if your work has a license you may be able to install that version at home as well, but unsure what the result of that was. If you're in between jobs or trying to get certified on your own time it is hard to get access to the software outside of a job. ... View more

Need an "OR" not "AND" in the where statement. data LIST; input ID Style CD $ NUM; datalines; 1 102 A 12 2 102 C 14 3 104 A 12 4 104 A 13 5 104 B 14 6 104 B 12 7 104 C 12 ; run; PROC PRINT DATA = LIST noobs; where style = 104 and (cd ne 'A' OR num ne 12); RUN; ... View more

You can try a sql merge (untested). From a processing perspective I'm not sure which is faster or more efficient. But you can do it without sorting. proc sql; create table dset3 as select var1, var2 from dset1 a join dset2 b on a.var2=b.var2 and a.var1 ne b.var1; quit; Message was edited by: Reeza ... View more

Is it possible to use some of the traffic light format options to accomplish this? Mostly curious. ... View more

dbms option should be dlm for delimited and delimiter='09'x I think. proc export data=sashelp.class outfile='c:\temp\test.txt' dbms=dlm replace; delimiter='09'x; putnames = no; run; ... View more

Look up the SAS functions trim() and left(), right() is also useful to know. ... View more

The alias might have trailing or leading blanks, and then you're searching for ' 999' or '999 ' rather than 999. Try using the compress function on alias: x=find(name, compress(alias)); y=find(name, alias); ... View more

Paige is correct. It really depends on the type of question you're trying to answer. Looking at your data I see two possible questions: 1) Are the two data sources the same? 2) Are the monthly values the same for different areas of a call center? I interpreted this as 2, but it could easily be 1 and it changes how you deal with things. Or any number of things I can't even think of...and you previously mentioned monthly totals but have daily data 😞 Perhaps state the LOGIC/business problem you're trying to solve, along with the SAS steps you're having issues? Helping you do the wrong thing doesn't help anyone. ... View more

Are you looking to compare the totals, which are two numbers or a series of numbers? ie data set1 month1 3 month2 5 month3 5 data set2 month1 4 month2 9 month3 3 If so use the Procedure TTEST with paired options, but you will have to combine the data first. Proc compare will compare the differences between two dataset values, but not variance. If just two values you can't calculate variance. ... View more

Check your proc tabulate...you called the format with the wrong name, but I can't see that causing all that error....but thats why you check the log. ... View more

How are you importing/exporting between packages? I recently found for me that if I export the SPSS data to SAS, from SPSS then I lose my labels and formats. In my export there's also an option to save the formats to a file. This is converting a .sav file to .sas7bdat If I read the SPSS .sav file from SAS then it reads the formats/labels. I'm using SAS 9.2 and SPSS 14. ... View more

This will only work for last submitted code. Run> Recall Last Submit. HTH, Reeza ... View more

that should work. I need the log error to help debug. One suggestion would be to separate the as from the ) and possibly get the date as a 'date' rather than datetime (which is what i think you had it before). PROC SQL; CREATE TABLE MEAN_Calls AS SELECT datepart(date) as grouped_date, avg(calls_handled) AS BPSMEAN FROM mean1 group by datepart(date); QUIT; Message was edited by: Reeza ... View more