How do we put multiple variables into a single column in proc report?

[sneha_dodle]

I have a dataset with variables site,subjid,race,ethinicity,sex. How do i get them all in one column using proc report. My output should contain site\subjid\race\ethnicity\sex in one column

[andreas_lds]

Maybe using compute statement, but it is easier to  create one variable using a data step:

Untested code:

data work.combined;
  set have;
  
  length combined $ 100; /* add the length of the variables to avoid data-loss */
  
  combined = catx('\', site, subjid, race, ethnicity, sex);
run;

[sneha_dodle]

How do i apply formats those variables listed in the catx function?

[andreas_lds]

If the variables are already formatted, use vvalue(variable) in catx. If not, use put-function, to apply formats while combining.

[RW9]

If you want the data concatenated for a report, then it is a good idea to do this in a dataset before the proc report step.  Have a variable specifically for the concatenated data say:

data want;
  set have;
  length demo $200;
  demo=catx("\",site,subjid,race,ethnicity,sex);
run;

Then proc report that.  Whilst proc report can do computed, you will want to have that information in the dataset you store for double programming/QC.  

[ballardw]

Example data.

Example of desired output.

Otherwise we are likely to get many "that doesn't work" from you because we have to make a lot of assumptions about values involved.

In general, proc report is going to want a single "column" to be of the same type with a single format for each cell of the format with exceptions for computed summaries.