1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

Name the option to produce a frequency line items rather
that a table.

Question Posted / guest

Answers were Sorted based on User's Feedback



Name the option to produce a frequency line items rather that a table. ..

Answer / sreekanth rao

use the list option in table statement.it will not print
the table, it will print only line items.

LIST

displays two-way to n-way tables in a list format rather
than as crosstabulation tables

proc freq data= SampleData;
tables XX*YY/ list;

please provide the comments

Is This Answer Correct ?    18 Yes 0 No

Name the option to produce a frequency line items rather that a table. ..

Answer / x

Use levels option with no print for table

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SAS Interview Questions

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 Answers  

How would you invoke a macro? : sas-macro

0 Answers  

How to sort in descending order?

0 Answers  

what is the difference between informat$8. $char8.

3 Answers   SAS,




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.

0 Answers  

What makes sas stand out to be the best over other data analytics tools?

0 Answers  

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

0 Answers  

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

for whom is sas data integration studio designed? : Sas-di

0 Answers  

What is Transaction...? And what are Comment, Roll back n Save point..?

2 Answers  

How do you write a test plan?

1 Answers   Oracle,

For more SAS Interview Questions Click Here
Categories