This was really helpful! 🙂 ... View more

Thank you. This helped me today! 🙂 ... View more

Dear,    You can try many ways to get it done...   As @dcruik Proc sql is good to use and we can use datastep as well for the same...   try below code ....   data A; input X $ Y; cards; Apples 1 Oranges 3 Pears 3 ; run; data b; input X $ Y; cards; Apples 1 Watermellon 1 Oranges 3 Pears 3 Banana 2 ; run; /*method 1*/ proc sql; create table want as select * from b where x not in (select distinct x from a); quit; /*Method two */ Proc sort data=a; by x;run; Proc sort data=b; by x;run; data want; merge a(in=_x) b(in=_y); by x; if _y and not _x; run; ... View more

Hi Yaswanth, i don't see any difference in your input and output(correct me if i am wrong ) can you explain bit more? what are we trying to achieve here.. ... View more

This Discussion is worth reading Regarding macro Global&local variables  Thanks all.. ... View more

Hi,   Well, sort of. It seems to me that the %WORD2SAS macro program is copying something from a DOC file and trying to paste it into Excel using DDE and then doing a Save As with DDE commands. And, the %WORD2SAS macro program was written by someone else. If the OP has issues with the macro program and how it works, he/she needs to work with the author of the macro program. And, while changing the macro program's PROC IMPORT step might work, by changing the DBMS= option -- it still seems to me that recommending DMBS=EXCELCS is dependent on the whole bitness issues, and having the PC File server -- which may not have become an issue until SAS 9.2 or 9.3 and the OP said he had 9.1 (but didn't mention his version or bitness of Office).   And, in addition, the OP might have found this Tech Support note 9554 - "External table is not in the expected format" returned when reading Excel file with PROC IMPORT or the Import Wizard if searched on the support.sas.com site. To me the error message implied that the COPY from the Word doc got pasted as some other format of Excel file. So the SAVE with the DDE did not save in the right format needed for PROC IMPORT. So, to me that implies that the SAVE step in the DDE code needs to be changed instead of changing the DBMS= option.   At any rate, since nobody knows what's actually in the Word doc (from the September 2013 post), the other issue could be that the Word doc has more in it than just a simple table, and what's being pasted into Excel is not really of a form to be turned into a sheet in Excel. And, since the whole post took place originally in September last year, and the posting in May 2014 was from somebody entirely different, I wasn't sure that how the May post was even related to the original question. And now, on rereading the May 6th post, it really doesn't add anything to the solution to the original problem from September, except to suggest something about the OP getting a Word SDK -- which wouldn't really help, either, with the %WORD2SAS macro program. But since the original posting seems very over, now on rereading everything, I think that all of our May posts are probably irrelevant and/or moot. So signing off, without further comment. cynthia ... View more

All values of the variables or only selected ones? ... View more