Answer / somnath

=> Symget is used to resolve macro variables in data step
and & is used to resolve macro variable in macro processing.
For example, if you have 10 macro variables name1-name10
which contains 10 names and you want to get a particular
name in a data step then you can use symget, not &.
data rank;
i=4;
run;

data name;
set rank;
name=symget('name' || left(put(i, 8.)));
run;

=> The same concept applies for call symput.

The main idea is that the routines symget and symput are
executed at sas run-time where & and %let executes at macro
run time, much before that sas executes it.

how do u handle table control inbdc explain the process in steps iwant the answer in urgent please forward this even i know how to explain there

0 Answers   Synopsis,

---

Define distributed queries. can you explain me as soon as possible

0 Answers   HCL,

---

what is mutex?

4 Answers   Axiom, Blue Star, SQL Star,

---

SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge

0 Answers  

---

Who is the Best SAS/Clinical Trainer in Hyderabad

1 Answers  

---

how do i add a column dynamically in a table by using java application?

0 Answers  

---

What is autocall macro and how to create autocall macro? what is the use of it?

0 Answers   GE,

---

how to convert the data from HTML file to SAS dataset?

0 Answers   Accenture,

---

what is the difference between rename and label

0 Answers   Satyam,

---

HTML is a subset of

8 Answers  

---

In an customer exit (include Z) program, only the last record is getting fetched. The exit is getting called after pressing save button. What to write for fetching the first record ? Before saved to a SAP table how can i call all these records in an itab in the exit ?

0 Answers  

---

suppose we have ten members of a physical file but we want the output of last 5 members only.how to achieve that?

0 Answers   Bank Of America,

---