data have; input claim_no name $; cards; 12345 test 23456 test1 23456 test2 12345 test1 45678 test3 45678 test4 ; run; proc sql; create table have1 as select distinct(claim_no) from have (obs=2); quit; DATA WANT; LENGTH NAME $10.; IF _N_=1 THEN DO; IF 0 THEN SET HAVE1 (KEEP=CLAIM_NO); DECLARE HASH HH(DATASET: 'HAVE1'); HH.DEFINEKEY ('CLAIM_NO'); HH.DEFINEDONE(); END; DO UNTIL(EOF); SET HAVE END=EOF;   IF HH.FIND()=0 THEN OUTPUT; ELSE DO; DELETE; OUTPUT; END; END; STOP; RUN; PROC PRINT; RUN; ... View more

Can you post some date like what you have right now and how you want it? It would be easier to solve that way. ... View more

With an example data base; input ID name$; cards; 1 Test 2 Yes 3 Push 4 In 5 Ye ; run; data new; input ID name$; cards; 1 Test 2 Yes 4 In 5 Ye ; run; proc sql; select * from base except all select * from new; quit; Output: ID name ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 3 Push ... View more

I totally understand what you are saying but my question is will you be able to connect to the server 10.0.29.88. using Enterprise Guide just like you connected to SAS Application Server 10.0.29.89. Check if this a possibility with the SAS Admin. Then remote submit the code on the server 10.0.29.88 but not on 10.0.29.89. where the files can be found. Let me see if there are any other opportunities in this case but I normally connect to the server where I have the code and remote submits on that server. ... View more

How do you normally connect to SAS Server? Can you try connecting to the other server in a similar fashion? Is that a possibility? ... View more

Proc Format is an alternative.                       http://analytics.ncsu.edu/sesug/2001/P-605.pdf Index is another alternative.                      http://www2.sas.com/proceedings/sugi26/p121-26.pdf Go through those links. Those papers have lots of Info. ... View more

Please post the complete code and log so it would be easy to resolve. ... View more

If this is how you want to see your results. PROVISION_ Line_Code DETAIL Result1 Result2 Result3 ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1 100 100 . . 2 200 . 200 . 3 300 . . 300 The code would be DATA TEST; INPUT Line_Code  PROVISION_DETAIL; CARDS; 1 100 2 200 3 300 ; RUN; PROC SQL; SELECT TEST.Line_Code,   TEST.Provision_Detail,   max(CASE WHEN Line_Code = 1 THEN Provision_Detail ELSE . END) AS Result1,   max(CASE WHEN Line_Code = 2 THEN Provision_Detail ELSE . END ) AS Result2,   max(CASE WHEN Line_Code = 3 THEN Provision_Detail ELSE . END ) AS Result3 FROM WORK.TEST AS TEST group by Line_Code; QUIT; ... View more

http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a000543699.htm ... View more

Thats because you are code doesn't have GROUP BY. When you use aggregate functions, GROUP BY must be used in the syntax. Please refer to the below link for further details. http://www.techonthenet.com/sql/group_by.php ... View more

I agree what Tom says. That might be a better approach. ... View more

Can you try the below code and let me know how it works? PROC IMPORT OUT= NUMBER             DATAFILE= "C:\Documents and Settings\Desktop\Euler\number.txt"             DBMS=TAB REPLACE;      GETNAMES=YES;      DATAROW=2; RUN; ... View more