cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ElodieT
‎08-06-2021
  • 5 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Keep format of time

by Fluorite | Level 6 in SAS Programming
‎08-04-2021 09:48 PM
‎08-04-2021 09:48 PM
Hi,   Sorry for the late reply. It is the column that I would like to  convert from a datetime to a time. Could I put the name of the column like 'time't to have the whole change? Or is it only for a single value? I tried and it doesn't work for the column.   Regards, ... View more

Re: Keep format of time

by Fluorite | Level 6 in SAS Programming
‎07-30-2021 05:39 PM
‎07-30-2021 05:39 PM
Hi mKeintz,   It doesn't overwrite yet because these are my first tries before putting it into production... So if I understand correctly, I would have to change the format of this column manually each time once the excel file has been exported?   Regards, ... View more

Filling empty cell with others cells of the same column

by Fluorite | Level 6 in SAS Programming
‎07-30-2021 05:15 PM
‎07-30-2021 05:15 PM
Hello,   I would like to complete de empty cells of column Email with those already existing if they have the same name and stay in the same state. I tried with If then do to create another column and fill it out, but it doesn't work.    Please, is there a way to do it?     ... View more

Re: Keep format of time

by Fluorite | Level 6 in SAS Programming
‎07-30-2021 05:08 PM
‎07-30-2021 05:08 PM
Hi Ballardw,   Thank you for your quick response.   This is how I do export my data :   Proc export data = nametable                    outfile = "\\path to the folder\File name.xlsx"                    dbms=excels replace;                    port=9621;                    server='server';                    serveruser='user';                    serverpass='password'; ; run;   ... View more

Keep format of time

by Fluorite | Level 6 in SAS Programming
‎07-30-2021 04:13 PM
‎07-30-2021 04:13 PM
Hi,   In my code, I have extracted the time from a datetime by using TIMEPART Function and, I would like to export my table automatically to a folder. Knowing that I have defined this column as HHMM, the output data in SAS shows the time as 08:00 (which is what I want). However, the column in the Excel's export in the folder is written as 1900-01-01 08:00:00 Please, how could I do to keep the format of HHMM. in my export?   Thank you, ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-06-2021 06:43 PM
Group Hubs for ElodieT
View All
Likes given to
Quick links