The answer to your question lies in the post you have made: Warning: Apparent symbolic reference TEMP not resolved.  This means the macro variable TEMP is not being created.  Thus something is amis with the code (perhaps you are running on another OS or in a system where the environment variable does not exist): data _null_; temp = sysget('temp'); * Put the environment variable %temp% in SAS \ variable temp call symput ('temp', right(trim(temp))); * put the content of temp in the SAS macrovariable &temp; run; However, more importantly, this thread is 3 years old.  Start a new thread with your question, inputs, outputs, test data etc. I would advise against the use of VBS script as it may not work with your system. Are you trying to read in an Excel file?  No information to work with, hence why posting a full question would be betteras we have no idea what you are doing or how. ... View more