Answer Posted / surendra

data abc;
input s w k g o t a m;
cards;
1 2 3 4 5 6 7 8
2 3 4 5 6 7 8 9
;
run;


proc transpose data=abc out=bca;
var s w k g o t a m;
run;

proc sort data=bca;
by _name_;
run;

proc transpose data=bca out=mca(drop=_name_);
id _name_;
var col1 col2;
run;

What is the maximum length of the macro variable?

1192

---

Given an unsorted data set, how to read the last observation to a new data set?

1361

---

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?

2255

---

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2156

---

how will you locate the sas platform applications? : Sas-bi

1037

---

What is the command used to find missing values?

1108

---

Can you execute a macro within a macro? Describe. : sas-macro

1116

---

What is the difference between the proc sql and data step?

1186

---

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1925

---

how to do user inputs and command line arguments in sas?

3057

---

What is the use of function Proc summary?

1293

---

explain what is factor analysis? : Sas-administrator

1118

---

what versions of sas have you used (on which platforms)? : Sas programming

1076

---

What is the role of sas grid administrator? : sas-grid-administration

1291

---

Do you need to know if there are any missing values?

1047

---