tag:blogger.com,1999:blog-3207512912949101943.post6665733983565269626..comments2024-03-28T20:09:46.028-07:00Comments on easy sas: DLM and DSD options in infile statement and & usagesas studyhttp://www.blogger.com/profile/13494555392947175879noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3207512912949101943.post-53486872493905122482022-02-07T20:43:20.729-08:002022-02-07T20:43:20.729-08:00data infile_c;
infile '/home/u59973295/sasuser...data infile_c;<br />infile '/home/u59973295/sasuser.v94/infile/c.txt' dlm=',-*';<br />input id name$ sex$ age sal area$ 25-41;<br />run;<br />data infile_c1;<br />set infile_c;<br />area=tranwrd (area,'-',' ');<br />area=tranwrd (area,'*',' ');<br />run;Anonymoushttps://www.blogger.com/profile/04833396985893961249noreply@blogger.comtag:blogger.com,1999:blog-3207512912949101943.post-19257892971602531762018-05-07T11:44:55.486-07:002018-05-07T11:44:55.486-07:00REMOVE THE EXTRA SPACE BEFORE M & F IN FIRST 2...REMOVE THE EXTRA SPACE BEFORE M & F IN FIRST 2 OBS UNDER GENDER VARIABLE AS IT CONSIDERS 2 CONSECUTIVE DELIMITERS (COMMA & SPACE) AS MISSINGAnonymoushttps://www.blogger.com/profile/11783369840288840118noreply@blogger.comtag:blogger.com,1999:blog-3207512912949101943.post-8266156075386784012018-05-07T11:43:14.879-07:002018-05-07T11:43:14.879-07:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/11783369840288840118noreply@blogger.comtag:blogger.com,1999:blog-3207512912949101943.post-26990395597835710152018-04-05T03:24:25.134-07:002018-04-05T03:24:25.134-07:00Use dsd option after dlmUse dsd option after dlmAnonymoushttps://www.blogger.com/profile/16702019354767026746noreply@blogger.comtag:blogger.com,1999:blog-3207512912949101943.post-76259109179081746612018-03-29T02:40:07.789-07:002018-03-29T02:40:07.789-07:00hi,
i am new to sas programming, i was trying to ...hi,<br /><br />i am new to sas programming, i was trying to use multiple delimiter options, for the following cards<br />001*Alfred, M,24,10000,"a-nagar,Hyderabad"<br />002*Alice, F,23,10000,"b-nagar,Hyderabad"<br />003*Barbara,F,23,20000,"a-nagar,Hyderabad"<br /><br />code:<br /> data SPECIAL;<br />infile datalines dlm='* ,';<br />input ID NAME$ SEX$ AGE SALARY ADDRESS:$20.;<br />datalines;<br />001*Alfred, M,24,10000,"a-nagar,Hyderabad"<br />002*Alice, F,23,10000,"b-nagar,Hyderabad"<br />003*Barbara,F,23,20000,"a-nagar,Hyderabad"<br />;<br />run;<br /><br />output:<br />Obs ID NAME SEX AGE SALARY ADDRESS <br />1 1 Alfred M 24 10000 "a-nagar <br />2 2 Alice F 23 10000 "b-nagar <br />3 3 Barbara F 23 20000 "a-nagar <br /><br />the output is not complete or as i expected and the last column is truncated.<br /><br />can you help to suggest the correct usage of delimiters to have the complete data in output.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3207512912949101943.post-72929803349401404232016-04-26T14:11:20.613-07:002016-04-26T14:11:20.613-07:00Great. Explained in a simple way.Thanks.Great. Explained in a simple way.Thanks.aswadhamahttps://www.blogger.com/profile/16314763368434782418noreply@blogger.com