Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 13535 Views
- Wipro, Xansa, I also Faced
- E-Mail Answers
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 |
Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
Explain bmdp procedure?
How many versions came upto now in SAS?
What is the good sas programming practices for processing large data sets?
What is difference between rename and lable in sas?
how to delete the duplicates by using proc sql?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
what is SAS/Access and SAS/Connect?what are the uses?
what is the difference between floor and ceil functions in sas? : Sas-administrator
What are symbol tables?Differemce between Local N Global Symbol tables.....
Teradata 
