topic Re: How to get desired output in SAS Data Management

How to get desired output

sasuser123123 — Wed, 29 Jan 2020 06:33:08 GMT

Hello!
I've data like

Data new;
Input Country$ Name$ Tr1 Tr2 Tot;
Cards;
EUR Count 3 6 9
EUR Percent 15 30 45
NOA Count 7 4 11
NOA Percent 35 20 55
;

So Need output like....

COUNTRY TR1 TR2 TOT
EUR 3(15) 6(30) 9(45)
NOA 7(35) 4(20) 11(55)

Could anyone please help me that how to do this task..

Thank you...

Regards.

Re: How to get desired output

PeterClemmensen — Wed, 29 Jan 2020 06:35:14 GMT

Why do you want to do this? For reporting purposes?

Re: How to get desired output

sasuser123123 — Wed, 29 Jan 2020 06:37:42 GMT

Yes

Re: How to get desired output

Kurt_Bremser — Wed, 29 Jan 2020 07:58:25 GMT

A first step to create the concatenated variables can be this:

proc sql;
create table want as
select
  a.country,
  cats(a.tr1,'(',b.tr1,')') as tr1,
  cats(a.tr2,'(',b.tr2,')') as tr2,
  cats(a.tot,'(',b.tot,')') as tot
from
  (select country,tr1,tr2,tot from new where name ='Count') a
inner join
  (select country,tr1,tr2,tot from new where name ='Percent') b
on a.country = b.country;
quit;

Re: How to get desired output

ballardw — Wed, 29 Jan 2020 16:29:34 GMT

@sasuser123123 wrote:
Hello!
I've data like

Data new;
Input Country$ Name$ Tr1 Tr2 Tot;
Cards;
EUR Count 3 6 9
EUR Percent 15 30 45
NOA Count 7 4 11
NOA Percent 35 20 55
;

So Need output like....

COUNTRY TR1 TR2 TOT
EUR 3(15) 6(30) 9(45)
NOA 7(35) 4(20) 11(55)

Could anyone please help me that how to do this task..

Thank you...

Regards.

If that data structure is the result of summarizing something it might be better off to go back to a raw form of the data and create the report you want directly. If this is the case can you provide an example of the raw data before that summary?