Answer / bala

***how we can get plc write sas code? ;
data prime;
input numbers @@;
datalines;
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
47 48 49 50 51 52 53 54 55 56 57 58
59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
76 77 78 79 80
;
run;


data p1(drop= p numbers);
set prime;
P=numbers;
if mod(P,1)= 0 and mod(P,P) = 0 and mod(P,2) ^= 0
and mod(P,3) ^= 0 and mod(P,5)^=0 and mod(P,7)^=0 then
Prime_numbers=P;
if P=3 or P=2 or P=5 or P=7 then Prime_numbers=P;
if not missing(prime_numbers);
put prime_numbers;
run;

Answer / sandeep

****** What is prime numbers?******
A) A prime number is a number that cannot be divided by a
number other than 1 and itself.

Answer / santosh reddy

data prime (drop=j count);
do i=100 to 1 by -1;
count=0;
do j=i to 1 by -1;
if mod(i,j)=0 then count+1;
end;
if count=2 then output;
/* output;*/
end;
run;

Answer / nandu

A small correction in the above one.

Data samp;
input number1 @@;
cards;
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
;
run;
data samp2;
set samp;
number2=number1 ;
if mod(number1,1) eq 0 and mod(number1,number2) eq 0
and (mod(number1,2) ne 0 and mod(number1,3) ne 0 and mod(number1,5) ne 0 and mod(number1,7) ne 0 and mod(number1,9) ne 0) then output ;
run;

Answer / nandu

Data samp;
input number1 @@;
cards;
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
;
run;
data samp2;
set samp;
number2=number1 ;
if mod(number1,1) eq 0 and mod(number1,number2) eq 0 then
output ;
run;

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 is a macro routine?

0 Answers  

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

0 Answers   Axis Bank,

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

0 Answers  

What is the use of the %include statement?

0 Answers  

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

0 Answers  

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

0 Answers  

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  

What are the statements in proc sql?

0 Answers  

Which of the following is not created during compilation phase?

2 Answers   SAS,

What SAS statements would you code to read an external raw data file to a DATA step?

10 Answers   NIIT,

what is ae onset date n what is RDS

0 Answers   Accenture,