@rajredy7172012 wrote: Not getting any error. But, the output doesn't get the formats like below.     What does "doesn't get the formats" mean in this context? I don't see any relationship between that picture and the format code shown above. Unfortunately  while pictures may be worth a 1000 words the words may not mean anything in relation to solving a problem without details of what the actual problem is.   Your "code" is practically meaningless. You have multiple macro variables without showing a definition of where they might come from or the values, much less any example of data that would be used by that Proc Report.   ... View more

@rajredy7172012 wrote: Yes, for trtpn=2 i removed the values since they don't have any records. So if you have 3 levels of the variable trtpn and you remove one why would you expect any data in the output for it? And missing records means that you only had two levels to begin with. So really, where is the expectation of getting output for non-existent values? ... View more

Yes, they are all sas variable names. ... View more

What's the purpose of this code? Is this what you tried? I don't see FCOPY being sued anywhere.... ... View more

In my experience you are better off uploading your SAS data into SQL Server which Power BI works well with. ... View more