I am attempting to output an excel (xlsx) file using ods excel from a proc output. My variables are in date9. format in the SAS data set, but when they output to excel they are in a text format.&n...
Hello,
I have a database in Excel with a date variable of modalities 01/21/2022, 03/02/2019, 06/01/2010, etc. When I import it into SAS, the date variable contains the modalities 44949. I...
Hello, I know there are a lot of posts about formatting dates, but I have not been able to find one that works for my problem. I am trying to import data where the dates are f...
...ut it generated many uninterpretable data. Please see the second screenshot. How can I read this column in to capture all the values as dates. Thanks again
datestudy=input(date...
Good morning my friends:
I have studied lots of tutorials talking about how to import correctly EXCEL files into SAS UNIERSITY EDITION, unfortunely all the trials were unsuccesfull, here i...
Hi! When I import this excel file, the dates come in as a random set of numbers that aren't in date format or correct. Below is the import code I'm using. Can someone please correct me to get them t...
Hello,
I'm have a problem with no highlighting in my results. I get results as expected (and yes, there is a 31Aug2022 in my dates) but nothing highlights. My code is as follows:
%let a...
...and will require importing. One of my columns in Excel is a "date" column, written as YYYYMM (so, October 2015 would be 201510). This is stored in Excel under General format and not as a...
Hi, I originally received 2 Excel sheets to merge together for this project. After I merged them, I successfully corrected the dates using this code: DATA SubQ.dataclean1; S...
...1JUN2022; %let ToDate=31JUL2022; I reference it all throughout the program with no issues. When it comes time to produce the excel output though it only comes out in sas date format, I need it in m...
