Hello,
The date column which is of the format “01JUN22” in the source table that is derived by a SAS code is appearing as " 22250" . How can make it appear correctly. Also I want to change the date to ddmmyyyy format. Can you please help me on this.
The Dataset that is imported into power BI is derived by running a SAS proc SQl . the date appears as “01jun22” in the table but on loading into power BI its appearing as “22250”
Hi @edna, while waiting for other members to jump in, I suggest checking this lecture from Sam McKay on changing date formats. The scenario was different but you might be able to use the same technique. Please see the video below:
Changing Date Formats w/Power Query Editor - Simple Technique For (enterprisedna.co)
Hope it helps. Thanks
It seems that the date on SAS seems to start from 1-Jul-1961. Create a custom column and add 22463 to the SAS Code Date column and then change the datatype of the new column into Date Datatype Format.
#"Added Custom" = Table.AddColumn(#"Changed Type", "SAS Converted Date", each [SAS Code] + 22463),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"SAS Converted Date", type date}})
Hi @edna, did the response provided by @pranamg help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
Hi @edna, we’ve noticed that no response has been received from you since a few days ago.
We just want to check if you still need further help with this post?
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @edna, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.