hello i am a novice in SAS and i am having problems creating a Menu in SAS. i cant access any of my files in the path,
the files are being read but cannot be open once clicked on
here is the code;
libname TestMenu " \\ctstudent2\studentusers\100407385\Desktop\test";
data mru;
infile datalines dlm=',';
input recent_fullname $ :char32. recent_alias $ :char32.;
datalines;
\Desktop\test\1.plt
\Desktop\test\2.plt
\Desktop\test\3.plt
\Desktop\test\4.plt\
run;
proc sql noprint;
select min(count(*),10) format=1. into :mru_item_count
from mru;
%put NOTE: Found &mru_item_count. items.;
* Build a name-value paired list of macro variables;
select distinct recent_fullname, recent_alias
into: mru_recent_fullname1-:mru_recent_fullname&mru_item_count,
: mru_recent_alias1-:mru_recent_alias&mru_item_count.
from mru;
* Debug;
%put _user_;
quit;
%macro build_mru;
menu file;
%do i = 1 %to &mru_item_count.;
item "&&mru_recent_alias&i." selection=cmd&i. ;
%end;
%do i = 1 %to &mru_item_count.;
selection cmd&i. "wpgm;fileopen ""&p.\&&f&i""";
%end;
%mend build_mru;
options mprint;
proc pmenu cat=TestMenu.menus;
menu main;
item 'File' menu=file mnemonic='F';
%build_mru
run;
quit;
data _null_;
window testwindow menu=TestMenu.menus.main
#2 @10 'Hello i hope this PMENU works ';
display testwindow;
run;
You may need to show contents of your MRU data set so we can see the actual commands built.
Anything involving external files I always look into relative vs complete paths as a likely culprit. When defined as relative, not from the root of a drive, then that is a common problem with "not found" and such.
Do you get any messages in the log?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.