Hello, This is more of a general, rather than specific, question that I have run into. I am a fairly new user of SAS and was just wondering if there is a way to format data being read into SAS when using PROC IMPORT for an xlsx file? Does this require a separate DATA step? For example: if something is being read in as 02/14/2007 (numeric variable formatted automatically as MMDDYY10), is there a way to change this to be 14FEB2007 (formatted DATE9) in the PROC IMPORT step? Any feedback would be of help! Thanks in advance.
... View more