data test; set sashelp.class; run; proc datasets library=work nodetails nolist; change test=test_%sysfunc(month(%sysfunc(today()))); quit;     data test; set sashelp.class; run; %let month=01; proc datasets library=work nodetails nolist; change test=test_&month; quit;   ... View more

Why not do it the other way round.  Your obviously fixed on using Excel, so why not use that as the driver?  Export the data from SAS as plain CSV file, then have the Excel file load the CSV data and populate its sheets appropriately usng VBA.  Simple and less messing around trying to force one application from another. ... View more

Thanks @renjithr. That confirms the .xlsx file was created.  So, back to my previous question...   When you say, "the file that got created is not able to open", do you mean the xlsx file cannot be opened in Excel?  Or, the xlsx file is created, but not added to the EG project?  (If the second case, EG does not automatically add files exported via code to the EG project.) ... View more

Thanks Ksharp, PGStats! ... View more

Thank you! ... View more

Thanks a lot!! Aprreciate your help! ... View more

Hi All,   Thanks for the reponse.   Here is how I finally achieved retining the format of numeric variable in .CSV file.   data _null_;  file filout;  if _n_=1 then do;   put @1 '="'          @2 'Num variable'          @10 '"'; end; put @2 num_var; run; The above trick works! ... View more

Thank you all for your comments, really appreciate it!! ... View more

Hi Tom, Thanks so much for your input. With a slight modification I was able to get what I wanted. Below is the modified code: %let n=10 ; data want ;    set have;    array _dx dx1-dx&n ;    array save(&n) $5 _temporary_ ;   do _n_=1 to &n ;     save(_n_)=_dx(_n_) ;   end;   do _n_=1 to &n ;         call missing(of dx1-dx&n);     _dx(_n_)=save(_n_);     output;   end; run; ... View more

Thank you all! ... View more

Have a read of the following link. I consider this quite helpful information. SAS(R) 9.2 SQL Procedure User's Guide As a variation of "Producing Rows from the First Query or the Second Query" below code should do: proc sql;   create table want as     select * from Company       where Deptid not in (select Deptid from Dept)     outer union corr     select * from Dept       where Deptid not in (select Deptid from Company)   ; quit; ... View more

Thank you all for sharing your thoughts! ... View more

@ ballardw      Right. I need those variables to do other calculation based on the age category.  SEX, Dob and Dis_dt are in the input datasets. ... View more