03-13-2018 01:56 PM
Two options: change the code that imports the date value to use the appropriate informat, or keep importing it as character and use the INPUT function to convert it to a number. If you need more specific information, you'll need to post an example. Tom
03-13-2018 02:01 PM
This is my import statement.
the variable is second_tx_start_date, what would an input function look like to convert from character to number?
03-13-2018 02:25 PM
With some file formats, SAS writes the import code to the log, which you can copy and modify. But not with XLSX.
So your easiest option is to convert your variable in a subsequent data step, something like this:
data work.a_new; set work.a(rename=(second_tx_start_date = original_second_tx_start_date)); second_tx_start_date = input(original_second_tx_start_date, yymmdd10.); format second_tx_start_date date.; drop original_second_tx_start_date; run;
You'll need to find the specific informat to use for your date format, the SAS help is the easiest place to look.
03-13-2018 02:29 PM - edited 03-13-2018 02:30 PM
Problem #1: the Excel file format is not usable for a reliable data transfer. See the Gazillion of posts about it here.
Problem #2: proc import makes guesses, so variable types and other attributes change with the current contents of the infile
Save your data to a csv file, import that once with proc import, take the resulting data step from the log and adapt it as needed.
Take control of your process.