Interested to Buy Any Domain ? << Click Here >> for more details...
i have a data set with 20 observations i want label from
8 to 15 observations ? how you create this one.
- 6 Answers
- 12966 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / anil
data class;
set sashelp.class(firstobs=8 obs=18);
name='surname';
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what do you mean by data staging area? : Sas-di
What are the differences between sum function and using “+” operator?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
How can you limit the variables written to output dataset in data step?
What are the parameters of scan function?
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.
Describe the function and untility of the most difficult SAS macro that you have written.
Mention few capabilities of sas framework.
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
explain about data integrator metadata reports? : Sas-di
What are the different types of sas functions?
How to read an input file in sas?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
List down the reasons for choosing sas over other data analytics tools.
What is the difference between using drop = data set option in data statement and set statement?
