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: 
ranjita
‎09-01-2015
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Converting text to date format

by Calcite | Level 5 in SAS Procedures
‎05-17-2014 02:39 PM
‎05-17-2014 02:39 PM
I have a text variable called transaction date  which has values like 01-APR-14. I want to convert this variable to a date variable in the format ddmmyy. I have used the code date=input(substr(strip(transaction_date),1,9),MMDDYY10.) This doesn't seem to work. Can anyone suggest how to do this. ... View more

Specifying a range of values for a character variable

by Calcite | Level 5 in SAS Procedures
‎04-26-2014 08:30 AM
‎04-26-2014 08:30 AM
I have a variable called "X", it has alphabets, numbers, special characters etc. I need to search for Upper and Lower Case alphabets from a to z and create a flag based on that. Whenever X has a character in it, a variable called flag should have value 1. Writing a if then statement is not an option cause its very long. I need to specify a variable with range of character values from A to Z and the variable flag should be based on that. Please help. Need a solution urgently. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links