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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.