The / is used in a put statement. Each / breaks a line, thus start a new line. // is therefor adds two space lines. ... View more

@AshPatel wrote: sorry, I should have said match based on ZIP and City.  I would like to have the match based on the shortest distance (e.g. in case of zip 14213, the output would be SEQ=1 and not SEQ=3.  If there is no match for a record in Dataset_1, then need to have a separate output for it (e.g. ZIP 14208) That is exactly what my code do. Have you run the code on your data? Have you checked the results?   I named the test data have1 (instead dataset_1) and have2 (instead dataset_2). The output named want1 are the matched data, want2 the not matched. ... View more

You should post test data as data steps using infile method with datalines - as in my proposed code. Most contributors are short in time and will not trouble to type the data step or copy line by line as I did. Even I did not copy all 2nd data set lines.    Anyway you can try and check next code: data have1; infile datalines dlm='09'x truncover; input zip ClientNo $ city $char30.; datalines; 14215 A52498 Buffalo 14213 A09533 Buffalo 14207 A63397 Buffalo 14216 A77384 Buffalo 14220 A73552 Buffalo 14214 A31165 Buffalo 14211 A06391 Bristol 14206 A71649 Bristol 14222 A66949 Bristol 14210 A43865 Bristol 14201 A95572 Cedar Grove 14208 A06957 Cedar Grove 14204 A91374 Cedar Grove 14209 A58062 Cedar Grove 14212 A54498 Cedar Grove ;run; data have2; infile datalines dlm='09'x truncover; input zip SEQ Distance_Miles city $char30.; datalines; 14215 1 1.2 Sloan 14215 2 2.0 Amherst 14215 3 2.5 Buffalo 14215 4 6.0 Seneca 14215 5 10.0 Kenmore 14213 1 0.4 Buffalo 14213 2 1.5 Kenmore 14213 3 8.0 Blasdell 14213 4 12.0 Buffalo 14213 5 15.0 Blasdell 14201 1 1.1 Cedar Grove 14201 2 5.3 Sloan 14201 3 9.3 Amherst 14201 4 15.5 Buffalo 14201 5 30.1 Mo Town ; run; proc sort data=have1; by zip city; run; proc sort data=have2; by zip city; run; data temp want2; merge have1 (in=in1) have2 (in=in2); by zip city; if in1 then do; if in2 then output temp; else output want2; end; run; proc sort data=temp; by zip city Distance_Miles; run; data want1; set temp; by zip city; if first.city; run; ... View more

I'm not sure you understood what I meant. I can't guess the expected output. Maybe next code will give a hint to what I meant: %let str = {'Orva Stores': [36.99, 0.0, 'A2NEM58BFPMEIL', 1], 'J.WALKER LLC': [36.99, 0.0, 'A1B3KT3F9BMSN1', 1], 'Justin Smiles': [36.99, 0.0, 'A3SP9XX1M7ZN73', 1], 'Closeout Pro': [36.99, 0.0, 'A3IRLODW57QOBV', 1], 'Flow Dealz': [44.95, 0.0, 'A2GP4414DQTJ29', 1]}; data a; str = "&str"; str1 = compress(str,'{[}]'); length strx $40; do i=1 to 10; strx = scan(str1,i,':'); if strx ne ' ' then output; end; run; What are the expected variables and observations from this given string? ... View more

Please post the rules and the delimiters between the observations. You can use translate() function to replace the different delimiters into one specific delimiter then use scan() function in a loop to assign each value to appropriate variable.     ... View more

I assume %year is a predefined macro, unknown to me. What is the result of next test code: %let Jahr1=%year(&Auswertungstag.); %put *&Jahr1* are there blanks or special characters in the PUT result?   ... View more