BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi Guys,


I am new to SAS Enterpise Guide 4.2 and would need your help in running a query.

Below is the table format:

BankID MemberNo AprilBills MayBills JuneBills
1111 1234 4 0 5
1111 6789 5 5 0
1111 5432 3 0 4
1111 7777 12 78 65


I am trying to create a report of "What was the count of members by BankID that paid 1 or more bills in April,May and June"

so the end result should be

BankID April May June
1111 4 2 3

PLease let me know how can i use the tool and do less coding in the above report.
Thank again for your help!
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
I's attack this as part query (to create the indicator variables of a bill being paid) and a procedure to summarize. You may be able to combine in TABULATE or REPORT.

First the Query. Recode each of the bill variables to be 0, 1 (>0) , or NULL.
Then you can use MEANS or SUMMARY with the SUM output (Descriptive Statistics task) or FREQ (tables task) to get the counts. If you are looking for summary data to use downstream, MEANS would be cleanest in EGuide.
deleted_user
Not applicable
Thanks Duke!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 541 views
  • 0 likes
  • 2 in conversation