Answer Posted / guest

data dx;
infile datalines dsd dlm=',';
input parent :$8. child :$8.;
datalines;
A,B
B,C
D,E
F,G
G,H
H,I
;;;;
run;

data dy(rename=(parent=grandfather child=father)) ;
merge dx(firstobs=2 in =a rename=(child=grandchild
parent=child ))
dx(firstobs=1 in =b );
by child;
if a and b;
run;
proc print;
var grandfather father grandchild;
run;

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1179

---

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2053

---

what is metadata? : Sas-bi

967

---

Mention few capabilities of sas framework.

1125

---

Difference between SAS STATA & SPSS?

1058

---

If you could design your ideal job, what would it look like?

2870

---

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

983

---

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

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

959

---

What does the trace option do?

1054

---

What are the ways in which macro variables can be created in sas programming?

1029

---

how many types of prompts are there? : Sas-bi

1032

---

where to use sas business intelligence? : Sas-bi

1003

---

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;

2436

---

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

2199

---