topic Re: Dynamic selection file in SAS Enterprise Guide

Dynamic selection file

jaselig — Mon, 11 May 2015 18:23:58 GMT

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

Re: Dynamic selection file

tlk — Mon, 11 May 2015 19:33:24 GMT

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.

Re: Dynamic selection file

jaselig — Tue, 12 May 2015 07:27:53 GMT

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?

Re: Dynamic selection file

jaselig — Tue, 12 May 2015 09:08:28 GMT

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?

Re: Dynamic selection file

jaselig — Tue, 12 May 2015 11:28:48 GMT

i'm realize how configure the macro varible in infile statment.

infile "&NEW_FILE"

regards,