Diff between Proc transpose and Arrays with example?
- 2 Answers
- 6004 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / imrankhan
proc transpose does not deal with missing values and cannot show the missing values in report. the work around for this problem is to use datastep with arrays.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
i want to insert textbox value to sql db. i have only one text box but store four values. ple give any one give sample code in asp.net c#..
there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box. eg: 3 box contain stick as:1,1,1. if u take 1 stick from 3rd numbred box you will any how win the match.
How to change the color of a cell or a row in a datagrid on mouse hover using javascript/.net
What is the difference beween joblib and steplib statements
How does the type system works when there is interoperability between a COM and .Net, i mean what exactly happens there
why we use abstract in awt?
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
hoe to data grid use in sql server 2000?
Compare any 4 software development life cycle paradigms with each other. Indicate at least one application for each of the paradigms that are suitable to developed using that paradigm.
is it acceptable if we declare multiple exceptions in same overridden method.
Hello Experts, What is the difference between move and move corresponding exactly? please post me asap
what is apt_dump_score in datastage where it is useful
iam confused to choose among testing, .net and java can anybody help me????????
Find out the list of roles which gives access to GUI activities? thanks in advance
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
