The code for mysas was not shared. Between the first question in the thread from @paige2 thank you!  and your answer, I figured out the issue was exactly what you mentioned. I was not aware I could call files the way you showed me. Thank you so much @Tom  ... View more

@Tom Thank you!! That works. ... View more

This is what my log shows. The issue seems to be that the macro code is searching for the files in my SAS library but they are not there. How do I change this code to look for these files A1 A2 A3 A4 A5 in my desktop? Maybe there isn't a way.    options mprint; 15198  %macro combine; 15199 15200 15201  data ALL; 15202    set 15203    %do i = 1 %to 5; 15204      A&i 15205    %end; 15206    ; 15207  run; 15208 15209  %mend; 15210 15211  %combine; MPRINT(COMBINE):   data ALL; MPRINT(COMBINE):   set A1 A2 A3 A4 A5 ; ERROR: File MYSAS.A1.DATA does not exist. ERROR: File MYSAS.A2.DATA does not exist. ERROR: File MYSAS.A3.DATA does not exist. ERROR: File MYSAS.A4.DATA does not exist. MPRINT(COMBINE):   run;   NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set MYSAS.ALL may be incomplete.  When this step was stopped there were 0          observations and 16 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds   ... View more

Thank you! I tried that and it did not work but I might be doing something wrong. I also tried to use format percent8.0 to  get rid of the decimals (another option)... but I do not have a Percent variable, I am creating that variable in the graph and I tried several places on my code but it won't let me format the var Percent that is being created for the graph as I showed in my original post.   This is my entire code   ODS GRAPHICS ON / RESET IMAGENAME="Fig1" IMAGEFMT=png ANTIALIASMAX=10000; GOPTIONS RESET=ALL BORDER CBACK=WHITE HTITLE=12PT HTEXT=25PT ftext='Bold'; OPTIONS CLEANUP; proc Gchart Data=have vbar3d Greetings /TYPE=PERCENT annotate=have                        inside=PERCENT   patternid=midpoint       width=20       space=5       maxis=axis1       raxis=axis2       gaxis=axis3;       coutline=black; axis logbase=2 logstyle=expand      order=(1,2,3);        axis2 label=(angle=90 'Percent');       run; quit;   ODS GRAPHICS OFF;     run; ... View more

@DanH_sas Is there a similar function to round up percentage for proc Gchart Data want; vbar3d var/ TYPE=Percent   I've read so much and I can't find a way to be able to round the percentage in this case.  I learned how to do everything else I wanted like change the points in the axis, color, width of the bars, add the percent value to the bars. But I can't find a way to round the percentage in this case. ... View more

I was able to use this and it worked to remove those extra marks. But now I am considering not doing a 3D chart 🙂 In any case, great learning experience. axis logbase=2 logstyle=expand      order=(1,2,3); ... View more

@DanH_sasPerfect. Last question. Is there a way to round up the percentage?  Right now I have 18.18% and 31.8% for 2 of the value points. I would like to have them display 18% and 32%. Thank you again! ... View more

Thank you @DanH_sas  This is great. Is there any way I can add the percentage value to the top of each bar? ... View more

Thank you! It was requested that I create a 3D chart like the one I am showing. I had originally created one with PROC SGPLOT + VBAR as everyone suggested (and it would be my preference) but the graph was seen as too plain. ... View more

Thanks. The link did not work.   ... View more

I transformed VAR1 that is being collected as character into numeric to solve my issue with leading spaces for the code you suggested I use for the merge/re-coding of the var ID. This is fake data I am entering, the data is coming from a REDCap form that is being exported as a SAS file. I use the SAS files to run through my code (The two files I mentioned before set 1 and set 2). I did not enter the values in datalines.  In the code you suggested I use, you mentioned something about a possible issue coming from a number that is too long? Could that have been it? ... View more

@Tom @Ksharp Another question. I added different numbers on VAR1  and noticed that this one gave me an issue: 657899654.   This is curious: 1. Using Tom's code it applied the correct ID but it created another record with a round up number of 700000000 with a blank ID. The record that get the ID does not have the data that would be coming from set 2. The extra record does. 2. If I use Ksharp's code, no extra record is created but that specific record does not get the ID, ID is blank and the merging variable number VAR1 is transformed to 700000000. All other variables are in, as they should.    It looks like numbers up to 7 digits work fine. I did not try 8 digits, is it safe to say that up to 8 digits it would work fine? Is the issue here that the number is 9 digit? Why do the codes not work for that specific Var1 # ? I can make sure the VAR1 number is not >7 or 8 digit, if that is the issue. I wanted to understand what is happening before moving forward. Why would SAS round up that particular Var 1 value (on both codes) and split the data on 1 and not assign the ID on 2? It did not do the same for any of the other values I entered (up to 7 digits). Thanks.     ... View more

Thank you!   ... View more