Hi All,   from below code I want to create dataset which will have this two column path and lname which gate value from this two macro variable &dir and &name respective. can you please help me to put my output statement in right position so that I can create data set ?   %macro drive(dir,ext); %local filrf rc did memcnt name i; /* Assigns a fileref to the directory and opens the directory */ %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf)); /* Make sure directory can be open */ %if &did eq 0 %then %do; %put Directory &dir cannot be open or does not exist; %return; %end; /* Loops through entire directory */ %do i = 1 %to %sysfunc(dnum(&did)); /* Retrieve name of each file */ %let name=%qsysfunc(dread(&did,&i)); /* Checks to see if the extension matches the parameter value */ /* If condition is true print the full name to the log */ %if %qupcase(%qscan(&name,-1,.)) = %upcase(&ext) %then %do; %put &dir\&name; %end; /* If directory name call macro again */ %else %if %qscan(&name,2,.) = %then %do; %drive(&dir\%unquote(&name),&ext) %end; %end; /* Closes the directory and clear the fileref */ %let rc=%sysfunc(dclose(&did)); %let rc=%sysfunc(filename(filrf)); %mend drive; /* First parameter is the directory of where your files are stored. */ /* Second parameter is the extension you are looking for. */ %drive(c:\temp,sas) ... View more

Hello Experts, I need help to understand whenver we do SAS system migration (upgradation) from old version to new version (like in my case SAS 9.1 to SAS9.4) in that case what are the things that we need to take care of? I know the answer of this question will be vary from system to system and requirement, but still if somebody has done this in their organization, can add some comment which will be real helful for me. In my Organization we have CRMS 4.2 product which is also part of upgradation so i am basically looking for the same, also we are going to replace SPDS with Hadoop/Grid structure. I request all those who had done similar upgration to put your valuable comment and link to any document which will help me to identify know issue/risk for such upgradation. Thanks in Advanced, Regards, Tushar J ... View more