DATA Step, Macro, Functions and more

changing character to a number

Reply
Occasional Contributor GS2
Occasional Contributor
Posts: 16

changing character to a number

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

 

 

PROC Star
Posts: 1,288

Re: changing character to a number

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

Occasional Contributor GS2
Occasional Contributor
Posts: 16

Re: changing character to a number

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?

PROC Star
Posts: 1,288

Re: changing character to a 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

Super User
Posts: 9,883

Re: changing character to a number

[ Edited ]

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 82 views
  • 2 likes
  • 3 in conversation