About Jyuen204

Jyuen204 · ‎11-20-2019

i am assuming "have" is the table name you are using in reference to my TABLE1?

Jyuen204 · ‎11-20-2019

If my table is names TableX how do i reference this in your example to get the data?

Jyuen204 · ‎11-20-2019

TABLE1 ID Name Manager DATE XXX1 Smith, John Doe, Jane 15NOV2019 XXX1 Smith, John Doe, Jane 13NOV2019 XXX1 Smith, John Crane, Frasier 3NOV2019 I am needing to rank a table of data like here. so that the most recent date is ranked the highest. I need to create a secondary table of this data where RANK = 1 so of the data examples above, I want to rank the data in the table, and create a table of the rank 1 rows. So I am only left with : XXX1 Smith, John Doe, Jane

Jyuen204 · ‎11-20-2019

Well my data isnt as clean as I am going to have multiple names and multiple dates

Jyuen204 · ‎11-20-2019

That's the data within my table, I need to rank the data an place into another table (in the ranked format above. I am ranking by date descending

Jyuen204 · ‎11-20-2019

ID Name Manager DATE XXX1 Smith, John Doe, Jane 15NOV2019 XXX1 Smith, John Doe, Jane 13NOV2019 XXX1 Smith, John Crane, Frasier 3NOV2019 Want to get the following out put in a another table ID Name Manager DATE RANK XXX1 Smith, John Doe, Jane 15NOV2019 1 XXX1 Smith, John Doe, Jane 13NOV2019 2 XXX1 Smith, John Crane, Frasier 3NOV2019 3

Jyuen204 · ‎11-20-2019

Is there any other method in doing this within SAS?

Jyuen204 · ‎11-20-2019

I am trying to build a table of of this select statement.

Jyuen204 · ‎11-20-2019

I have a table where I have an AGENT_ID, AGENT_NAME, TEAM_LEAD_NM, DATE I am trying to use Proc SQL to generate a rank because the ID and NAME are duplicated. proc sql; select AGENT_ID, AGENT_NAME, TEAM_LEAD_NM, rank() over (Partition by AGENT_LAN_ID order by sys_load_dtm desc) as RANK from TABLE where AGENT_NAME = 'Smith, John'; run; The error i get is: ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. what is the proper syntax in PROC SQL to rank my data? Thank you!

Jyuen204 · ‎11-20-2019

Ah i figured it out, one of the tables was using an alias and my brain was too tired to realize it.....

Jyuen204 · ‎11-20-2019

I have a table where I have an IDAGENT_IDAGENT_NAME, TEAM_LEAD_NM, DATE I am trying to use Proc SQL to generate a rank because the ID and NAME are duplicated. proc sql; select AGENT_ID, AGENT_NAME, TEAM_LEAD_NM, rank() over (Partition by AGENT_LAN_ID order by sys_load_dtm desc) as RANK from TABLE where AGENT_NAME = 'Smith, John'; run; The error i get is: ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. what is the proper syntac in PROC SQL to rank my data? Thank you!

Jyuen204 · ‎11-20-2019

no DB connections, just trying to bring in a value from another table

Jyuen204 · ‎11-20-2019

Tried a few options proc sql; update AGENT_TRANSFERS as A set AGENT_NAME = (select AGENT_NAME from AGENT_REPORT as B where A.SRC_AGNT_LAN_ID = B.SRC_AGNT_LAN_ID); quit; 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH='L:\Data_Analytics\Customer Data Insights\Deliverables\Recurring\Jason\BPI - Blueprints\Nordia 4 ! Package Report V6.egp'; 5 %LET _CLIENTPROJECTNAME='Nordia Package Report V6.egp'; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/6.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 proc sql; 24 update AGENT_TRANSFERS as A 25 set A.AGENT_NAME = (select B.AGENT_NAME from AGENT_TMP as B _ 73 76 ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored. 26 where A.SRC_AGNT_LAN_ID = B.AGENT_LAN_ID); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 27 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 34.06k OS Memory 22176.00k Timestamp 11/20/2019 10:48:37 AM Step Count 233 Switch Count 50 Page Faults 0 Page Reclaims 7 Page Swaps 0 Voluntary Context Switches 146 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 28 29 GOPTIONS NOACCESSIBLE; 2 The SAS System 10:12 Wednesday, November 20, 2019 30 %LET _CLIENTTASKLABEL=; 31 %LET _CLIENTPROJECTPATH=; 32 %LET _CLIENTPROJECTNAME=; 33 %LET _SASPROGRAMFILE=; 34 35 ;*';*";*/;quit;run; 36 ODS _ALL_ CLOSE; 37 38 39 QUIT; RUN;

Jyuen204 · ‎11-19-2019

Stupid question but I cant seen to get to work. I have a table with names and IDs (AGENT_REPORT) I have another table with ID's (AGENT_TRANSFERS) Trying to pull over the names to my table with ID's only proc sql; update AGENT_TRANSFERS as A set AGENT_NAME = (select AGENT_NAME from AGENT_REPORT as B where A.SRC_AGNT_LAN_ID = B.SRC_AGNT_LAN_ID); run; I get this error _ 73 76 ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored. Apologies, I'm used to coding in Toad and utilizing that syntax but trying to adapt some of this to SAS. Thank you

Jyuen204 · ‎11-06-2019

Obviously this is just a sample layout. my table generated has 6 columns of data, and many more rows, including a TOTAL row that i summed for all of the metrics i have aggregated. Name: TABLE_X Not sure how to reference the table in the code you had provided. My apologies I am pretty green at all of this. Thank you

Online Status	Offline
Date Last Visited	‎04-30-2024 06:23 PM

Re: Referencing a table that has a set of dates in SAS Date format tha...

Re: Referencing a table that has a set of dates in SAS Date format tha...

Referencing a table that has a set of dates in SAS Date format that I ...

Re: Selecting a field that was assigned a numeric heading.

Selecting a field that was assigned a numeric heading.

Re: Data conversion from Date to a Character

Data conversion from Date to a Character

SAS Excell Report - Section Column Breaks

SAS Report Define Cell Alignment

Re: %let If Then Else

Re: Case statement with Dates

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Re: Proc SQL Doing a Rank syntax

Proc SQL Doing a Rank syntax

Re: Proc Sql Updates from 2 tables

Proc SQL Ranking

Re: Proc Sql Updates from 2 tables

Re: Proc Sql Updates from 2 tables

Proc Sql Updates from 2 tables

Re: Macro enable calculation?