It is not space delimited in the correct sense: 1 8001000004 S BUDATI CHIRUHA 6 07/07/1989 34XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  ^                    ^ ^             ^                ^                    ^ I indicate where spaces appear in the text, as you can see to import a space delimited would mean S and BUDATI, and CHIRUHA all go to different variables as that also contains spaces.  Its quite a bad file really, anything using a good standard, like Comma Separated Variable file, would make this import a simple problem.  As you have accepted a poor file format, likely with very little standardisation or documentation, then you will have problems importing it.     You may be able to read the whole line in as one string and then process it as: scan(1," ") to get first part, then substr from there to drop this scan(2," ") to get second part, then substr from there to drop this Next substr to findc(numbers)-1 to get name and then substr to drop this Then scan each of the other two variables out   This is all caused by poor file format! ... View more

I want to make sure that I understand your question @rvsidhu035.  Are you asking about volunteering in some capacity (e.g. on the Content Advisory Team or the Content Delivery Team) for SAS Global Forum 2021 or are you interested in applying to the be the conference chair?  If you don't have a lot of experience with conference planning, I would suggest that you begin by volunteering at SAS Global Forum 2018 in some capacity and potentially volunteering at SAS Global Forum 2019 as well.  There are a lot of different ways to volunteer that will help you get a better feeling for what we do to plan SAS Global Forum each year.  Do you have experience in volunteering (helping determine content, taking part in helping with any conference logistics, etc) at local or regional SAS events where you are located?   If would rather take this off line from the SAS Communities area, my contact information can be found on the Conference Leadership website in the link in my original post.   Jennifer ... View more

filename fn pipe 'dir h:\temp\*.txt /s /b'; What is mean /s /b here ... View more

Your input text is tab delimited. It reads fine from a regular text file:   data functions; infile "&sasforum\datasets\rvsidhu035.txt" dsd dlm="09"x missover; input (x1-x6) (:$10.); run; proc print; var x1-x6; run; Obs x1 x2 x3 x4 x5 x6 1 abc123@#$ abc 123 @#$ abc123 abc@#$ 2 def123 def 123 def123 3 456@#$ 456 @#$ 4 @&*rtg rtg @&* @&*rtg 5 qwerty qwerty 6 !@#$% !@#$% 7 123456 12345 ... View more

@rvsidhu035: The original post you responded to was from 2011. Since 9.3 I think the best way to calculate age is to use the yrdif function (see: http://www.sascommunity.org/wiki/Tips:Calculating_Exact_Age_with_the_YRDIF_Function )   Art, CEO, AnalystFinder.com   ... View more

put function shows log file at pdv from source - pdv-ouput you check   data ravi; set sashelp.class; if age=11 then status="chiled"; put _all_; run;   ... View more