tag:blogger.com,1999:blog-7958828565254404797.post2202774406044017193..comments2024-03-27T11:03:10.938-07:00Comments on ListenData: SAS Date Formats and InformatsDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-7958828565254404797.post-62144120836709194782024-03-21T07:44:34.887-07:002024-03-21T07:44:34.887-07:00Check out this link - https://www.listendata.com/2...Check out this link - https://www.listendata.com/2024/03/how-to-extract-date-from-datetime-in-sas.htmlDeepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-85462797994508214182024-03-21T03:55:02.888-07:002024-03-21T03:55:02.888-07:00i have a sas dataset with character column as 202...i have a sas dataset with character column as 2024-01-29 05:04:43. how to convert into date, if anyone knows pls let me know.I just need date only<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-28298735442768810862022-04-14T11:34:07.250-07:002022-04-14T11:34:07.250-07:00unable to understand @6 and @15 so plz make a note...unable to understand @6 and @15 so plz make a note on that particular topic...By the way Listen-data is awesome.Anonymoushttps://www.blogger.com/profile/17829446566172117852noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63214656407768226272022-03-14T15:58:47.081-07:002022-03-14T15:58:47.081-07:00Date9.Date9.Karthikahttps://www.blogger.com/profile/05217510581182888295noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-71912748723177122712022-01-23T21:37:43.591-08:002022-01-23T21:37:43.591-08:00Hi,
we can read dates in different formats but w...Hi, <br /><br />we can read dates in different formats but while reading the data from external files the informat should match with data. If you are writing data in data step then you can mention the different formats as per your need. Please check the below sample code.<br /><br />DATA sampledata;<br /> INPUT @6 date1 ddmmyy8. @15 date2 ddmmyy10.;<br /> FORMAT date1 ddmmyy8. date2 ddmmyy10.;<br /> cards;<br /> 30-12-16 30-12-2016<br /> ;<br />RUN;ravihttps://www.blogger.com/profile/12051180291065695712noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-67100335822514376612022-01-23T21:07:27.378-08:002022-01-23T21:07:27.378-08:00We can use mmddyy10.; formatWe can use mmddyy10.; formatravihttps://www.blogger.com/profile/12051180291065695712noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-34443750873694772962021-09-16T10:21:10.999-07:002021-09-16T10:21:10.999-07:00I want to read dates in different formats in the s...I want to read dates in different formats in the same dataset how i can solve thisAnonymoushttps://www.blogger.com/profile/01994722729784562461noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-6523690652949309822021-08-07T10:18:16.886-07:002021-08-07T10:18:16.886-07:00Try Date11.Try Date11.Moxie Doodlesackhttps://www.blogger.com/profile/03587213224517927851noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-34181973651988993862021-06-13T09:44:13.040-07:002021-06-13T09:44:13.040-07:00Data Mrg;
Infile '\home\data\ds\Mrg.txt';
...Data Mrg;<br />Infile '\home\data\ds\Mrg.txt';<br />Input member Id name$ dob;<br />Datalines;<br />Run;<br /><br />I want date format dob example.16-04-1999,infile store input value 16041999 how to solve..<br />Rajahttps://www.blogger.com/profile/07289864962341550045noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-87395140863515932052021-04-13T12:13:23.694-07:002021-04-13T12:13:23.694-07:00@X -- It defines the starting position of your dat...@X -- It defines the starting position of your data set. In above example @6 signifies that column valure starts from 6th.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-17972122336799992682020-11-05T21:03:53.129-08:002020-11-05T21:03:53.129-08:00@--it is read it as single trail(@)in sas. it mean...@--it is read it as single trail(@)in sas. it means starting position of the variable.Anonymoushttps://www.blogger.com/profile/16054552801247046671noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-52648819397528391402020-11-05T20:52:59.563-08:002020-11-05T20:52:59.563-08:00use yymmdd10. format is helpful;use yymmdd10. format is helpful;Anonymoushttps://www.blogger.com/profile/16054552801247046671noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-67732790969744137832020-11-05T20:50:11.741-08:002020-11-05T20:50:11.741-08:00date9.;date9.;Anonymoushttps://www.blogger.com/profile/16054552801247046671noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-53692098100395749732019-09-14T13:41:01.661-07:002019-09-14T13:41:01.661-07:00Hi,
I think your data step is incorrect. Below i...Hi,<br /><br />I think your data step is incorrect. Below is what I thought it should be with some formats applied<br /><br />data rec;<br />a="12feb1980"d;<br />b="12feb1980"d;<br />c="12feb1980"d;<br />format a b c date9.;<br />run;<br /><br />proc print data=rec;<br />run;<br /><br />proc print data=rec;<br />format a b c WORDDATX19.;<br />run;<br /><br />proc print data=rec;<br />format a b c DDMMYYS10.;<br />run;Hockleberry Cloverhttps://www.blogger.com/profile/11601801206642285721noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-57961579975445251492019-02-22T10:59:32.502-08:002019-02-22T10:59:32.502-08:00hi i have doubt on the following programme how can...hi i have doubt on the following programme how can sas read the data and how i have to use informat and format<br />data=rec;<br />a=12feb1980;<br />b="12feb1980";<br />c="12feb1980"d;<br />run;<br />proc print data=rec;<br />run;Unknownhttps://www.blogger.com/profile/14988880809924743910noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-36807996408240171282019-01-19T20:56:04.700-08:002019-01-19T20:56:04.700-08:00even i hv the same questioneven i hv the same questionAnonymoushttps://www.blogger.com/profile/13367425734431308736noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-68956171927615774542018-11-10T05:19:22.603-08:002018-11-10T05:19:22.603-08:00data _null_;
today=datetime();
format today dateti...data _null_;<br />today=datetime();<br />format today datetime.;<br />put today;<br />run;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-54735334018098154082018-10-04T03:47:26.969-07:002018-10-04T03:47:26.969-07:00which format should be used to read date in mm-dd-...which format should be used to read date in mm-dd-yyyy format?Anonymoushttps://www.blogger.com/profile/04230137826512700334noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-47924498690452774482018-09-18T10:16:18.066-07:002018-09-18T10:16:18.066-07:00use yyddmm10. format this will help u!!use yyddmm10. format this will help u!!Anonymoushttps://www.blogger.com/profile/12178730044636969260noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-1694798351556875512018-08-01T11:28:58.026-07:002018-08-01T11:28:58.026-07:00Above date i have to read through CSV file.Above date i have to read through CSV file.Anonymoushttps://www.blogger.com/profile/00258760143120850240noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-84243840225496986692018-08-01T11:27:41.404-07:002018-08-01T11:27:41.404-07:00How to read below type of format:
2012-03-02
kindl...How to read below type of format:<br />2012-03-02<br />kindly suggest.Anonymoushttps://www.blogger.com/profile/00258760143120850240noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-56953546303613002542018-05-14T08:38:23.171-07:002018-05-14T08:38:23.171-07:00Use "monname"
Example :
data xyz;
dt=t...Use "monname"<br /><br />Example : <br />data xyz;<br />dt=today();<br />format dt monname.;<br />run;<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10743096957307034602018-05-14T08:12:49.329-07:002018-05-14T08:12:49.329-07:00what is the use of @ in this chapter. i believe th...what is the use of @ in this chapter. i believe this @ symbol is used for the formatting.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-32685881299699928892018-03-02T20:06:01.762-08:002018-03-02T20:06:01.762-08:00Hello Deepanshu
as we have different dates in on...Hello Deepanshu <br />as we have different dates in one format using anydtdte. <br />can we convert dates in one variable in different formats? <br />Karanhttps://www.blogger.com/profile/08190687005998238861noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-56687039537538226402018-01-09T15:18:21.412-08:002018-01-09T15:18:21.412-08:00Why used @6 and @15 in the below statment.
INPUT ...Why used @6 and @15 in the below statment.<br /><br />INPUT @6 date1 ddmmyy8. @15 date2 ddmmyy10.;Anonymousnoreply@blogger.com