Answer / rc

1. Reprogram and compare output.


2. Check log to see no warnings, errors.


etc.

Answer / bk

1.By checking log for Error and warrings. Automatic
variable _ERROR_ values should not be 1 .

2.By using SAS debugger

Answer / thirumalesh.e

when you write your sas programme include debugging and macro debugging statements at each step boundary and check for errors and messages at log by including put statement along with macro expressions. use all macro debugging statements efficiently. if you get right programme with less or no errors after debugging its validated and file the validated programme according to regulations.

Answer / russ

Verify statement;

Answer / sunil kantilal

Using the OBS=0 session option would result only in
Compilation of the code. Any other way of running the code
actually change/update/modify the dataset while running.
Including the debugger option. So the only way to trace the
errors and working of the syntax would be to unable the

OPTION OBS=0

Answer / ram

using sas functions
i.e missover,

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

0 Answers   L&T,

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 happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 Answers  

How would you delete observations with duplicate keys?

13 Answers   Accenture,

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

How we will Developing new reports Using Data step programming and Macros ?

4 Answers  

what the use of proc glm

1 Answers   Accenture, C Marc,

What does a PROC TRANSPOSE do?

8 Answers   Accenture,

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

Mention how to limit decimal places for the variable using proc means?

0 Answers