how do i read multiple spaces in datasets?
eg: vijaya raghava perumal.I tried with using & but it
workss if its vijaya raghava but not for raghava
perumal.how to do this?
Answers were Sorted based on User's Feedback
Answer / dilip
use & and width.
data k;
input s &$22. t $;
cards;
vijaya ragava perumal raj
mohan raj krishna sharma
;
proc print;
run;
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / basha
data kk;
input name &$24. name1 $12.;
name3=name||name1;
datalines;
mega star chiranjeevi
;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandu
We cant create SAS Dataset name with Spaces. Spaces wont be
allowed in the SAS naming convention.
If Raw data is having Spaces, we need to use Period Input
Style.
Other-wise please give some information for this question
to understand well.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandu
using period style input will read ur multiple spaces.
Eg :
Data chandu ;
input name $ 1-22. ;
datalines ;
vijaya raghava perumal
run ;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sas programmer
HI ALL, IM UR FRIEND , PLEASE READ THE QUESTION ONCE
THE GUEST ASKED THE QUESTION IS
HOW DO I READ MULTIPLE SPACES IN DATASETS NOT IN DATA.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / x
create the dataset using option missing the variable which
requied & output it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nani
Whenever SAS encounters a period after a macro variable
reference, the period is treated as a way to end the macro
variable and then the period is thrown away.
| Is This Answer Correct ? | 0 Yes | 6 No |
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Explain what is data step?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
What is the order of evaluation of the comparison && logical && relational operators:?
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
What is the difference between the proc sql and data step?
What are exact SAS Base contents..?N what r SAS Tools..?
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
Name statements that are execution only?
How would you code a merge that will keep only the observations that have matches from both sets?