topic ungroup objects in a dataset in SAS Enterprise Guide

ungroup objects in a dataset

FaridNasrAlDeen — Tue, 08 Mar 2022 09:00:29 GMT

Hello everyone. I wonder how can I ungroup objects in a dataset using an sql code?
I have a dataset containing several companies. I used "casewhen" to group companies in one batch. For companies that I needed to have data on individually I indicated their tax id numbers.
My question is: How can I form a table of data without indicating individual group numbers there?

Re: ungroup objects in a dataset

andreas_lds — Tue, 08 Mar 2022 10:05:23 GMT

I don't have any idea what "ungroup" could mean.

Please post the data you have in usable form and the expected result.

Re: ungroup objects in a dataset

FaridNasrAlDeen — Tue, 08 Mar 2022 10:23:45 GMT

Unfortunately, I cannot post data.

However I can describe the task from a different perspective.

Let us say I have 5 companies with various commercial indicators related to
them.

I created a variable "Major Companies" by introducing a code:

%let Major_Companies = ('023478', '785466', '667743');

*Now I use proc sql to create a table:*

proc sql;

create table month_report as
select
date,
type,
payment_form,
product_type,
CASE
WHEN CLIENT IN &Major_Companies THEN CLIENT
WHEN cash_disb = 'Y' THEN 'Cash_payments'
ELSE 'OTHERS'
end as 'client1'

The code is slightly larger, but what I want is to include all customers in
the table without grouping them into "Others" pack. Can that be done by
deleting that string of code or should I specify ALL in the parenthesis
when I introduce the Major_Companies variable?

Re: ungroup objects in a dataset

Reeza — Tue, 08 Mar 2022 16:13:56 GMT

Make some fake data in Excel that mimics your actual data.

Seems like you could just group on the CLIENT field instead of CLIENT1 field instead to get what you want?
Depends what you want to do with that second condition:
WHEN cash_disb = 'Y' THEN 'Cash_payments'

Re: ungroup objects in a dataset

Sajid01 — Fri, 11 Mar 2022 20:14:53 GMT

Hello @FaridNasrAlDeen
From the code you have shown , you are using case statement to create a new variable client1.
The rest of the data is intact.
Just ignore this variable.