Hi All, I hope everyone is doing good. I need a datetime value for the 1st day of a year, which should look like this. 2022-01-01T00:00:00.000Z By considering the above datetime only the year needs to be changed whenever the new year comes. The date and month should remain same i.e 01-01. Example: 2023-01-01T00:00:00.000Z The datetime value must be in a macro variable. Any help would be greatly appreciated. Thanks. ... View more

Hi all, I've a datetime value which is Date = %sysfunc(datetime(), e8601dt24.3); output : 2022-01-07T10:38:49.095 I would like to subtract 365 days from Date Variable i.e a year. The wanted Date Variable should look like this 2021-01-07T10.38.49.095 Can anyone please help me on achieving this. Thanks in advance. ... View more

Hi All, I wish you a happy new year to everyone. I have a temporary dataset which has columns like this. OrderID ProductID Here for a particular OrderID it may have multiple ProductID's corresponding to OrderID. But my data is like Example: For a OrderID : 12345 it has two ProductID's : abc789, der098I. I would like to have a final dataset should be like OrderID ProductID 123451 abc789 123451 der098I ... View more

Hi all, I've a character value which is like "2012-07-07T20:44:30.293Z". I would like to change this format to datetime Required : 2012-07-07T20:44:30.293Z Thanks. ... View more

Hi all, Does anyone let me know how to transpose a column values which has duplicates. Previously I used a table which is like below, Val1 Val2 Abc 123 Def 567 Abc 908 Ghf 543 I would like to transpose Val1 values as variables for that I wrote a code which gave me an error like. Proc transpose data=have out=want ; Id Val1; var Val2; Run; Error: The ID value " Abc" occurs twice in input data set. Later on, I used LET keyword in proc transpose but has given me only the last occurrence as you can see my data though Val1 has duplicates their corresponding values Val2 has unique values. Please help me. Thankyou. ... View more