CesarOmarHR Tracker

Re: What are the database formats for SAS access to OBDC?

CesarOmarHR — Mon, 06 Oct 2014 17:20:49 GMT

Do you know the data types that are supported?

i'm thinking MySql, Sql, .dat are there any others?

What are the database formats for SAS access to OBDC?

CesarOmarHR — Mon, 06 Oct 2014 15:55:11 GMT

Hi there

I know it's a pretty simple question, but what are the databases capable for import with SAS ACCESS TO OBDC?

I appreciate the help.

César

Re: Obtaining logit equation for implementing purposes

CesarOmarHR — Tue, 17 Dec 2013 16:42:21 GMT

Thanks a lot, it worked! This was holding us back.

Cesar

Obtaining logit equation for implementing purposes

CesarOmarHR — Tue, 17 Dec 2013 15:36:10 GMT

I was wondering if you could help me to obtain the ecuation from a logit regression model, to obtain the individual estimates by hand, since i already have them on a SAS table. The purpose of it, is to give the equation to TI.

My ecuation has, continuous, and categorical variables (Trouble is in the last one)
Dependent variable is y=1 or y=0
example: y = b0 + (b1Married + b2Divorced) + (b3HighSchool + b4College)

Single as "Base" No Studies as "Base"

For individuals with "Nonbase" characteristics such as Married, Divorced, High School or College, the procedure by hand gives me the estimated "y".

When implementing to production, i find trouble when i have individuals with caracteristics taken as "Base", since the intercept enbody the whole "Base" caracteristics, can´t isolate them and therefore, obtain a different estimated "y".

Could anyone please tell me what to do when having an individual with one or two base caracteristics? How can i get the adjusted "y" i get automatically from enterprise Guide?

Thanks in advanced.

Cesar

Re: Date differences within a column

CesarOmarHR — Thu, 05 Sep 2013 21:17:43 GMT

Thank you all, i really appreciate it and agree with you , there are plenty of options to choose from.

i'm just working on replacing the 10 record data with my sas database.

Thanks a lot

Cesar

Re: Date differences within a column

CesarOmarHR — Wed, 04 Sep 2013 22:40:41 GMT

Alright i'll try to fix it into the advanced querying section within the Enterprise Guide options.

Re: Date differences within a column

CesarOmarHR — Wed, 04 Sep 2013 22:38:54 GMT

I would like it to look like the "DaysDifference" column

Thanks

Date differences within a column

CesarOmarHR — Wed, 04 Sep 2013 22:28:06 GMT

Hi there, i'm trying to find, within the frame of the advanced expression of the "New Column" section, a way to generate a column that shows the intervals of lack of usage per client. How could i do it?

I appreciate the help.

Client PurchaseDate DaysDifference

1 01jan2013 .

1 05jan2013 4

1 10jan2013 5

1 12jan2013 2

2 01jan2013 .

2 31jan2013 30

2 05feb2013 5

2 15feb2013 10

César

Re: Creating by-weekly expenses in EG

CesarOmarHR — Thu, 11 Apr 2013 18:21:29 GMT

Thanks i'll give it a try and let you know.

I appreciate the help

Re: Creating by-weekly expenses in EG

CesarOmarHR — Thu, 11 Apr 2013 17:35:24 GMT

Since i'm not that skillful yet with some unknown functions, i was given this (example) to arrange dates in a different bi-weekly format:

ifn(day(t1.purchase_date)<=15, intnx('month',t1.purchase_date,0,'e'), intnx('month',t1.purchase_date,1,'m'))

I'm trying to understand the conditions from this formula to fit my neccesities in a customized format.

Re: Creating by-weekly expenses in EG

CesarOmarHR — Thu, 11 Apr 2013 17:21:42 GMT

I basically want to fit a historical range of purchases dates into a by-weekly format. For every purchase between 01AUG2012 and 15AUG2012, label them as 15AUG2012 and the same for some other purchase between 16AUG2012 and 31AUG2012 with the label 31AUG2012.

Since i have too much data, i cannot keep creating a format within the recoded function.

Creating by-weekly expenses in EG

CesarOmarHR — Thu, 11 Apr 2013 15:41:23 GMT

Hi there

I would like to know how to group daily expenses into a by-weekly format. Since i've worked with a small database i've used the recoded function and applied ranges.

Date of Charge	By-Weekly Expenses
16FEB2012	29FEB2012
01MAR2012	15MAR2012
19FEB2013	28FEB2012
04APR2013	15APR2013

i'll appreciate the help to construct a condition to apply in the Advanced Expression option

Thanks

César

How to summarize a column with an unique value?

CesarOmarHR — Thu, 28 Feb 2013 22:18:48 GMT

Hi there

I want to generate a summarized column with the total value of the elements in the column repeating each time.

Number of cars Total Number of cars

1 5

. .

1 5

I'm using SAS EG, but can't find the correct option among the sum, count, N, sum distinct, count distinc commands.

Thanks

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Thu, 28 Feb 2013 19:57:42 GMT

Thanks Chris@SAS it all worked correctly.

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Fri, 15 Feb 2013 17:55:26 GMT

I don't know what is it that i'm doing wrong

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Fri, 15 Feb 2013 17:51:18 GMT

I also did the double quotation marks, still.. no approval of my format.

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Fri, 15 Feb 2013 17:34:36 GMT

Hi Chris@SAS I'm creating the format to apply the zodiac signs but i'm having trouble getting SAS EG to approve it.

Here i show the specifications i'm using, i though i was writing the dates correctly. I've tried two ways: 01Jan2000'd - 20Jan2000'd and '01Jan2000'd - '20Jan2000'd, but SAS EG is no approving neither of them.

César

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Thu, 14 Feb 2013 22:37:37 GMT

Thanks Chris@SAS, i'll create the format as you suggest.

Re: how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Thu, 14 Feb 2013 19:55:52 GMT

Thanks! I'm starting to understand how to generate the dates, however, i deal with an infinite amount of birthdate years, which should be taken into account in the formula and don't have knowledge of.

how to generate zodiac sign based on dd-mm-yyyy birthdates

CesarOmarHR — Thu, 14 Feb 2013 19:21:52 GMT

Hi there

I was hoping anyone could help me to generate within the Enterprise Guide recoded column function, the zodiac sign base on dd-mm-yyyy birthdates.

Should i breakdown the dates in Month(x), Day(x)? How can generate a code within the generate new column options?

Aries March 21 - April 19

Taurus April 20 - May 20

Gemini May 21 - June 20

Cancer June 21 - July 22

Leo July 23 - August 22

Virgo August 23 - September 22

Libra September 23 - October 22

Scorpio October 23 - November 21

Sagittarius November 22 - December 21

Capricorn December 22 - January 19

Aquarius January 20 - February 18

Pisces February 19 - March 20

Thanks in advanced