cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
brulard
‎03-01-2021
  • 145 Posts
  • 78 Likes Given
  • 2 Solutions
  • 5 Likes Received

Re: If duplicate, add flag

by Pyrite | Level 9 in SAS Programming
‎03-02-2017 03:34 PM
‎03-02-2017 03:34 PM
hi nehalsanghvi ,   thanks for tip... I should have mentioned, my data can have more than 1 duplicate   Example output: IDs                  Dummy_Var a010                     1 a010                     1 a010                     1 a010                     1 a011                     0 a012                     1 a012                     1 ... View more

If duplicate, add flag

by Pyrite | Level 9 in SAS Programming
‎03-02-2017 03:24 PM
‎03-02-2017 03:24 PM
hi,   does anyone know how i can flag for duplicate value? I'd like to create a dummy variable where if variable is a duplicate, dummy_var=1, else 0...   the variable contains char value.   Example output: IDs                  Dummy_Var a010                     1 a010                     1 a011                     0 a012                     1 a012                     1   Thank you ... View more

Re: Hadoop connectivity issue

by Pyrite | Level 9 in SAS Data Management
‎01-18-2017 06:43 AM
‎01-18-2017 06:43 AM
hi Jeff,   Thanks for responding. How do I "open a track"? Is it through SAS website, or via my organization?     ... View more

Hadoop connectivity issue

by Pyrite | Level 9 in SAS Data Management
‎01-16-2017 09:31 AM
‎01-16-2017 09:31 AM
hello,   I am trying to connect to a database we internally refer to as EDL,  but am getting error message.   Here is my code: proc sql; connect to hadoop (user=''myname' pwd=’xxxxxx’ server='sdpsvrwm0121.scglobal.ad.source.com' schema=edice uri='jdbc:hive2://sdpsvrwm0121.scglobal.ad.source.com:8443/cmstr;ssl=true;sslTrustStore=/sashome/hadoop/gateway.jks;trustStorePassword=xxxx?hive.server2.transport.mode=http;hive.server2.thrift.http.path=gateway/default/hive'); create table table_Pull as select * from connection to hadoop (select * from MSTR_TABLE where ID='0000000001'); quit; Error messages in blue:     14 ! hive.server2.thrift.http.path=gateway/default/hive'); ERROR: The Hive Kerberos principal string is present in the hive-site.xml file in the        SAS_HADOOP_JAR_PATH. The USER= and PASSWORD= options cannot not be specified when the Hive        Kerberos principal string is present. 15   create table table_Pull as 16                                 select * from connection to  hadoop 17                  (select * from MSTR_TABLE 18                                where ID='0000000001'); 18 !                                                                    quit; ERROR: Connection is missing required option SERVER. NOTE: The SAS System stopped processing this step because of errors.     My Unix SAS version :For Base SAS Software ... Custom version information: 9.4_M3 Image version information: 9.04.01M3P060315 For SAS/STAT ... Custom version information: 14.1 For SAS/GRAPH ... Custom version information: 9.4_M3 For SAS/ETS ... Custom version information: 14.1 For SAS/OR ... Custom version information: 14.1 For SAS/IML ... Custom version information: 14.1 For SAS/QC ... Custom version information: 14.1 For SAS/CONNECT ... Custom version information: 9.4_M3 For SAS Integration Technologies ... Custom version information: 9.4_M3 For SAS/Secure 168-bit ... Custom version information: 9.4_M2 For SAS/ACCESS Interface to DB2 ... Custom version information: 9.4_M2 For SAS/ACCESS Interface to PC Files ... Custom version information: 9.4_M3 For SAS/ACCESS Interface to ODBC ... Custom version information: 9.4_M3 For SAS/ACCESS Interface to Microsoft SQL Server ... Custom version information: 9.41 For SAS Model Manager ... Custom version information: 13.1 Image version information: 9.04.01M0P061715 For SAS/ACCESS Interface to Netezza ... Custom version information: 9.4_M3 For SAS/ACCESS to Hadoop ... Custom version information: 9.43 For High Performance Suite ... Custom version information: 2.2_M4 For Model Mgmt Shared Macros ... Custom version information: 14.1 Image version information: 9.04.01M0P061715 For Decision Manager Server ... Custom version information: 3.1 Image version information: 9.04.01M0P061715 Also, when I try connect  to database with Libname from Autoexec, I receive error:   “ERROR: java.sql.SQLException: Could not open client transport with JDBC Uri:”   Any tips toward resolving this is greatly appreciated. Thanks, Dave ... View more

Re: Flagging low risk, date of birth changes

by Pyrite | Level 9 in SAS Programming
‎08-19-2016 04:46 PM
‎08-19-2016 04:46 PM
Thanks for your help and for this tip ... I will research the complev function ... View more

Re: Flagging low risk, date of birth changes

by Pyrite | Level 9 in SAS Programming
‎08-19-2016 04:20 PM
‎08-19-2016 04:20 PM
thanks Avery, your solution works as well ... appreciate the explanations offered. ... View more

Re: Flagging low risk, date of birth changes

by Pyrite | Level 9 in SAS Programming
‎08-19-2016 03:54 PM
‎08-19-2016 03:54 PM
correct, it will be included... ... View more

Re: Flagging low risk, date of birth changes

by Pyrite | Level 9 in SAS Programming
‎08-19-2016 03:41 PM
‎08-19-2016 03:41 PM
very interesting! Could you help me add 3 more flags to your code?    -if difference in old date and new date, is either -1, or 1 in either day month or year. Here's the code I had created:   dd=day(new_birthday)-day(old_birthday); mm=month(new_birthday)-month(old_birthday); yy=year(new_birthday)-year(old_birthday); if dd in (-1,1) then do; FLAG_D=1;END; IF MM in (-1,1) then do; FLAG_M=1;END; IF YY in (-1,1) then do; FLAG_Y=1;END; i'm fairly new to sas.. thank you ... View more

Flagging low risk, date of birth changes

by Pyrite | Level 9 in SAS Programming
‎08-19-2016 02:20 PM
‎08-19-2016 02:20 PM
hello,   I'm seeking guidance toward building  code that can modify aspects of a date, specifically the customer's date of birth (dob).The purpose  is to pinpoint potential fraud (as a dob typically never changes, unless due to data entry error, or fraud).   Example variables:   old_birthday: 01jan1980   | new_birthday: 03mar1982.     Format of birthday is date9., using SAS 9.4. I need to flag those where the change in the dob is low risk, such as those meeting the two below conditions:    From first variable (old_birthday):  A-Reverse last two digit of year. Example: have 05jan1967 want 05jan1976  B-Swap day with month. Example: have 05jan1980 want 01may1980    If want=new_birthday then do;High_Risk=’N’;end;   Any suggestions are highly appreciated, thanks in advance, ... View more

Re: Concatenating Date and Time

by Pyrite | Level 9 in SAS Programming
‎08-18-2016 12:44 PM
‎08-18-2016 12:44 PM
hey Ballardw... thanks for this suggestion... very simple and works great! ... View more

Re: Concatenating Date and Time

by Pyrite | Level 9 in SAS Programming
‎08-16-2016 01:13 PM
‎08-16-2016 01:13 PM
thanks for the quick help RW9 ... View more

Concatenating Date and Time

by Pyrite | Level 9 in SAS Programming
‎08-16-2016 12:08 PM
‎08-16-2016 12:08 PM
Hello,   I want to create a new value datetime derived from existing values. Existing values are formatted as follows: Date, date9. (24MAY2016) and Time, time8. (9:10:07)   Result I am looking get may be as follows: 24MAY2016:09:10:07. What is important is that I am able to compare this column datetime against itself, using < > functions.   I found the following code online, but it is giving me errors: Data want; attrib newdate format=datetime25.; set have ; newdate=input(put(date,date9.)||put(time,time8.),datetime.);run;   Here is the sas error message I receive: “Invalid argument to function INPUT at line 190 column 9.   Any help would be appreciated, thanks ... View more

Re: Searching for in between dates -comparing two methods

by Pyrite | Level 9 in SAS Programming
‎08-03-2016 10:29 AM
‎08-03-2016 10:29 AM
thanks Ballardw for showing this helpful tip: If year(ts_acn_opn_dt)=2010 then ... View more

Re: Searching for in between dates -comparing two methods

by Pyrite | Level 9 in SAS Programming
‎08-03-2016 10:28 AM
‎08-03-2016 10:28 AM
thanks Reeza! ... View more

Searching for in between dates -comparing two methods

by Pyrite | Level 9 in SAS Programming
‎08-03-2016 10:14 AM
‎08-03-2016 10:14 AM
hello,   If searching for a date in between two dates, could someone offer a helpful tip (with explanation)?   In example A, the following query worked and does yield desired results:   data mc_1 mc_2 mc_3 mc_4 mc_5 mc_6 mc_7 mc_8 ; set Have ; if ts_acn_opn_dt<’01jan2010’d then output mc_1; else if ts_acn_opn_dt>=‘01jan2010’d and ts_acn_opn_dt<’31dec2010’d then output mc_2; else if ts_acn_opn_dt>=‘01jan2011’d and ts_acn_opn_dt<’31dec2011’d then output mc_3; else if ts_acn_opn_dt>=‘01jan2012’d and ts_acn_opn_dt<’31dec2012’d then output mc_4; else if ts_acn_opn_dt>=‘01jan2013’d and ts_acn_opn_dt<’31dec2013’d then output mc_5; else if ts_acn_opn_dt>=‘01jan2014’d and ts_acn_opn_dt<’31dec2014’d then output mc_6; else if ts_acn_opn_dt>=‘01jan2015’d and ts_acn_opn_dt<’31dec2015’d then output mc_7; else output mc_8; run; However, in example B, it does NOT yield desired result:   data mc_1 mc_2 mc_3 mc_4 mc_5 mc_6 mc_7 mc_8; set have ; if ts_acn_opn_dt<’01jan2010’d then output mc_1; else if ’01jan2010’d>=ts_acn_opn_dt<’01jan2011’d then output mc_2; else if ‘01jan2011’d>=ts_acn_opn_dt<’01jan2012’d then output mc_3; else if ‘01jan2012’d>=ts_acn_opn_dt<’01jan2013’d then output mc_4; else if ‘01jan2013’d>=ts_acn_opn_dt<’01jan2014’d then output mc_5; else if ‘01jan2014’d>=ts_acn_opn_dt<’01jan2015’d then output mc_6; else if ‘01jan2015’d>=ts_acn_opn_dt<’01jan2016’d then output mc_7; else output mc_8;run; I'm trying to understand reason for example B not yielding the results I want (Output mc_3 contains observations dated 02jan2010).   Thanks in advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-01-2021 10:19 PM
Likes given to
Likes from
Quick links