Hello everyone,
I am trying to write the code for following scenario:
1. We have one excel sheet in which there is a column having filenames of .PPT files. All these PPTs are there on some location on the server,
say /sasconf/sasconf/data/PPTs.
2. We want to check that for every record in Excel sheet there exist a file name having exactly the same name provided in every record.
I have tried the following code logic, Which is not helping me. Is there any other logic or SAS function which can help me???
proc import out = proc_mast
datafile= '/sasconf/sasconf/data/department_masters/Process_master.xls'
DBMS = XLS Replace;
sheet = 'Process_MO_Excel_Master';
getnames=yes;
run;
data temp;
set proc_mast(keep = PPT_name);
run;
proc sql noprint;
select count(*) into :cnt from temp;
quit;
proc sql noprint;
select PPT_name into :count0-:count%sysfunc(strip(&cnt))
from temp;
quit;
%macro abc;
data temp11;
%do i=0 %to 35;
%if fileexist("/sasconf/sasconf/data/Data For Configuration/Credit_risk/PPTs/&&count&i..ppt") %then
exist_file=1;
%else
exist_file=0;
output;
%end;
run;
%mend abc;
%abc
Regards,
Rakshit
Hi Rakshit,
I have not gone through every single line of your code, but the following seems lacking %sysfunc:
%if fileexist("/sasconf/sasconf/data/Data For Configuration/Credit_risk/PPTs/&&count&i..ppt") %then
instead, you maybe try:
%if %sysfunc(fileexist("/sasconf/sasconf/data/Data For Configuration/Credit_risk/PPTs/&&count&i..ppt")) %then
Regards,
Haikuo
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.