This is a table I have edited down from a much bigger table that includes various types of calls that occur and time. This table is one that is like a PDF turned Excel where there are lots of merged cells and extra blank lines for no reason. I just took a basic task that I am looking to do on a large scale for confidentiality reasons. ... View more

    I did add this code so it broke up the A column.  I have not sorted the data to change the order, so the name that is above the call information would go with the data.   data EditCleanup; set cleanup; if A = "mapping" then Type = "Mapping"; if A NE "mapping" then Name = A; run; ... View more

For me it was just numeric but both are helpful for me in the future! Thank you so much! ... View more

I will look into it! Thank you ... View more

It exported well the first time. But when I added a blank sheet in, saved, and closed it, I reran the code.   Unfortunately the excel is still giving me the pop up of   "We found a problem with some content in 'file.xlsx'. Do you want us to try to recover as much as we can? If you  trust the source of this workbook, Click Yes." ... View more

I tried this and it deletes any new tabs/designs I created once it is ran again. I just need to be able to create a table that it exports to its designated tabs and leaves other tabs alone ... View more

I am showing what I can due to confidentiality reasons. If you cannot help that is fine, I just figured I would see if anyone had helpful advice.    options validvarname=v7; proc import datafile= “File" out= work.calls21 dbms= xlsx replace; run; proc import datafile= “File" out= work.visits21 dbms= xlsx replace; run; proc import datafile= “File" out= work.calls22 dbms= xlsx replace; run; proc import datafile= “File" out= work.visits22 dbms= xlsx replace; run; proc import datafile= “File" out= work.CallsFS dbms= xlsx replace; run; proc sql; create table CallsFS1 as select from CallsFS ; quit; Data CallsFS2 (drop= xx1); set CallsFS1; if xx then xx; if xx then xx; xx = (xx1*1); if xx = "." then xx = 0; Run; proc sql; create table Calls21A as select from calls21 ; quit; data Calls22A; set calls22; rename; run; proc sql; create table Calls22B as select from calls22A ; quit; proc sql; create table Visits21A as select from Visits21 ; quit; proc sql; create table Visits22A as select from Visits22 ; quit; proc sort data= Calls21A; by xx; run; proc sort data= Calls22B; by xx; run; proc sort data= Visits21A; by xx; run; proc sort data= Visits22A; by xx; run; proc sort data= CallsFS2; by xx; run; data Visits(DROP= NULL); length; Merge Visits21A Visits22A; Run; data Calls (DROP= NULL); length Merge Calls21A Calls22B; Run; data CallsFS2 (DROP= NULL); length; Set CallsFS2; Run; data RawData ; Format Merge Visits Calls CallsFS2; by xx; Run; data RawData1; set RawData; ; run; proc export data=RawData1 outfile="xx\Public\VisitCall" dbms=xlsx Replace; Sheet="Raw Data"; Run; proc export data=Visits outfile="xx\Public\VisitCall" dbms=xlsx Replace; Sheet="Visits Dynamics"; Run; proc export data=Calls outfile=" xx\Public\VisitCall" dbms=xlsx Replace; Sheet="Calls"; Run; proc export data= CallsFS outfile="xx\Public\VisitCall" dbms=xlsx Replace; Sheet="CallsFSOG"; Run;   ... View more

I have attached what I could show in the code on the original post. Sorry for so much cut out. It does import from and export to a network drive ... View more