About Rock3t4u

Rock3t4u · ‎04-08-2023

In the macro mentioned https://support.sas.com/resources/papers/proceedings16/7820-2016.pdf, I do not see the parameters p_sumedvar and p_groupedvar included. Can you post the macro collapse_data you used to get the below result. Thanks. collapse_data

Rock3t4u · ‎04-07-2023

Hi Ahmed, Thank you for the reply. I updated the condition.

Rock3t4u · ‎04-07-2023

Thanks for the reply. But the collapsing should be based on the condition[(given<4) and (taken>1)]. I will be dealing with huge dataset and collapsing should be only based on condition.

Rock3t4u · ‎04-07-2023

I have a dataset as below. I have the condition that if [(given<4) and (taken>=1)] then I have to sum up(collapse cells) for given and taken variables by grouping into company, area, division . company area division state given taken xxx MW MW_1 MP 3 7 xxx MW MW_1 UP 8 3 xxx E S_1 MN 5 4 xxx NE NE_1 AP 2 1 xxx NE NE_1 TN 1 1 xxx NE NE_2 TL 6 2 yyy MW MW_1 MP 3 4 yyy MW MW_1 OH 2 7 The result table should be as below for collapsed 1. I have no clue how to code this in SAS. company area division geography given taken xxx MW MW_1 MP_UP 11 10 xxx E S_1 MN 5 4 xxx NE NE_1 AP_TN 3 2 xxx NE NE_2 TL 6 2 yyy MW MW_1 MP_OH 5 11

Online Status	Offline
Date Last Visited	‎04-09-2023 11:25 AM

Re: Needed to collapse cells based on the condition in a SAS dataset.

Re: Needed to collapse cells based on the condition in a SAS dataset.

Re: Needed to collapse cells based on the condition in a SAS dataset.

Needed to collapse cells based on the condition in a SAS dataset.

Re: Needed to collapse cells based on the condition in a SAS dataset.

Re: Needed to collapse cells based on the condition in a SAS dataset.

Re: Needed to collapse cells based on the condition in a SAS dataset.

Needed to collapse cells based on the condition in a SAS dataset.