About scb

scb · ‎05-17-2021

I would like to have PAUL (played multiple teams) target or any player target that have played for multiple teams to be put in the last team he played for to avoid duplicate target. Anyone can help? Thanks. DATA TEST; infile DATALINES DLM=',' DSD; INPUT SEASON PLAYER $ DIV $ TEAM $ TARGET; DATALINES; 202101, JOHN,003,001,10 202102, JOHN,003,001,15 202103, JOHN,003,001,16 202101, PAUL,003,002,20 202101, PAUL,003,003,20 202101, PAUL,003,004,20 202102, PAUL,003,002,25 202102, PAUL,003,003,25 202102, PAUL,003,004,25 202103, PAUL,003,002,35 202103, PAUL,003,003,35 202103, PAUL,003,004,35 202101, KENT,,005,42 202102, KENT,,005,45 202103, KENT,,005,46 ; RUN; My desired output will be: Season Player Div Team Target 202101 JOHN 003 001 10 202102 JOHN 003 001 15 202103 JOHN 003 001 16 202101 PAUL 003 002 0 202101 PAUL 003 003 0 202101 PAUL 003 004 20 202102 PAUL 003 002 0 202102 PAUL 003 003 0 202102 PAUL 003 004 25 202103 PAUL 003 002 0 202103 PAUL 003 003 0 202103 PAUL 003 004 35 202101 KENT 005 42 202102 KENT 005 45 202103 KENT 005 46

scb · ‎02-15-2021

Yes, is it possible?

scb · ‎02-15-2021

I tried to put the report title for each of the proc report, but it seems that the different titles just did not appear at the right place. Anyone can help? Thanks. DATA T1; SET SASHELP.CARS; IF ORIGIN EQ 'Asia' AND TYPE EQ 'SUV'; KEEP MAKE MODEL TYPE ORIGIN; RUN; DATA T2; SET SASHELP.CARS; IF MAKE EQ 'Acura'; KEEP MAKE MODEL TYPE ORIGIN INVOICE; RUN; DATA T3; SET SASHELP.CARS; IF INVOICE GE 100000; KEEP MAKE MODEL TYPE ORIGIN INVOICE; RUN; %LET OUTPATH = C:\test\test.PDF; OPTIONS ORIENTATION=LANDSCAPE PAPERSIZE=A5; OPTIONS NODATE; OPTIONS LINESIZE=130 PAGESIZE=60 CENTER; ODS PDF FILE="&OUTPATH" STARTPAGE=NO; PROC REPORT DATA=T1; TITLE1 'SUV from Asia'; COLUMN MAKE MODEL TYPE ORIGIN; DEFINE MAKE / DISPLAY 'Brand'; DEFINE MODEL / DISPLAY 'Model'; DEFINE TYPE / DISPLAY 'Type'; DEFINE ORIGIN / DISPLAY 'Origin'; RUN; PROC REPORT DATA=T2; TITLE2 'Car Price by Acura'; COLUMN MAKE MODEL TYPE ORIGIN; DEFINE MAKE / DISPLAY 'Brand'; DEFINE MODEL / DISPLAY 'Model'; DEFINE TYPE / DISPLAY 'Type'; DEFINE ORIGIN / DISPLAY 'Origin'; DEFINE INVOICE / DISPLAY 'Price'; RUN; PROC REPORT DATA=T3; TITLE3 'Car Price over 100k'; COLUMN MAKE MODEL TYPE ORIGIN INVOICE; DEFINE MAKE / DISPLAY 'Brand'; DEFINE MODEL / DISPLAY 'Model'; DEFINE TYPE / DISPLAY 'Type'; DEFINE ORIGIN / DISPLAY 'Origin'; DEFINE INVOICE / DISPLAY 'Price'; RUN; ODS PDF CLOSE; ODS LISTING;

scb · ‎11-04-2020

Can anyone help? Thanks in advance. I have the following dataset: 1) Captain will override all the score of the team 2) Deputy Captain (A2) will override his own Region score (within the same team) 3) A3 will override A4 score within his region and city (within the same team) DATA TEAM; INPUT PLAYER $ TEAM_NAME $ SUBTEAM $ RANK $ REGION $ CITY $ SCORE; DATALINES; P1 SUPER CAPTAIN A1 . . . P2 SUPER T1 A2 R1 . . P3 SUPER T1 A3 R1 C1 . P4 SUPER T1 A3 R1 C2 . P5 SUPER T1 A4 R1 C1 20 P6 SUPER T1 A4 R1 C1 50 P7 SUPER T1 A4 R1 C1 50 P8 SUPER T1 A4 R1 C2 80 P9 SUPER T1 A4 R1 C2 70 P10 SUPER T1 A4 R1 C2 90 P2 SUPER T2 A2 R5 . . P3 SUPER T2 A3 R5 C8 . P4 SUPER T2 A3 R5 C9 . P5 SUPER T2 A4 R5 C8 20 P6 SUPER T2 A4 R5 C8 50 P7 SUPER T2 A4 R5 C9 50 P8 SUPER T2 A4 R5 C9 80 P1 EAGLE CAPTAIN A1 . . . P2 EAGLE T2 A3 R2 C3 . P3 EAGLE T2 A3 R2 C4 . P4 EAGLE T2 A4 R2 C3 20 P5 EAGLE T2 A4 R2 C3 70 P6 EAGLE T2 A4 R2 C3 40 P7 EAGLE T2 A4 R2 C4 60 P8 EAGLE T2 A4 R2 C4 50 P9 EAGLE T2 A4 R2 C4 80 P1 BULL CAPTAIN A1 . . . P2 BULL T3 A2 R3 . . P3 BULL T3 A3 R3 . 10 P4 BULL T3 A3 R3 . 80 P5 BULL T3 A3 R3 . 30 P6 BULL T3 A3 R3 . 60 P7 BULL T3 A3 R3 . 10 P8 BULL T3 A3 R3 . 60 P9 BULL T3 A3 R3 . 100 P2 BULL T4 A2 R4 . . P3 BULL T4 A3 R4 . 20 P4 BULL T4 A3 R4 . 30 P5 BULL T4 A3 R4 . 40 P6 BULL T4 A3 R4 . 40 P7 BULL T4 A3 R4 . 50 P8 BULL T4 A3 R4 . 60 P9 BULL T4 A3 R4 . 80 ; run; Desired result: Player Team_Name SubTeam Rank Region City Score P1 SUPER CAPTAIN A1 . . 560 P2 SUPER T1 A2 R1 360 P3 SUPER T1 A3 R1 C1 120 P4 SUPER T1 A3 R1 C2 240 P5 SUPER T1 A4 R1 C1 20 P6 SUPER T1 A4 R1 C1 50 P7 SUPER T1 A4 R1 C1 50 P8 SUPER T1 A4 R1 C2 80 P9 SUPER T1 A4 R1 C2 70 P10 SUPER T1 A4 R1 C2 90 P2 SUPER T2 A2 R5 200 P3 SUPER T2 A3 R5 C8 70 P4 SUPER T2 A3 R5 C9 130 P5 SUPER T2 A4 R5 C8 20 P6 SUPER T2 A4 R5 C8 50 P7 SUPER T2 A4 R5 C9 50 P8 SUPER T2 A4 R5 C9 80 P1 EAGLE CAPTAIN A1 320 P2 EAGLE T2 A3 R2 C3 130 P3 EAGLE T2 A3 R2 C4 190 P4 EAGLE T2 A4 R2 C3 20 P5 EAGLE T2 A4 R2 C3 70 P6 EAGLE T2 A4 R2 C3 40 P7 EAGLE T2 A4 R2 C4 60 P8 EAGLE T2 A4 R2 C4 50 P9 EAGLE T2 A4 R2 C4 80 P1 BULL CAPTAIN A1 670 P2 BULL T3 A2 R3 350 P3 BULL T3 A3 R3 10 P4 BULL T3 A3 R3 80 P5 BULL T3 A3 R3 30 P6 BULL T3 A3 R3 60 P7 BULL T3 A3 R3 10 P8 BULL T3 A3 R3 60 P9 BULL T3 A3 R3 100 P2 BULL T4 A2 R4 320 P3 BULL T4 A3 R4 20 P4 BULL T4 A3 R4 30 P5 BULL T4 A3 R4 40 P6 BULL T4 A3 R4 40 P7 BULL T4 A3 R4 50 P8 BULL T4 A3 R4 60 P9 BULL T4 A3 R4 80

scb · ‎11-03-2020

Is there any chance to get the CAPTAIN name for the TEAM dataset? Anyone can help, thanks? DATA TEAM; INPUT TEAM $ SUBTEAM $ CATEGORY $; DATALINES; 200 001 . 300 . A1 400 002 . 500 . A2 ; run; DATA CAPTAIN; INPUT SUBTEAM $ CATEGORY $ CAPTAIN $; DATALINES; 001 . GIGGS . A1 JOHN 002 . MELISSA . A2 CINDY ; run; Desired result: TEAM SUBTEAM CATEGORY CAPTAIN 200 001 GIGGS 300 A1 JOHN 400 002 MELISSA 500 A2 CINDY

scb · ‎10-31-2020

May I know how to split dataset into diff dataset based on diff team? I could have 900 teams. Thanks. DATA have; INPUT ID $ Team $ Point; DATALINES; 111 T1 100 112 T1 300 113 T1 600 111 T2 550 112 T2 770 113 T2 890 111 T3 1000 112 T3 3003 113 T3 6003 ; run; Desired result dataset1 name: T1 ID Team Point 111 T1 100 112 T1 300 113 T1 600 dataset2 name: T2 ID Team Point 111 T2 550 112 T2 770 113 T2 890 dataset3 name: T3 ID Team Point 111 T3 1000 112 T3 3003 113 T3 6003

scb · ‎08-05-2020

I am sorry that I should have taken the id 100 out. Post a2 should always start with 0; and post a3 should always start with 1. T1 to T3 is correct, but I need help for T4. Thanks. data a; input id $3. team $4. post $4.; datalines; 101 t1 a2 102 t1 a3 200 t2 a2 201 t2 a3 300 t3 a2 301 t3 a3 302 t3 a3 400 t4 a3 401 t4 a3 ; run; data a; set a; by team post; seq+1; if first.team then seq=0; proc sort; by team post seq; run;

scb · ‎08-05-2020

The below program generated correct output for T1 to T3, but not T4. Seq for post a3 should never start with 0, seq for post a3 should always start with 1. Anyone can help? Thanks. data a; input id $3. team $4. post $4.; datalines; 101 t1 a2 102 t1 a3 200 t2 a2 201 t2 a3 300 t3 a2 301 t3 a3 302 t3 a3 400 t4 a3 401 t4 a3 ; run; data a; set a; by team post; seq+1; if first.team then seq=0; proc sort; by team post seq; run;

scb · ‎05-02-2020

May I know how to calculate the sum for team1 with finish le 3 for team1, and finish le 5 for team2 (as stated in below code) for both temp_cl columns? DATA TEST; INPUT ID TEAM $ RANK $ CL1 CL2 FINISH; DATALINES; 120 T1 A1 0 0 1 121 T1 A2 20 30 1 122 T1 A2 30 50 2 123 T1 A2 40 60 3 124 T1 A2 50 40 4 125 T1 A2 60 30 5 220 T2 A1 0 0 1 221 T2 A2 24 130 1 222 T2 A2 34 150 2 223 T2 A2 44 160 3 224 T2 A2 54 140 4 225 T2 A2 64 130 5 ; RUN; PROC SQL; CREATE TABLE TEST1 AS SELECT *, COALESCE((SELECT SUM(CL1) FROM TEST WHERE TEAM=A.TEAM AND FINISH LE 5),CL1) AS TEMP_CL1, COALESCE((SELECT SUM(CL2) FROM TEST WHERE TEAM=A.TEAM AND FINISH LE 5),CL2) AS TEMP_CL2 FROM TEST A; QUIT

scb · ‎01-07-2020

The penalties is 829, but winning is 800 only. Penalties cannot more than winning, hence can only deduct max 800 for ID 113.

scb · ‎01-07-2020

I have the below dataset, and both dataset is linked by ID. I would like to deduct the penalty from the winning; and to get the final penalty balance for individual case. Anyone can help? Many Thanks. DATA PENALTY; INPUT GAME $ CASE $ ID $ PENALTY; CARDS; CC C1 111 480 HL H1 111 1120 SI S1 111 800 CC C2 112 750 SI S2 113 829 ; RUN; DATA WINNING; INPUT ID $ WINNING; CARDS; 111 3000 112 700 113 800 ; RUN; Desired output: Dataset Winning (Penalties variable is the aggregate of penalty variable for individual ID, and must not more than the "winning") ID Winning Penalties Final 111 3000 2400 600 112 700 700 0 113 800 800 0 Dataset Penalty (Balance variable is the balance penalties that have not been deducted from the winning) GAME CASE ID PENALTY BALANCE CC C1 111 480 0 HL H1 111 1120 0 SI S1 111 800 0 CC C2 112 750 50 SI S2 113 829 29

scb · ‎10-14-2019

May I know how to get the total TYPE1 and total TYPE2 cases? The underlined total. Thanks. Example Output Type Type1 Type2 Done WIP TOTAL Done WIP TOTAL Period1 1 0 1 2 1 3 Period2 1 1 2 4 2 6 Total 2 1 3 6 3 9 DATA STATUS; INPUT PERIOD $ STATUS $ TYPE $ CASE; DATALINES; 201801 Done Type1 1 201801 Done Type2 1 201802 WIP Type1 1 201802 Done Type2 1 201802 Done Type1 1 201802 WIP Type2 1 201803 Done Type1 1 201803 WIP Type2 1 ; run; proc tabulate data=status; class Period Type Status ; var case; table Period all='Total', (Type*Status='')*(N=''*F=8.) / Misstext='0'; Run;

scb · ‎10-12-2019

I have rectified the code, thanks.

scb · ‎10-12-2019

May I know how to get the "events" into the project dataset when the period is in between the event startdate and enddate? data Project; format Period Date9.; input Period Date9. Project $; datalines; 12JAN2019 ProjectA 16FEB2019 ProjectB 17APR2019 ProjectC ; RUN; data Event; FORMAT DATESTART DATE9.; FORMAT DATEEND DATE9.; input DATESTART:DATE9. DATEEND:DATE9. EVENT $10.; DATALINES; 01JAN2019 12JAN2019 TESTING_A 13JAN2019 17FEB2019 TESTING_B 15FEB2019 18APR2019 TESTING_C 02MAY2019 04MAY2019 TESTING_D ; RUN; My desired result will be: Period Project Event 12JAN2019 ProjectA TESTING_A 16FEB2019 ProjectB TESTING_B, TESTING_C 17APR2019 ProjectC TESTING_C Any idea? Thanks.

scb · ‎09-03-2019

May I know how to make the proc report data appear in page1 instead of page2? I run the below codes; but the proc report data output appeared on page2, not on page1 after the ods text. Can anyone help? Thank you very much. ods pdf file='c:\sastest\test.pdf' style=minimal; proc tabulate data=sashelp.cars format=dollar14.2; class type; var invoice msrp; table type, msrp invoice msrp*pctsum<invoice>='Ratio of MSRP to Invoice'*f=8.2; run; ODS TEXT = "TRANSACTION RECORDS"; PROC REPORT DATA=SASHELP.CARS(Where=(Make='Volvo')) style(header)=[background=tan] NOWINDOWS HEADLINE HEADSKIP; COLUMNS MAKE MODEL INVOICE; DEFINE MAKE /GROUP 'Car Brand'; DEFINE MODEL /GROUP 'Car Model'; DEFINE INVOICE / ANALYSIS 'INVOICE' FORMAT=DOLLAR16.2; RBREAK AFTER/ SUMMARIZE; RUN; ODS PDF CLOSE; ODS LISTING;

Online Status	Offline
Date Last Visited	‎05-19-2021 06:07 AM

SAS queries

Re: Multiple title in Proc Report

Multiple title in Proc Report

SAS Query - Score Overriding query

How to add information from one data set to another data set?

SAS query - Split data to different dataset

Re: SAS query

SAS query

Proc SQL Query

Re: SAS Query

Re: SAS Query - Score Overriding query

Re: SAS import text file

Re: SAS import text file

Proc Tabulate Query

Calculate percentage of total

SAS queries

Re: Multiple title in Proc Report

Multiple title in Proc Report

SAS Query - Score Overriding query

How to add information from one data set to another data set?

SAS query - Split data to different dataset

Re: SAS query

SAS query

Proc SQL Query

Re: SAS Query

SAS Query

Proc Tabulate Query

Re: SAS Queries

SAS Queries

Proc Tabulate Query