BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi Friends,

I need to create a 4 report

1. New items—Memb that were on the previous week report but that are not on the current week reports.
2. Worked Items—Memb that are on the current report but that are not the previous week report.
3. Current report—everything on the current report
4. Summary –listing the count of the following:
a. New Items
B. worked items
C.Current report

There is no data to compare with previous week. So I have stored the present dataset in the control table for previous comparison .

Current table: present
Comparison table: previous week

I created a code as below,

Proc sql;
Create table newitem as
Select memno, var1, var2, var3
From present where memno not in (select memno from previousweek);
Quit;

Proc sql;
Create table workeditem as
Select memno, var1, var2, var3
From previousweek where memno not in (select memno from present);
Quit;

I need your helps on creating current report and summary report.

Thanks in Advance . Message was edited by: Raveenat

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 0 replies
  • 499 views
  • 0 likes
  • 1 in conversation