Answer Posted / krishna

data c;
infile cards firstobs=8 obs=15;
input name$ sex $ age height weight;
label name='surname';
cards;
Joyce F 11 51.3 50.5
Jane F 12 59.8 84.5
Louise F 12 56.3 77.0
Alice F 13 56.5 84.0
Barbara F 13 65.3 98.0
Carol F 14 62.8 102.5
Judy F 14 64.3 90.0
Janet F 15 62.5 112.5
Mary F 15 66.5 112.0
Thomas M 11 57.5 85.0
James M 12 57.3 83.0
John M 12 59.0 99.5
Robert M 12 64.8 128.0
Jeffrey M 13 62.5 84.0
Alfred M 14 69.0 112.5
Henry M 14 63.5 102.5
Ronald M 15 67.0 133.0
William M 15 66.5 112.0
Philip M 16 72.0 150.0
;


another way


data class;
set sashelp.class(firstobs=8 obs=18);
label name='surname';
run;

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2059

---

For what purposes have you used sas macros? : sas-macro

954

---

Mention what are the data types does SAS contain?

1096

---

What do you know about sas data set?

1024

---

Define run-group processing?

981

---

what are the considerations when picking a SAS/STAT procedure?

3327

---

Explain how merging helps to combine data sets.

995

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1237

---

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

1017

---

How would you define the end of a macro? : sas-macro

1040

---

What are the data types in sas?

1004

---

it will become easy if uuu provide website linkssss and list of consultanciessssss

1923

---

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.

2225

---

Describe a time when you were really stuck on a problem and how you solved it?

2483

---

What is the basic structure of the SAS base program?

1232

---