Hi In the above dataset program you already created table in laser library.Now you need to register it to sas va. In the below code use your table in select clause which is highlited below and then specify va folder path where you want to store that data. /* Register Table Macro */ %macro registertable( REPOSITORY=Foundation, REPOSID=, LIBRARY=, TABLE=, FOLDER=, TABLEID=, PREFIX= ); %if %symexist(LASTSTEPRC) %then %do; %if %eval(&LASTSTEPRC. <= 4) %then %do; /* Mask special characters */ %let REPOSITORY=%superq(REPOSITORY); %let LIBRARY =%superq(LIBRARY); %let FOLDER =%superq(FOLDER); %let TABLE =%superq(TABLE); %let REPOSARG=%str(REPNAME="&REPOSITORY."); %if ("&REPOSID." ne "") %THEN %LET REPOSARG=%str(REPID="&REPOSID."); %if ("&TABLEID." ne "") %THEN %LET SELECTOBJ=%str(&TABLEID.); %else %LET SELECTOBJ=&TABLE.; %if ("&FOLDER." ne "") %THEN %PUT INFO: Registering &FOLDER./&SELECTOBJ. to &LIBRARY. library.; %else %PUT INFO: Registering &SELECTOBJ. to &LIBRARY. library.; proc metalib; omr ( library="&LIBRARY." %str(&REPOSARG.) ); %if ("&TABLEID." eq "") %THEN %DO; %if ("&FOLDER." ne "") %THEN %DO; folder="&FOLDER."; %end; %end; %if ("&PREFIX." ne "") %THEN %DO; prefix="&PREFIX."; %end; select ('InrTable'); run; quit; %end; %end; %mend; %registerTable( LIBRARY=%nrstr(/Shared Data/SAS Visual Analytics/Public/Visual Analytics Public LASR) , FOLDER=%nrstr(Specify VA FOLDER PATH HERE) );
... View more