BookmarkSubscribeRSS Feed
Doe
Calcite | Level 5 Doe
Calcite | Level 5

I have a  data the below below format

 CodeCompany NameItem2019
DINDIN LimitedAnnual Balance Sheet - Total Equity16,925,931.00
DINDIN LimitedAnnual Balance Sheet - NCA PP&E135,487.00
DINDIN LimitedAnnual Balance Sheet - NCA Intangibles(ExGW)5,109,045.00
DINDIN LimitedAnnual Balance Sheet - NCA Goodwill0.00
DINDIN LimitedAnnual Profit and Loss - Reported NPAT After Abnorma-4,270,815.00
DINDIN LimitedAnnual Profit and Loss - Total Revenue Excluding Int60,273.00
DINDIN LimitedAnnual Profit and Loss - Shares Outstanding at Perio172,389,923.00
DINDIN LimitedAnnual Ratio Analysis - Market Cap.($)50,855,027.28

 

I would like to convert to a wide format as shown below

 CodeCompany NameAnnual Balance Sheet - Total EquityAnnual Balance Sheet - NCA PP&EAnnual Balance Sheet - NCA Intangibles(ExGW)Annual Balance Sheet - NCA GoodwillAnnual Profit and Loss - Reported NPAT After AbnormaAnnual Profit and Loss - Shares Outstanding at PerioAnnual Ratio Analysis - Market Cap.($)
DINDIN Limited16,925,931.00135,487.005,109,045.000.00-4,270,815.00172,389,923.0050,855,027.28
2 REPLIES 2
Rick_SAS
SAS Super FREQ

Please do not post the same question twice.

 

This is a duplicate of

https://communities.sas.com/t5/SAS-Programming/Converting-from-Long-to-Wide-Format/m-p/719567

and people are responding to the question in that forum.

Doe
Calcite | Level 5 Doe
Calcite | Level 5

Very well noted. Thanks