Thanks a lot Tom... ... View more

Tom it worked great but can you please brief me about why we put this sign?(=/); ... View more

Tom - this was the question. i have 10 different directories (like below). under each directory have dataset name "test_check". Our process (other code) producing these "test_check" dataset in 10 directories where we have one variable "date" (type=numeric) which has value like "Sat, Feb 28, 2015" with format "weekdate17." (this value is from today's process - tomorrow it will be"Sun, Mar 01, 2015"). Now basically all the time this dataset, "test_check" has same value for all 10 datasets (i.e two days back: Sat, Feb 28, 2015) but sometime lets say 2 out of 10 datasets has different value, i want to find out in which directory "date" variable has different value than lets say Sat, Feb 28, 2015 (if i run code today). __________________________________ f:\woo\dir1\test_dataset\test_check f:\woo\dir2\test_dataset\test_check . . . f:\woo\dir10\test_dataset\test_check ... View more

I am using 9.1 I assigned "SAS_MAIN"  -->  right click on it ---> properties   ---> "software" tab and i can see that "SAS Version" is 9.1 ... View more

i tested code from my last post and it worked fine. I also did try with different logic like   where date ne today()-3 ; and it worked fine too. i didn't make any major changes for macro piece of code that i have posted and i still have doubt on (dsname=indsname) (last 4th line of code from what i have posted) so i don't know what line in macro code should replace this dsname=a*1+b*2+c*3 ; from simple data step perspective but i simply used dsname=indsname; and it worked... ... View more

Thank you so much all. Reeza it worked fine and i was able to convert it into macro. as below. tested - ran fine. %macro test; data test; length indsname dsname $256; set %do i=1 %to 10; "f:\woo\dir&i.\test_datasets\test_check" %end; ;   where date ne today()-2 ; dsname=indsname ; run; %mend; %test ... View more

yes i am using 9.1 ... View more

Hi, i understand this logic at some extent but if below is how i can test code at lower scale then i am receiving same error; libname rep1 "f:\woo\dir1\test_datasets"; libname rep2 "f:\woo\dir2\test_datasets"; libname rep3 "f:\woo\dir3\test_datasets"; data test ;   length indsname dsname $256 ;   set        rep1.test_check        rep2.test_check        rep3.test_check   indsname=indsname   ;   where date ne today()-2 ; dsname=indsname ; run; ... View more

Hi Tom -  i am using your code and it is giving me below error message... ____________________________________________________________________________________________________ 29            indsname=indsname   ;   where date ne today()-2 ; dsname=indsname ; run                       _                       22                       76 29       ! ; ERROR 22-322: Syntax error, expecting one of the following: END, KEY, KEYS, NOBS, POINT.  ERROR 76-322: Syntax error, statement will be ignored. ... View more

I am receiving below error with Quentin code: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric        operand is required. The condition was: %mtanyobs(data=rep&i.(where=(date ne        (today()-4))))  ERROR: The macro TEST will stop executing. ... View more

I am sorry Arthur "date" variable is numeric with weekdate17. format. ... View more

"test_check" dataset looks like this today in all 10 different directories. in some directory - "date" variable value is not same as I shown below so I want those datasets out. ms_value        type=num fico                  type=num date                 type=date    ms_value fico date 1234 12.5 Thu, Feb26, 2015 ... View more