You might want to right-click on the Project Tree, and select Collapse All.  Then, make sure there is at least some white space at the bottom below where all your process flows are listed. If not, you may need to expand the screen real estate dedicated to your project tree.  Once you have available white space, right click, and hopefully Paste will appear as an option instead of being grayed out.  This is how it's working for me anyway, and since I finally figured it out, I wanted to share. ... View more

There is an issue with using YEARCUTOFF: when you have several dates in one file spanning over different ranges, it will fail. Consider a file containing life insurance information, past and present. You will find birthdates ranging from 192x to 200x, contract start dates from, say, the 1960's to the present, and contract end dates from, say, the 1970's to the 2050's.   Bottom line: anybody delivering 2-digit years, especially after Y2K, needs to have their heads examined for a missing brain. ... View more

After a bit more research, I was able to get a nested TRANWRD function to work.   tranwrd(tranwrd(compress(olddata,'','d'),';#;#','0a'x),';#','') as newdata ... View more

/*It is a SAS/IML thing.*/ data have; set sashelp.class; if _n_ in (2:8) then do;name=sex;age=weight;end; run; proc iml; use have; read all var _num_ into num[c=n_name]; read all var _char_ into char[c=c_name]; close; /*For the first question*/ n_level=countunique(num,'col'); c_level=countunique(char,'col'); print n_level[c=n_name l='the number of levels for each numeric variable']; print c_level[c=c_name l='the number of levels for each character variable']; /*For the second question*/ do i=1 to ncol(num)-1; do j=i+1 to ncol(num); var1=var1//n_name[i]; var2=var2//n_name[j]; n_mismatch=n_mismatch//sum(num[,i]^=num[,j]); end; end; do i=1 to ncol(char)-1; do j=i+1 to ncol(char); var1=var1//c_name[i]; var2=var2//c_name[j]; n_mismatch=n_mismatch//sum(char[,i]^=char[,j]); end; end; print var1 var2 n_mismatch[l='the number of obs are mismatched']; quit;   ... View more

You help yourself get faster and better answers by showing us full logs (if possible), the code you actually used, and by using proper terminology. This helps you, this helps us. If you don't want to help us and help yourself, that's not good.   In this specific case, the problem could be solved without the full log, that will not be true in other cases. ... View more

Without additional information for something I do not see how to tell if 0.0030 is supposed to be 0.03 unless you have an absolute range limit in the value of the variable. ... View more

@elwayfan446 - From what I understand an EG project is just a zip file so you could point a zip tool (eg 7-zip) at an EGP file on your old computer just to see if you can spot any embedded program versions. Just a thought. ... View more

Thanks @Tom.  I finally figured it out this morning and posted it a few replies above here.  I couldn't figure out how to mark it or yours as the answer because that button is not showing up anywhere for me like it usually does.   Thanks for all of your help. ... View more

Good morning @Tom    Here is my latest crack at it but doing this now puts all records from the dataset into each excel spreadsheet.  I can't make the connection to only export the records for each seqno (seller_name) into their own spreadsheet.   data _null_; set loop; call execute(cats( 'proc sort data=sellersheet out=loop (keep=SeqNo seller_name)nodupkey; by SeqNo; run; data for_export; set sellersheet; where seqno=SeqNo; drop seqno; run; proc export data=for_export outfile="/sae/aal_labapm/01/mortgage/msracq/DATA WAREHOUSE/DWACQ/REPORT FILES/MSR0028/&filedate._',seller_name,'.xlsx" DBMS=XLSX REPLACE; sheet="','LOANLIST','"; run;' ) ); run; ... View more