topic Re: How do we put multiple variables into a single column in proc report? in SAS Procedures

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

sneha_dodle — Mon, 11 Mar 2019 07:26:53 GMT

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

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

andreas_lds — Mon, 11 Mar 2019 07:35:54 GMT

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;

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

sneha_dodle — Mon, 11 Mar 2019 09:27:22 GMT

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

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

andreas_lds — Mon, 11 Mar 2019 09:30:34 GMT

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

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

RW9 — Mon, 11 Mar 2019 10:41:05 GMT

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.

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

ballardw — Mon, 11 Mar 2019 17:25:50 GMT

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.