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 |
Difference between nodup and nodupkey options?
How to create an external dataset with sas code?
How do you debug and test your SAS programs?
how to remove duplicates using proc sql?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
what is snowflake schema? : Sas-di
How would you code a merge that will keep only the observations that have matches from both sets?
How do you write a test plan?
Explain what is SAS informats?
how can get the first and last observations in a dataset using Proc SQl?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How do you put a giraffe into the refrigerator?