About RPYee

RPYee · ‎02-22-2024

This WORKED LIKE A CHARM!! At least, I did what you said and my programs ran fine. Now, I'm just waiting for the DBA to confirm the success, but I'm confident it's working. I appreciate your help!

RPYee · ‎02-22-2024

I sent your suggestion to my administrator. He said he'd take care of it. I am using the custom option selection in the meantime. Thanks for your input!

RPYee · ‎02-21-2024

I have a SAS Metadata Repository profile that I log into when I open the software: Once I log in, my database is listed in the Servers list: If I right-click on the database that I want to use and select "Properties", it shows an area under "Options" that looks like I might be able to define a new connection mode, but I have no idea where this statement holds its information. (see below) Hope this gives you some ideas what I'm working with. I appreciate your help!

RPYee · ‎02-21-2024

History: I use SAS Enterprise Guide 8.3 to connect to a Teradata Database. I DO NOT CODE. I create a new process flow, drag and drop tables, then build a query with them. I may do a series of queries from the results of the original query. I will often do Summary Tables. Issue: Apparently, I am connecting to the Teradata database using the mode ANSI. My peers all code in SAS EG, never using the process flow. They are able to alter the LIBNAME statement for each of their projects to set the mode to TERA, or TERADATA, whatever the case may be. I do not have this option when using the process that I follow. Question: Can anyone tell me how to change the connection mode for my SAS EG to Teradata database when using the process flow/query wizard options? If I cannot figure this out shortly, I will lose my connectivity as the dba has announced he will cut all ANSI connections! I appreciate any help you can provide. My SAS administrator here has no answers for me.

RPYee · ‎03-10-2022

I need to produce a Top N Report in SAS EG 8.3. I used to do it in SAS EG 7.1, but I cannot, for the life of me, figure out how to accomplish it in SAS EG 8.3. If someone could walk me through the steps, I'd be forever grateful 🙂 RPYee

RPYee · ‎10-13-2021

Finally figured these out on my own, but couldn't delete the post. To append in EG 8.3: In opened dataset, select "Tasks", then "Browse", then "Data", then "Append Table". Once this task has been used, it will now show under "Tasks>Recent Tasks" To view query code in EG 8.3: Run the query. When completed, double-click the query , then select "Code" from the menu just able the output.

RPYee · ‎10-13-2021

I've upgraded to EG 8.3 from 7.1 and now I can't figure out how to do the simplest of tasks. In 7.1 query results, there was a "Data" menu with the ability to select "Append". How do I find this in 8.3? Trying to append the output of two different queries. Also, how do I view the code without extracting it and having that showing in the process flow? Thanks, in advance, for your help! RPYee

RPYee · ‎10-08-2021

Have you had any luck solving this issue? I just upgraded from SAS EG 7 to 8. This is EXTREMELY frustrating! I have nothing to indicate that the program has finished running except that all the colors are gone from the icons. With sometimes 20+ processes inside one program, this is really a pain point. I want the final output to open up automatically after all of the program has run...

RPYee · ‎09-20-2021

I have two types of events (Event_A , Event_B) and their associated timestamps. There can be multiple timestamps for the same event. I want to check the event for each row and create a computed field related to the timestamp field. My "CASE" statement was originally: CASE WHEN event = EVENT_A THEN timestamp ELSE ' ' END This would give me an error that the second datatype doesn't match the first. So, I changed it to: CASE WHEN event = EVENT_A THEN timestamp END This works fine, but it puts a period when the test is false. Is there a way to just leave the result blank? I'll have two computed fields, EVENT_A_TMPSTP and EVENT_B_TMSTP. I'll then find the minimum of each occurrence and move forward with those results. I'm not sure how the period will play into this next step... Thanks for any help!! RPYee

RPYee · ‎01-03-2020

Learned how to run a program to accomplish what I wanted! data OUTPUT_NEW (drop=cage_reason_cd); set OUTPUT; by employee_nbr; length cage_reason_cd_new $200; retain cage_reason_cd_new; cage_reason_cd_new=ifc(first.employee_nbr,cage_reason_cd,catx(',',cage_reason_cd_new,cage_reason_cd)); if last.employee_nbr then output; run;

RPYee · ‎11-22-2019

I have a table with a one-to-many design. I'd like to convert it to a one-to-one table. See below: What I have CUSTOMER MODE COLOR 12345 CAR BLUE 12345 CAR RED 12345 CAR WHITE 98765 BIKE BLUE 98765 BIKE RED What I want CUSTOMER MODE COLOR 12345 CAR BLUE,RED,WHITE 98765 BIKE BLUE,RED Is there a way I can accomplish this in EG? Coding isn't my forte 😉 Thanks for any help you can provide! Rita Yee

RPYee · ‎09-10-2019

I have a series of dates for which I need to determine the day of week said date falls on, sum a value for each day of week (pivot), and sort totals from Monday thru Sunday. I have a calculated field (day_nbr) which uses "datepart" and is formatted as "Weekday1.". It automatically sets Sunday as a value of 1 when I need it to be 7. I tried a case statement testing "day_nbr", but it's not working. Any suggestions on how to make the day_nbr for Sunday be 7, then subtract one from all the others, for grouping purposes? Thanks in advance for any assistance! Rita Yee Project Engineer Global Trade Services FedEx Express

RPYee · ‎12-14-2018

I have two tables that have identical columns. One table is for the current month only (TBL_CURRENT) while the second table is the archive of all previous month data (TBL_STATIC). I have a very standard query that polls the current data and summarizes it. I want to copy the query and subsequent reports using the static table as the source. In other programs I've used, it's been easy to simply change the reference from one to the other. Is there a way to do this in SAS EG? Thanks for any help you can provide! Rita Yee Project Engineer FedEx Global Trade Services

RPYee · ‎06-29-2018

I've run into a few condescending derrieres here. 🙂

RPYee · ‎06-29-2018

This helped me with another issue... how to comment inside the code for my computed field. THANKS 😄

Online Status	Offline
Date Last Visited	‎02-22-2024 02:13 PM

Re: LIBNAME mode when using Process Flow

Re: LIBNAME mode when using Process Flow

Re: LIBNAME mode when using Process Flow

LIBNAME mode when using Process Flow

Top N report for SAS EG 8.3

Re: LOST!! EG 7.1 to 8.3 - Append and Code features

LOST!! EG 7.1 to 8.3 - Append and Code features

Re: Automatically open output when running query in project in SAS EG ...

How to insert a blank when needed in a date/time field

Re: Using Enterprise Guide, Combine Rows in results

Re: Extract Day of Week name from a Time Stamp field

Re: Extract Day of Week name from a Time Stamp field

Re: Sorting by Analysis Variable in Summary Table

Re: How do I turn off the automatic join of the tables?

Re: Prevent Auto-load of table in EG

Re: LOST!! EG 7.1 to 8.3 - Append and Code features

Re: Automatically open output when running query in project in SAS EG ...

Re: LIBNAME mode when using Process Flow

Re: LIBNAME mode when using Process Flow

Re: LIBNAME mode when using Process Flow

LIBNAME mode when using Process Flow

Top N report for SAS EG 8.3

Re: LOST!! EG 7.1 to 8.3 - Append and Code features

LOST!! EG 7.1 to 8.3 - Append and Code features

Re: Automatically open output when running query in project in SAS EG ...

How to insert a blank when needed in a date/time field

Re: Using Enterprise Guide, Combine Rows in results

Using Enterprise Guide, Combine Rows in results

Change Value of Weekday Number

Change Source Table for existing Process Flow

Re: Extract Day of Week name from a Time Stamp field

Re: Extract Day of Week name from a Time Stamp field