> convert charcter to numeric in filter only using parse. >In below year is in character i coverted it in to numeric   IF ( 'year Parameter'p NotMissing ) RETURN ( Parse('year'n, 'NUMX4.') = Parse('year Parameter'p, 'NUMX4.') - 1 ) ELSE ( 'year'n NotMissing ) ... View more

@mhamlett   Use Info Window To Display Detailed Data. ... View more

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