what is TAB delimiter? explain about it? what will you do to
get TAB delimiter?
Answers were Sorted based on User's Feedback
Answer / sankar
TAB delimiter is seperate variables and observtons
it is use in infile statement as dlm='09'x.
proc import and proc export use a delimiter statement'
delimiter='09'x;
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / pnprasad
SAS reds the data from different files like .txt ASCII .xls
etc. For this use INFILE statement. While using this
statment we have to check the data formated in the related
file, i.e some may space, coma, tabs. So, if the file
contains TAB is the delimiter, we have to use
DLM=TAB / '09'X,(note: this is for horizantal TAB) to get
the observations in a defined format. (for Vertical TAb,
DLM='021'X.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / abhi
wn v r importing p\frm proc import frm xls.files
v use tab delimiters
it is used to set the spaces wn v r importing the xl sheet
| Is This Answer Correct ? | 3 Yes | 4 No |
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
What is difference between (a-z) and (a--z)
What is slibref?
Explain how merging helps to combine data sets.
what is function of retain statment
What is the order of application for output data set options, input data set options and SAS statements?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
How do you test for missing values?