About jenrscott827

jenrscott827 · ‎03-05-2015

No... I am just on the single view. It is kind of difficult to explain - the screen re-positions itself when I either delete a query and the output of that query or when I submit a query. Under my options settings, It does not matter if I have checked the box for 'Automatically open data or results when generated'. The screen still moves.... 😞

jenrscott827 · ‎03-04-2015

Hi - I am using SAS EG 6.1 GUI version. Every time I submit a query or delete a query the view on the scroll bars change. It will either either go back to the beginning of the or move to some strange place in the process flow. Is there a way to not to this or lock the view so it stays on the last query builder that I edited? It gets very annoying to try to position my screen back to the original place I was working in if my process flow is huge! anything will help.... Please let me know if this does not make sense.

jenrscott827 · ‎05-08-2014

input(put(Date,6.),4.) This is what I do.

jenrscott827 · ‎12-19-2013

It worked. I unchecked 'Automatically select groups' and it worked. Thank you.

jenrscott827 · ‎12-19-2013

PROC SQL; CREATE TABLE WORK."Details" AS SELECT t1.'Facility Name'n, t2.LOS, t2.Admits, /* Avg LOS */ (t2.LOS/t2.Admits) LABEL="Avg LOS" AS 'Avg LOS'n, t1.Charged, t1.Allowed, /* % of Discount */ ((t1.Charged-t1.Allowed)/t1.Charged) LABEL="% of Discount" AS '% of Discount'n, t1.Paid, /* % of Total Inpt */ (t1.Paid/SUM(t1.Paid)) LABEL="% of Total Inpt" AS '% of Total Inpt'n, /* Allowed/Day */ (t1.Allowed/t2.LOS) LABEL="Allowed/Day" AS 'Allowed/Day'n GROUP BY t1.'Facility Name'n, t2.LOS, t2.Admits, (CALCULATED 'Avg LOS'n), t1.Charged, t1.Allowed, (CALCULATED '% of Discount'n), t1.Paid, (CALCULATED 'Allowed/Day'n); QUIT;

jenrscott827 · ‎12-19-2013

PROC SQL; CREATE TABLE WORK."Details" AS SELECT t1.'Facility Name'n, t2.LOS, t2.Admits, /* Avg LOS */ (t2.LOS/t2.Admits) LABEL="Avg LOS" AS 'Avg LOS'n, t1.Charged, t1.Allowed, /* % of Discount */ ((t1.Charged-t1.Allowed)/t1.Charged) LABEL="% of Discount" AS '% of Discount'n, t1.Paid, /* % of Total Inpt */ (t1.Paid/SUM(t1.Paid)) LABEL="% of Total Inpt" AS '% of Total Inpt'n, /* Allowed/Day */ (t1.Allowed/t2.LOS) LABEL="Allowed/Day" AS 'Allowed/Day'n I set the formula to bold that is not working.

jenrscott827 · ‎12-19-2013

Hello - I am using enterprise guide 6.1. And what I am looking to do is sum a column and divide the total by one of the values that I added to get the percent of the total. We just recently upgraded our SAS from 4.3 to 6.1 and this same program in 4.3 had this as the computed column: Paid/Sum(paid) - Which would give me the percent of the paid amount for the facility to the total paid amount. when I do that same formula in SAS enterprise guide 6.1 it only gives me a value of 1 because it is simply dividing the value with itself. Is there a formula or function that I could use to help me get a percent for the paid amount in SAS 6.1? I am using the computed columns - Advanced expression editor. Please help! Thank you.

Online Status	Offline
Date Last Visited	‎09-15-2015 05:24 PM

Re: Screen Moving

Screen Moving

Re: Help with date

Re: Totaling a column and dividing it by the original value

Re: Totaling a column and dividing it by the original value

Re: Totaling a column and dividing it by the original value

Totaling a column and dividing it by the original value

Re: sums and counts by group

Re: Screen Moving

Screen Moving

Re: Help with date

Re: Totaling a column and dividing it by the original value

Re: Totaling a column and dividing it by the original value

Re: Totaling a column and dividing it by the original value

Totaling a column and dividing it by the original value