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: 
unwanted_banana
‎07-06-2021
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to convert data formats?

by Calcite | Level 5 in SAS Programming
‎07-06-2021 05:39 PM
‎07-06-2021 05:39 PM
Ran the code and for some reason datepart returns a null value. ... View more

How to convert data formats?

by Calcite | Level 5 in SAS Programming
‎07-06-2021 05:20 PM
‎07-06-2021 05:20 PM
HAVE:  2017-04-20 00:00:00   WANT:  2017-04-20  AND 20/04/2017 (two separate formats for two different purposes) ... View more

Re: How do you add single quotes to a macro variable that's a date?

by Calcite | Level 5 in SAS Programming
‎07-06-2021 05:00 PM
‎07-06-2021 05:00 PM
It comes from a refined table (getdates) which only has one data value in its column (date1)   proc sql noprint; select date into :date1 from getdates; quit; ... View more

How do you add single quotes to a macro variable that's a date?

by Calcite | Level 5 in SAS Programming
‎07-06-2021 04:44 PM
‎07-06-2021 04:44 PM
HAVE: /* in yyyy-mm-dd format */ /* date1 is a macro variable within the program */   /* current value of date1 */ date1 = 2017-04-20   NEED:  date1 = '2017-04-20'   ATTEMPT: /* Tried to put double quotes around it then replace it with single quotes, but this didn't work. */ data _null_; set date1; date1= quote(date1); %put &date1 date1= %sysfunc (translate (&date1,%str(%"),%str(%'))); run;   Can someone tell me the place where I'm going wrong?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-06-2021 10:29 PM
Likes given to
View All
Quick links