I forgot to type Out1 libnames for every Want data set. I have edited the code as below. Yes, there should be 5 different paths but there should be only one code. /*CODE 1*/ LIBNAME OUT1 "C:\OUT1"; DATA OUT1.WANT; SET HAVE; RUN; /*CODE 2*/ LIBNAME OUT2 "C:\OUT2"; DATA OUT2.WANT; SET HAVE; RUN; /*CODE 3*/ LIBNAME OUT3 "C:\OUT3"; DATA OUT3.WANT; SET HAVE; RUN; /*CODE 4*/ LIBNAME OUT4 "C:\OUT4"; DATA OUT4.WANT; SET HAVE; RUN; /*CODE 5*/ LIBNAME OUT5 "C:\OUT5"; DATA OUT5.WANT; SET HAVE; RUN;   Maybe someting like the following structure, but I am not sure about how to do it well.   %MACRO PATH(LIBNAME); %IF &LIBNAME.= OUT1 %THEN %DO; LIBNAME OUT1 "C:\OUT1"; %END; %ELSE %IF &LIBNAME.= OUT2 %THEN %DO; LIBNAME OUT2 "C:\OUT2"; %END; %ELSE %IF &LIBNAME.= OUT3 %THEN %DO; LIBNAME OUT3 "C:\OUT3"; %END; %ELSE %IF &LIBNAME.= OUT4 %THEN %DO; LIBNAME OUT4 "C:\OUT4"; %END; %ELSE %IF &LIBNAME.= OUT5 %THEN %DO; LIBNAME OUT5 "C:\OUT5"; %END; %MEND PATH; %PATH(OUT1); %PATH(OUT2); %PATH(OUT3); %PATH(OUT4); %PATH(OUT5); /* &libname macro variable should be dynamic but I couldn't figure out how to do it */ LIBNAME &libname "C:\&libname"; DATA &libname.WANT; SET HAVE; RUN; ... View more

Here is code as text: DATA HAVE; LENGTH NAME $ 32 ID 8; INFILE DATALINES MISSOVER; INPUT NAME ID; DATALINES; JOHN 1 JACK 2 EMILY 3 BLAKE 4 ROBIN 5 BRAD 6 ; /*CODE 1*/ LIBNAME WANT "C:\OUT1"; DATA WANT; SET HAVE; RUN; /*CODE 2*/ LIBNAME WANT "C:\OUT2"; DATA WANT; SET HAVE; RUN; /*CODE 3*/ LIBNAME WANT "C:\OUT3"; DATA WANT; SET HAVE; RUN; /*CODE 4*/ LIBNAME WANT "C:\OUT4"; DATA WANT; SET HAVE; RUN; /*CODE 5*/ LIBNAME WANT "C:\OUT5"; DATA WANT; SET HAVE; RUN; Thank you for your support. ... View more

I mean how can I do these with SAS code? ... View more

Yes, your assumptions are correct.   We can both work on Sas Studio and Sas EG. Yes, they can work with these Sas tools. About your third question, actually as you remember from Sas EG (I also attach the screenshot as below) I would like to similar screen for them to browse their local file in any browser.    ss As a summary, because we all have accessibility to Sas Visual Analytics hub, we expect to create browser screen to import our local file. To do this, we need Sas scripts to build that structure. Thanks, ... View more