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: 
mahender1
‎03-25-2020
  • 7 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Data type conversion

by Fluorite | Level 6 in New SAS User
‎03-25-2020 08:21 AM
‎03-25-2020 08:21 AM
Dear All, How can i convert a string containing alphabets and date values and extract only date values from that. Please find the below example: The variable Details have the observations as below (dates not at particular position). I need to extract the date values only.   Details SAS_Anaytics_is_very_usefull_since_01Jan1960. By_20Aug1990_it_has_become_more_powerfull. Today_it_has_gained_huge_response_from_users_across_world_by_25Mar2020. ... View more

Re: Character functions

by Fluorite | Level 6 in SAS Programming
‎11-18-2019 08:27 AM
‎11-18-2019 08:27 AM
thank you 🙂 ... View more

Re: Character functions

by Fluorite | Level 6 in SAS Programming
‎11-18-2019 08:26 AM
‎11-18-2019 08:26 AM
Okay Thank you 🙂 ... View more

Character functions

by Fluorite | Level 6 in SAS Programming
‎11-18-2019 08:10 AM
‎11-18-2019 08:10 AM
Can anyone please explain the difference between the functions: find, index. findc, indexc. indexw.   data new; a="This is SAS Repractice"; b=find(a,'is'); ----- 3 c=index(a,'is'); ----- 3 d=findc(a,'is'); ----- 3 d=indexc(a,'is'); ----- 3 e=indexw(a,'SAS'); ----- 9 run; ... View more

date conversion

by Fluorite | Level 6 in New SAS User
‎04-09-2019 11:49 AM
‎04-09-2019 11:49 AM
Hello all, kindly help me in converting the date values to ISO8601 format. i have date values as : TRTSTDT and TRENDT are NUMERIC type as below:      TRSTDT            TRENDT 06DEC2007       20DEC2007 16JUN2009       30JUN2009   I want to convert them to CHARACTER variables as RFSTDTC and RFENDTC to ISO8601 format,     Kindly help me.         ... View more

PUT and INPUT

by Fluorite | Level 6 in SAS Programming
‎04-04-2019 01:18 PM
‎04-04-2019 01:18 PM
  In the code below everything is working fine.   DATA NEW; NUMDT=20081990; CHRDT=PUT(NUMDT,8.); SASDT=INPUT(CHRDT,DDMMYY8.); FORMAT SASDT DATE9.; RUN;   but in the below code:   DATA NEW; NUMDT=20081990; CHRDT=PUT(NUMDT,date7.); SASDT=INPUT(CHRDT,DDMMYY8.); FORMAT SASDT DATE9.; RUN;   it was not working fine.   can anyone please when exactly should i need to mention in put-format as date7.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-25-2020 11:42 AM
Likes given to
Quick links