Hi Team, Thanks everyone for your time. It was my fault thatI didn’t provide the details about the data source. The provided code only shows one location if the locations are repeated. My data source has some locations that are repeated several times as below: data new; input Location: $200. Type : $40.Population ; cards; Collin,TX Uninsured_Pop_Num 500 Collin,TX Uninsured_Pop_Den 15000 Collin,TX Insured_Pop_Num 14500 Collin,TX Insured_Pop_Den 15000 Collin,TX White_Female_Num 500 Collin,TX White_Female_Den 15000 Plano,TX Hispanic_Female_Num 200 Plano,TX Hispanic_Femlale_Den 10000 Plano,TX Hispanic_Male_Num 300 Plano,TX Hispanic_Male_Den 10000 Richardson,TX Flu_Patient_Num 145 Richardson,TX Flu_Patient_Den 12000 ; run; Is there a way to get all the locations with your code? Below is the output that I’m looking for: Location Type Numerator Denominator Collin, TX Uninsured_Pop 500 15000 Collin, TX Insured_Pop 200 10000 Collin, TX White_Female 500 15000 Collin, TX White_Male 12000 15000 Plano, TX Hispanic_Female 200 10000 Plano, TX Hispanic_Male 300 10000 Richardson, TX Flu_Patient 145 12000 Thanks again. Roger
... View more