About goms

goms · ‎06-30-2016

Thank u so much. its really helpful

goms · ‎06-30-2016

Hi, I want to look at the date value below Please let me know how to change the date format as it has char type source 19700101 01:00:00 Target 1970-01-01 01:00:00

goms · ‎06-28-2016

Hi , Thanks for your reply. While executing the below query it returns missing value (.) proc sql; select put(datepart(input(src_lastmodified,is8601dt.)),yymmdd10.) ||" " ||put(timepart(input(src_lastmodified,is8601dt.)),time9.1) as src_lastmodified from test.sample1; quit; Date format needs to changed from 20160531 00:04:37 to 2016-05-31 00:04:37

goms · ‎06-27-2016

Char type

goms · ‎06-27-2016

Hi, Below query gives an error Function DATEPART requires a numeric expression as argument 1. proc sql; create table sample as select identifier, serial, node, nodealias, manager, agent, alertgroup, alertkey, summary, location, class, poll, type, tally, severity, owneruid, ownergid, acknowledged, put (datepart(src_lastmodified),yymmdd10.)||" "||put(timepart(src_lastmodified),time9.1) as src_lastmodified from test.sample1; quit;

goms · ‎06-07-2016

Its a SAS dataset only

goms · ‎06-07-2016

Hi, Below is my output src_systime date_systime logtime 28APR2016:14:58:51.000000 28apr16 14:58:51 28APR2016:14:58:51.000000 28apr16 14:58:51 28APR2016:14:58:51.000000 28apr16 14:58:51 28APR2016:14:58:51.000000 28apr16 14:58:51 28APR2016:14:58:52.000000 28apr16 14:58:52 28APR2016:14:58:52.000000 28apr16 14:58:52 I want to convert the date format as below src_systime date_systime logtime 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:51 2016-04-28 14:58:52 2016-04-28 14:58:52 2016-04-28 14:58:52 2016-04-28 14:58:52

goms · ‎05-27-2016

Hi, Would like to see the value as NULL as the data come from source is empty string and loaded as NULL in HIve table when i establish a connection with hive and execute the query in SAS .it shows dot value End user wants to seet he result as an exact match with source

goms · ‎05-27-2016

I want to replace all the missing values (.) to NULL i tried the below one and also need to replace all the dot values in the particular field to be replaced as NULL Below query is not working .please let me know how to modify this data yourdata; set test.t_eticket(drop=subject); if ci_id =. then ci_id1="NULL" ; run ;

goms · ‎05-24-2016

Hi, I am new to SAS and I want to compare the below fields in the same table Please let me know how to compare the two different datatype ? Sr_date mentioned as varchar_type dt_date mentioned as date_type Example sr_date dt_date 10/05/2014 14:01:18 2014-10-05 Date values should be same in both fields .if anyting mismatched, query should pick the unmatched record Please let me know how to write a query for the above scenario?

Online Status	Offline
Date Last Visited	‎07-05-2016 10:18 AM

Re: Replace date value

Replace date value

Re: Function DATEPART requires a numeric expression as argument 1.

Re: Function DATEPART requires a numeric expression as argument 1.

Function DATEPART requires a numeric expression as argument 1.

Re: Convert Date Format

Convert Date Format

Re: Set all missing values to NULL

Set all missing values to NULL

Compare two columns in the same table

Re: Replace date value

Re: Function DATEPART requires a numeric expression as argument 1.

Re: Replace date value

Replace date value

Re: Function DATEPART requires a numeric expression as argument 1.

Re: Function DATEPART requires a numeric expression as argument 1.

Function DATEPART requires a numeric expression as argument 1.

Re: Convert Date Format

Convert Date Format

Re: Set all missing values to NULL

Set all missing values to NULL

Compare two columns in the same table