Using SAS 9.4
How do I change an imported date that should be in date format to date format? SAS imported it as a character. Thanks
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
proc import
OUT=mylib.a
DATAFILE=
DBMS=xlsx REPLACE;
SHEET= 'sheet3';
GETNAMES=YES;
RUN;
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?
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.
Tom
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.