i'm just finished a project (egp) and pretty much is working as we need, now i want to build a GUI interface in order to making more friendly to use
at this moment it works as follow
filename NEW_FILE 'path file\file.txt ';
DATA dataset (drop= variable1 variable5) ;
LENGTH
variable1 8
variable2 $ 50
variable3 $ 50
variable4 $ 50
variable5 $ 50
variable6 $ 50
FORMAT
variable1 DDMMYY10.
variable2 $CHAR50.
variable3 $CHAR50.
variable4 $CHAR50.
variable5 $CHAR50.
variable6 $CHAR50.
INFILE NEW_FILE
DLM=';' DSD ;
.......
......
......
It its possible to get pathfile\file.txt using WINDOWS BROWSER ? (if not we are forcing to rename each file prior to use this sas project)
any ideas?
regards
Hello,
You have to define a prompt in the prompt manager. There is a "file or directory" type prompt that will do what you need. The prompt create a macro variable that you can use in your program. The macro variable have the same name has your defined prompt. You have to add your prompt in the program properties.
Hello,
You have to define a prompt in the prompt manager. There is a "file or directory" type prompt that will do what you need. The prompt create a macro variable that you can use in your program. The macro variable have the same name has your defined prompt. You have to add your prompt in the program properties.
seems to be the right way to solve this problem but still missing something.
once i add the prompt to program properties, indeed program ask for the file , but is unable to import any data
"ERROR: No logical assign for filename NEW_FILE "
prompt is with variable name NEW_FILE and program is
filename NEW_FILE ;
data step.....
length.....
format......
.....
.....
INFILE NEW_FILE
DLM=';' DSD ;
what am i missing here?
seems to be the right way to solve this problem but still missing something.
once i add the prompt to program properties, indeed program ask for the file , but is unable to import any data
"ERROR: No logical assign for filename NEW_FILE "
prompt is with variable name NEW_FILE and program is
filename NEW_FILE ;
data step.....
length.....
format......
.....
.....
INFILE NEW_FILE
DLM=';' DSD ;
what am i missing here?
i'm realize how configure the macro varible in infile statment.
infile "&NEW_FILE"
regards,
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: