Answer Posted / pambrose

Here is the detailed usage of intnx function

date1=intnx('month','01jan95'd,5,'beginning');
put date1 / date1 date7.;

date2=intnx('month','01jan95'd,5,'middle');
put date2 / date2 date7.;

date3=intnx('month','01jan95'd,5,'end');
put date3 / date3 date7.;

date4=intnx('month','01jan95'd,5,'sameday');
put date4 / date4 date7.;

date5=intnx('month','15mar2000'd,5,'same');
put date5 / date5 date9.;

interval='month';
date='1sep2001'd;
align='m';
date4=intnx(interval,date,2,align)
;put date4 / date4 date7.;

what is sas database server? : Sas-di

1194

---

what is the difference between infile and input? : Sas-administrator

1204

---

How do you control the number of observations and/or variables read or written?

1298

---

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.

2337

---

What is the length assigned to the target variable by the scan function?

1208

---

How do dates work in SAS data?

1229

---

Explain proc univariate?

1108

---

What are the data types does SAS contain?

1170

---

what are the benefits of data integration? : Sas-di

1178

---

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

1118

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1110

---

what is enterprise guide? What is the use of it? : Sas programming

1070

---

What do you know about sas data set?

1193

---

Name few SAS functions?

1149

---

Compare sas with other data analytics tools.

1097

---