02-02-2021
gregor1
Quartz | Level 8
Member since
06-23-2016
- 58 Posts
- 17 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by gregor1
Subject Views Posted 1056 02-02-2021 12:20 PM 1194 01-29-2021 11:37 AM 1209 11-20-2020 11:51 AM 1215 11-20-2020 11:44 AM 1215 11-20-2020 11:41 AM 1320 11-19-2020 04:03 PM 926 11-04-2020 11:59 AM 836 08-27-2020 05:34 PM 843 08-27-2020 05:20 PM 875 08-27-2020 04:59 PM -
Activity Feed for gregor1
- Posted Re: Previous month filter on All Things Community. 02-02-2021 12:20 PM
- Posted Previous month filter on All Things Community. 01-29-2021 11:37 AM
- Posted Re: Capture value from row in table base column values in EG on SAS Enterprise Guide. 11-20-2020 11:51 AM
- Liked Re: Capture value from row in table base column values in EG for Reeza. 11-20-2020 11:51 AM
- Posted Re: Capture value from row in table base column values in EG on SAS Enterprise Guide. 11-20-2020 11:44 AM
- Posted Re: Capture value from row in table base column values in EG on SAS Enterprise Guide. 11-20-2020 11:41 AM
- Liked Re: Capture value from row in table base column values in EG for mkeintz. 11-20-2020 11:40 AM
- Liked Re: Capture value from row in table base column values in EG for ballardw. 11-20-2020 11:35 AM
- Posted Capture value from row in table base column values in EG on SAS Enterprise Guide. 11-19-2020 04:03 PM
- Posted Make temporary JSON file data more permanent for further use in SAS project tree on SAS Enterprise Guide. 11-04-2020 11:59 AM
- Posted Re: Partial string need from variable character lengths on SAS Enterprise Guide. 08-27-2020 05:34 PM
- Posted Re: Partial string need from variable character lengths on SAS Enterprise Guide. 08-27-2020 05:20 PM
- Liked Re: Partial string need from variable character lengths for ballardw. 08-27-2020 05:16 PM
- Posted Partial string need from variable character lengths on SAS Enterprise Guide. 08-27-2020 04:59 PM
- Posted Re: Transpose in SAS EG bringing only one row of data on SAS Enterprise Guide. 08-21-2020 05:04 PM
- Posted Re: Transpose in SAS EG bringing only one row of data on SAS Enterprise Guide. 08-21-2020 05:03 PM
- Liked Re: Transpose in SAS EG bringing only one row of data for Reeza. 08-21-2020 05:02 PM
- Posted Transpose in SAS EG bringing only one row of data on SAS Enterprise Guide. 08-21-2020 01:00 PM
- Got a Like for Re: Apparent symbolic reference URL. 08-11-2020 09:32 PM
- Posted Re: Apparent symbolic reference URL on SAS Enterprise Guide. 08-11-2020 05:19 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 08-11-2020 05:19 PM
07-28-2017
06:14 PM
Thanks Reeza...you are correct! Sometimes being too close doesn't allow one to see the forest that is right in front of one!
... View more
07-28-2017
05:08 PM
I have tables A and B below. I want to combine them to get table C below. Table A REFERRED_DATE STATE PRODUCT_TYPE LOB 07/04/2016 WI CLASSIC AUTO 07/04/2016 KS CLASSIC AUTO 07/04/2016 OH CLASSIC AUTO Table B REFERRED_DATE STATE PRODUCT_TYPE LOB 07/06/2016 MN CLASSIC AUTO 07/06/2016 MN CLASSIC AUTO 07/06/2016 AZ CLASSIC AUTO Table C REFERRED_DATE STATE PRODUCT_TYPE LOB 07/04/2016 WI CLASSIC AUTO 07/04/2016 KS CLASSIC AUTO 07/04/2016 OH CLASSIC AUTO 07/06/2016 MN CLASSIC AUTO 07/06/2016 MN CLASSIC AUTO 07/06/2016 AZ CLASSIC AUTO
... View more
07-28-2017
05:00 PM
I am really trying to get the natural full outer join (the output rows include all rows from both tables and rows that do not have a match are filled in with missing values). This has worked fine in my earlier joins, but is giving me extra rows of data in my later joins.
... View more
07-28-2017
04:56 PM
Thanks Reeza...I understand what you are saying and that is what I want (essentially merging the two tables (both have the same columns) together. However, when I join them the 2 + 2 = 5 rows of data instead of 4.
... View more
07-28-2017
04:12 PM
Thanks ballardw. I tried your suggestion with the following code. PROC SQL; CREATE TABLE WORK.QUERY_FOR_QUERY_JOIN2_0000 AS SELECT /* STATE */ (IFC(t1.STATE<>" ",t1.STATE,t2.STATE)) LABEL="STATE" AS STATE FROM WORK.QUERY_JOIN2 t1 NATURAL JOIN WORK.QUERY_JOIN4 t2; QUIT; However, now I get way too few lines of output (2030 when I should have 61,266). Not sure where I am going wrong.
... View more
07-28-2017
03:38 PM
I have been joining several tables one step at a time as I build my project (e.g., table A to Table B; Table C to Table D; etc.). I am at the point where I am joining those table to each other (e.g., Table AB to Table CD, etc.). Below is my code for two of those tables and the results are good. However, I use the exact same coding all the way through and on other tables and I get the join but the volume of lines result in about 1600 more lines than the two table combined contain. I am not sure why and have been looking for a reason. Any thoughts? PROC SQL; CREATE TABLE WORK.QUERY_JOIN7(label="QUERY_JOIN7") AS SELECT /* REFERRED_DATE */ (IFN(t1.REFERRED_DATE<>.,t1.REFERRED_DATE,t2.REFERRED_DATE)) FORMAT=MMDDYYS10. LABEL="REFERRED DATE" AS REFERRED_DATE, /* STATE */ (IFC(t1.STATE<>" ",t1.STATE,t2.STATE)) LABEL="STATE" AS STATE, /* PRODUCT_TYPE */ (IFC(t1.PRODUCT_TYPE<>" ",t1.PRODUCT_TYPE,t2.PRODUCT_TYPE)) LABEL="PRODUCT TYPE" AS PRODUCT_TYPE, /* LOB */ (IFC(t1.LOB<>" ",t1.LOB,t2.LOB)) LABEL="LOB" AS LOB, /* REFERRAL_TYPE */ (IFC(t1.REFERRAL_TYPE<>" ",t1.REFERRAL_TYPE,t2.REFERRAL_TYPE)) LABEL="REFERRAL TYPE" AS REFERRAL_TYPE, /* VOLUME */ (1) FORMAT=BESTX10. LABEL="VOLUME" AS VOLUME FROM WORK.QUERY_JOIN5 t1 NATURAL FULL JOIN WORK.QUERY_JOIN6 t2; QUIT; Thanks!
... View more
10-13-2016
04:15 PM
Thanks Patrick...this helped and I was able to get what I needed. The only thing else I wanted to do to edit your code is to pull in the "have" data for the "datalines; WITEAM 9 12 WI1TEAM 10 8 WI2TEAM 6 4 WI3TEAM 8 6" instead of manually entering them in to the code. Otherwise, it works perfectly and saves me a lot of time.
... View more
10-12-2016
01:25 PM
Thanks Ksharp...this is close but not quite there. For example, let's say I have the following table: TEAM CALLS_IN CALLS_ANSWRD WITEAM 9 12 WI1TEAM 10 8 WI2TEAM 6 4 WI3TEAM 8 6 I want the end table to include the WI1, WI2 and WI3 counts plus 1/3 of the WITEAM addede to each of those counts. So the want table would look like: TEAM CALLS_IN CALLS_ANSWRD WI1TEAM 13 12 WI2TEAM 9 8 WI3TEAM 11 10
... View more
10-10-2016
09:34 AM
Thanks Ksharp...that's what I have been doing, but I was hoping that there would be an easier method. I appreciate your help. Thanks!
... View more
10-07-2016
04:11 PM
Yes, I know, but the output does not look like that there is no input nor data...I will keep trying to get what you need. Thanks!
... View more
10-07-2016
01:13 PM
I am having a problem in providing the data code you asked for. In the link it says to load to the Autoexec file, but I have a problem there. I am running on a company server through CITRIX and I don't have administrative rights. I did load the macro as a separate program in my project and linked it to the data table, but I don't think it is giving me what you are requesting for the data code.
... View more
10-07-2016
10:43 AM
As part of a SAS project, I pulled a query of phone call data that will eventually be joined with other tables. However, in the Team column, there are the following lines: WI TEAM, WI1/IN TEAM, WI2 TEAM and WI3 TEAM. I want to equally divide the counts for the WI TEAM amongst the other three teams and add to their counts. How can I do this in Enterprise Guide? I don't want to export to Excel, edit and then reload back to SAS. I have attached a screen copy of the table.
... View more
07-19-2016
02:06 PM
I have three columns which I want to use to get a sum. It looks like this: TEAM Team Count One Team's Share 1 61456 2 56788 3 25524 4 32256 5 78552 6 44796 7 38128 8 112586 9 1532 510.6666667 10 9560 3186.666667 11 616 205.3333333 12 31712 10570.66667 13 20528 6842.666667 14 17060 5686.666667 15 9956 For the new column: I want the sum of the value for Team 3's Team Count & Team 11's One Team's Share value. I want that sum to be in a fourth column and on the same row as Team 3. I need a function that will accomplish similarly for each of the Teams 1 - 8 and 15. Can anyone help me? Thank you!
... View more
06-23-2016
04:17 PM
Perfect! That is what I was looking for Reeza. I need to remember the SCAN function...Thanks!!
... View more
06-23-2016
03:46 PM
I ran a query that returns a column of data that I want to go from text to column (much like I can do in Excel). For example, the returned data looks like this: "NV District 600" (all listed as one piece of data in a single column). However, I really only want the "NV" as a single piece of data in it's own column, the "District" as another piece of data in it's own column, and the "600" as a single piece of data in it's own column. What is the best way to accomplish this in EG?
... View more
- « Previous
- Next »