Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson Global Actuarial & Analytics Recruitment
Download our Actuarial Salary Survey
now with state-by-state salary information!


Reply
 
Thread Tools Search this Thread Display Modes
  #51  
Old 01-15-2020, 11:56 AM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

Linked table manager - is there any way to make that window a little bigger so I don't have to scroll just to see the file names that my table is linked to? Maybe there's an ingenious solution out there.
Reply With Quote
  #52  
Old 01-15-2020, 03:40 PM
glassjaws's Avatar
glassjaws glassjaws is offline
Member
Non-Actuary
 
Join Date: Mar 2008
Location: 99 Franklin St.
Studying for C4
College: Chambana
Favorite beer: Whatever you buy me
Posts: 46,319
Default

Quote:
Originally Posted by 1695814 View Post
Linked table manager - is there any way to make that window a little bigger so I don't have to scroll just to see the file names that my table is linked to? Maybe there's an ingenious solution out there.
I can freely change the size of the window, maybe it's version-specific?
__________________
I am the background noise of life
Reply With Quote
  #53  
Old 01-15-2020, 04:07 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

Quote:
Originally Posted by glassjaws View Post
I can freely change the size of the window, maybe it's version-specific?
Interesting. I most definitely can not.
I'm using Microsoft Office Professional 2019.

I've attached a picture...just because I can.
Attached Images
 
Reply With Quote
  #54  
Old 01-16-2020, 01:30 PM
glassjaws's Avatar
glassjaws glassjaws is offline
Member
Non-Actuary
 
Join Date: Mar 2008
Location: 99 Franklin St.
Studying for C4
College: Chambana
Favorite beer: Whatever you buy me
Posts: 46,319
Default

I am on Office 365 ProPlus, Version 1905.

I have the dots on the bottom right to click and drag, or on any side like any other window.
Attached Images
 
__________________
I am the background noise of life
Reply With Quote
  #55  
Old 02-04-2020, 04:57 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

I have a few fields that are "Expression"s instead of...whatever...

Anyway, I know that to read it easier one should click the "Builder" button. However, in my haste, I oftentimes confuse it with the "Data Definition" button. Unfortunately, once I've entered that "view" I don't know how to get back to the "Design View". I'm more or less stuck there.
Reply With Quote
  #56  
Old 02-05-2020, 06:36 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

I'm trying to get data that's on one data set and not the other.

In SAS my code would look like this:
Code:
DATA JAN;
 INFILE JAN;
 INPUT POLICY $CHAR15.
 ;
RUN;

PROC SORT;
 BY POLICY;
RUN;

DATA FEB;
 INFILE FEB;
 INPUT POLICY $CHAR15.
 ;
RUN;

PROC SORT;
 BY POLICY;
RUN;

DATA MISSING;
 MERGE JAN(IN=A) FEB(IN=B)
  BY POLICY;
 IF A AND B THEN DELETE;
RUN;
 
PROC PRINT;
 TITLE 'POLICIES ON DEC AND NOT ON JAN AND POLICIES NOT ON DEC BUT ON JAN';
RUN;
I've tried some sort of OUTER JOIN in SQL but it says I have syntax errors or something like that. (I don't have my SQL code anymore because I got too angry & threw it against the wall and it shattered into a thousand pieces.)

Any ideas?
Reply With Quote
  #57  
Old 02-07-2020, 09:42 AM
glassy glassy is offline
Member
Non-Actuary
 
Join Date: May 2015
Posts: 5,682
Default

Not sure I completely follow, but

Code:
SELECT policy FROM JAN WHERE policy NOT IN (SELECT policy FROM FEB)
will give you the policies in the January table that aren't in February.
Then you can UNION ALL with the same query but switch JAN and FEB to get the policies not in January.
Reply With Quote
  #58  
Old 02-07-2020, 09:57 AM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for CSPA
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 68,546
Default

Looks like a job for a pass-through query:

WITH GetJanOnly (policy, inJan, inFeb) AS (

SELECT policy, 1, 0 FROM JAN

UNION ALL

SELECT policy, 0, 1 FROM FEB
)

SELECT policy FROM GetJanOnly
GROUP BY policy
HAVING ((sum(inJan) > 0) AND (sum(inFeb = 0))
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #59  
Old 02-20-2020, 02:56 PM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

That search bar on the lhs under "All Access Objects"...is there anyway to get to it using only the keyboard? ...or am I resigned to using the mouse?

edit: google says "alt+ctrl+f" but that didn't work for me.

Last edited by 1695814; 02-20-2020 at 03:12 PM..
Reply With Quote
  #60  
Old 03-18-2020, 10:40 AM
1695814's Avatar
1695814 1695814 is offline
Member
SOA AAA
 
Join Date: Aug 2002
Studying for nothing. I quit.
Favorite beer: Root
Posts: 39,345
Default

I have query that joins two tables, ReservesCurr & ReservesPrev, by Policy.
In each table is a field called "Reserve".

In my output, it is (automatically) labeling those "Reserve" & "Reserve1".

I'd rather have it be something more descriptive. Even ReservesCurr.Reserve & ReservesPrev.Reserve would be useful.

I don't know how to do that.
Reply With Quote
Reply

Tags
access

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 05:20 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.33113 seconds with 10 queries