About Bellefeuille

Bellefeuille · ‎11-17-2017

its date i guess what im trying to do is export it so i can use it in sql Table - ACCT DATE Again when i export the content, the date is exported as DDMMMYYYY and if i load the data in sql afterwards, it will concider it txt because of the MMM

Bellefeuille · ‎11-17-2017

I tried creating a new dataset with the table, this seemd to create an empty column. Data one.want; set one.Cust_To_Acct_To_Trans3; OpenDate = input(open_dt, date9.); format OpenDate date9. ; /* or any of the other date formats humans like*/ run; endRsubmit;

Bellefeuille · ‎11-17-2017

sas log shows ERROR: CLI describe error: [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token ")" was found following "ut(ac.open_dt,date9.". Expected tokens may include: "<identifier>". SQLSTATE=42601 the datalooks like 02OCT2017

Bellefeuille · ‎11-17-2017

i have code that the output is not cooperating with my sql programs. I use sas to extract form a grid, so downloading the table at once is not idea. my code looks like this the open_dt has an output of DDMMMYYYY and i have to do tons of converting which i would perfer do solve while doing the extract. is this possible to add to the select satement? %sastable(one.Cust_To_Acct_To_Trans3, select DISTINCT cu.cust_no ,ac.acct_no ,open_dt *------ Below arent working...................... ,input(ac.open_dt,date9.) as opendate format=date9. ,input(ac.open_dt, yymmn6.) as date_c format=yymmdd6.

Bellefeuille · ‎11-17-2017

Good Afternoon Im wondering if there is any way to convert a Text date that looks like 02JAN2017 Since im simply reading a dataset that has the date stored in this manor, im extracting it using a select statement, if at possible to convert or substring it from there and convert it, would be Best for me newbie self 🙂 any help is greatly appreciated happy friday!

Bellefeuille · ‎10-26-2017

I have a date, that is in text that looks like this 20170706 What i need to do is, convert it to a readable date and have it include in my where clause for filtering. Similar to where create_dt >= date('2017-09-01') Any help is appreciated.

Bellefeuille · ‎08-18-2017

when i try this, i get the following ERROR: CLI describe error: [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "missing" was found following "E CU.DEATH_DT is not". Expected tokens may include: "<search_condition>". SQLSTATE=42601

Bellefeuille · ‎08-17-2017

the joins work, and if i search for a specific CUSt_ID, i get obs, but i only want obs if death_DT is empty, and it seems that null values in the date field are represented as a period.?

Bellefeuille · ‎08-17-2017

Good Evenening, Appreciate all the help in learning 🙂 Love sas! Im trying to create a mail list, and in order for myself to do this, i need search for NOT null values in the death_Dt field, I tried NE. and <>"." but its not working %SASTABLE(ONE.CUST, SELECT CU.CUST_ID ,CU.death_dt , MAFOCU.FIRST_NA , MAFOCU.LAST_NA , MAFOCU.CUST_TYPE_MN , MAFOCU.FULL_BUSNES_NA1 , MAFOCU.CONTRY_MN , MAFOCU.MAIL_ROUTE_CD , MAFOCU.FORMAT_ATTN_LINE_TX , MAFOCU.FORMAT_SPECL_ADDR_TX , MAFOCU.FORMAT_STREET_ADDR_TX , MAFOCU.FORMAT_MNCPTY_ADDR_TX FROM EDW.CUST CU JOIN EDW.MAIL_FORMAT_CURRNT MAFOCU ON MAFOCU.CUST_ID = CU.CUST_ID WHERE (CU.DEATH_DT <>.)); endrsubmit;

Bellefeuille · ‎08-17-2017

Good Afternoon Guys, Looking for some syntax help if you can 🙂 I need to create an effective date which is always to be Dec 31st of the following year Example If my Creation Date is 8/18/2017 my effective date would be DEC 31 2018 If my Creation Date is 12/31/2017 my effective date woul dbe DEC 31 2018 Ect. Appreciate any assistance

Bellefeuille · ‎07-11-2017

Good moring, wondering if this great comunity can help m eiwth the following issue im having. I have a script that creates an xls file from various datasets, after creating the xls fle, i want to append a new worksheet(tab) I cant seem to wrap my head around how i would do this. the one i create using the script is dynamic in name daily&yymm..xlsx"" "; so it will add the current date to the file, and the workbook that contans the new tab is called Dashboard.xls (Tab name,DASH)

Bellefeuille · ‎06-29-2017

Thanks art. I already have a program that creates thr workbook and all its tabs. However i have been asked to add a new tab. Ehich reada from other tabs. Since its already created. Im wondering if i can impoer the tab at the end or the creation job.

Bellefeuille · ‎06-29-2017

good Afternoon Im wondering how i can go about importing a tab from a template in a sas program that creats a report on the fly.

Bellefeuille · ‎06-15-2017

Good morning, Im looking to see if sas can accomodate something similar to ISdate() function similar to sql, i tried it in sas but its returning the function is not available. my goal is to filter through 6million records to count any instance of non date and time in a field.

Bellefeuille · ‎05-31-2017

Good Evening, im reading in an input file that has dates in text format. IDAT $ EDAT $ TRDAT $ Idat and TRDat Both look similar to Idate trdate 20170426 20170426 my goal is to compare if the date are identical or not.(1 or 0)

Online Status	Offline
Date Last Visited	‎01-13-2020 11:42 AM

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

convert text date to DD/MM/YYYY from DDMMMYYYY

DDMMMMYYYY

Convert String to date and filter

Re: Where clause with missing dates

Re: Where clause with missing dates

Where clause with missing dates

DATE Calculation

Isdate

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

convert text date to DD/MM/YYYY from DDMMMYYYY

DDMMMMYYYY

Convert String to date and filter

Re: Where clause with missing dates

Re: Where clause with missing dates

Where clause with missing dates

DATE Calculation

Adding a tab / sheet to an existing workbook / .xlsx file

Re: Import tab from one excel

Import tab from one excel

Isdate

Convert text dates and see if two dates are the same