Thank you so much! ... View more

Could you give me a sample code? I have never used hash lookup. ... View more

  This is a sample of dataset #1 (DS1) Names Descriptions John Tall guy Eclipse Red Car Toby Back and white dog Eliazar Refugee Jose Naturalized   This is an example of the second dataset (DS2) ID Names 5842 Jose 6359 Toby 8852 Jaime 7821 Eclipse 5636 Brenda     This is what I would like to have: ID Names Descriptions 5842 Jose Naturalized 6359 Toby Back and white dog 8852 Jaime   7821 Eclipse Red Car 5636 Brenda       The results I am receiving from the last data set have the third column empty.   Thank you for your help.             ... View more

I agree.. I cannot use real data. but I discovered the problem I am having is related to the length of the data. The codes in the real data have different lengths... For example: KK109Y40,Y744P0,K444U7,H402O2,Y4449HH898O9,YY4930,TT785U983I9 So in this example, the lengths are 11, 6, 12, 6, 6, 7. So, if I leave the array like this "Array RejC{4} $ (&RejCode);" it will truncate the values to the length of the first one It reads. However, if I use the length of the longest values like this: Array RejC{4} $12 (&RejCode); it doesn't like it. But if I use $11 instead of the longest, then it works. Have you ever seen something like this? Any ideas? ... View more

Hi, I just checked and we have SAS 9.3.  Will this be a dealbreaker when it comes to use SAS to parse the XML files? ... View more

Hi, What is really happening is that the value EG was setting to SYSLAST when I explicitly link a data set to a program in a process flow. EG in setting the SYSLAST macro to the linked data set. Because of this I am getting the following error. ERROR: Invalid option value IDATASET.'TABLE'n for SAS option _LAST_. If I don't link the dataset to the program in a process flow, the program runs without any errors. Here is the log. 1 The SAS System 10:50 Friday, December 14, 2018 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; ERROR: Invalid option value IDATASET.'TABLE'n for SAS option _LAST_. 3 %LET SYSLAST=IDATASET.'TABLE'n ; 4 %LET _CLIENTTASKLABEL='PA_1'; 5 %LET _CLIENTPROCESSFLOWNAME='PENALTIES ALL'; 6 %LET _CLIENTPROJECTPATH='C:\Users\XXXXXXX\Desktop\ANALYSIS.egp'; 7 %LET _CLIENTPROJECTNAME=ANALYSIS.egp'; 8 %LET _SASPROGRAMFILE=; 9 10 ODS _ALL_ CLOSE; 11 OPTIONS DEV=ACTIVEX; 12 GOPTIONS XPIXELS=0 YPIXELS=0; 13 FILENAME EGSR TEMP; 14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 15 STYLE=HtmlBlue 16 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 17 NOGTITLE 18 NOGFOOTNOTE 19 GPATH=&sasworklocation 20 ENCODING=UTF8 21 options(rolap="on") 22 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 23 24 GOPTIONS ACCESSIBLE; 25 /* Insert custom code before submitted code here */ 26 27 28 DATA IH_WORK.WANT; 29 SET 30 IDATASET.TABLE (DROP= VARINFO XREFMFT XREFTXPD XREFTIN) 31 IDATASET.TABLE2 (DROP= VARINFO); 32 IF TRANCD = '999' AND VARFIELD NOT = '000'; 33 RUN; NOTE: There were 667876 observations read from the data set IDATASET.TABLE. NOTE: There were 354978 observations read from the data set IDATASET.TABLE2. NOTE: The data set IH_WORK.WANT has 1018545 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 3.26 seconds cpu time 1.81 seconds 34 35 36 37 /* Insert custom code after submitted code here */ 38 39 GOPTIONS NOACCESSIBLE; 40 %LET _CLIENTTASKLABEL=; 41 %LET _CLIENTPROCESSFLOWNAME=; 42 %LET _CLIENTPROJECTPATH=; 43 %LET _CLIENTPROJECTNAME=; 44 %LET _SASPROGRAMFILE=; 45 46 ;*';*";*/;quit;run; 47 ODS _ALL_ CLOSE; 2 The SAS System 10:50 Friday, December 14, 2018 48 49 50 QUIT; RUN; 51 ... View more