topic Re: split data in proc report in SAS Programming

split data in proc report

pdhokriya — Thu, 22 Jul 2021 14:46:53 GMT

How should I split the data by using proc report.

Column name has John Clark David John Clark and David.

Name

John Clark David John Clark David

Required output is

Name

John

Clark

David

John

Clark

David

Re: split data in proc report

ballardw — Thu, 22 Jul 2021 14:53:15 GMT

To which output destination? Some approaches may differ depending on whether you expect html, PDF, RTF or plain text files to be generated.

You will get better responses to questions if you provide some example data in the form of data step code and your current Proc report code.

Some "solutions" may only work if your variable is using a specific role in Proc Report in relation to other variables so we need to know more about the entire process.

Re: split data in proc report

pdhokriya — Thu, 22 Jul 2021 17:54:10 GMT

The destination should be RTF.

data have ;
name = "John Clark David John Clark David";output;
run;

proc report data=have;
run;