Answer / ragg

here is the code for your question.
proc sql;
select *
from sashelp.shoes
where Region like 'A%';
quit;
it will list out all letters starting with 'A'in region variable.

Answer / vema reddy dwarampudi

Please add from clause in the above code
proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
from sashelp.shoes
where Region like 'A%';
quit;

Answer / vema reddy dwarampudi

proc sql noprint;
select "'"||left(trim(Region))||"'" into :inlist separated
by ','
where Region like 'A%';
quit;

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  

---

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

0 Answers  

---

How we can call macros with in data step? : sas-macro

0 Answers  

---

Name statements that function at both compile and execution time.

3 Answers   L&T,

---

what is operational data and operational system? : Sas-di

0 Answers  

---

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,

---

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

0 Answers  

---

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  

---

Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,

---

Which date function advances a date, time or datetime value by a given interval?

0 Answers  

---

What would you change about your job?

0 Answers   Oracle,

---

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

---