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 |
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
what do the pad and dim functions do? : Sas programming
What are Dashboard reports?And significance of these in analysis?
What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
what is metadata? : Sas-bi
What are the default statistics for means procedure?
How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
how the sas basic syntax style described? : Sas-administrator
How would you code the criteria to restrict the output to be produced?
Give e an example of..