About Martin_Bryant

Martin_Bryant · ‎07-15-2022

Many thanks. It looks like there are no other options that I've missed then but I don't think I understand SAS code well enough to see exactly how to use this from the code (especially as it isn't commented at all). I'll check the SAS EG docs again but I can't say I'm hopeful.

Martin_Bryant · ‎07-15-2022

I'm trying to use _eg_WhereParam but with limited success. Is there any documentation for this? I've got the basics but I need something that explains every option that can be used with it please. In my current code I have a multi-select prompt which is to be used in a proc sql; where clause such as %_eg_WhereParam( OptionType, PromptOption, IN, TYPE=S) however if the user doesn't select any items (the default option) then I want to effectively ignore this where clause. This would be the same as selecting all items from the list, but asking the user to select all items would be poor UI design and result in poor code. The best option is to be able to say if the selection is blank, ignore this where clause. I've found an example with things like... IS_EXPLICIT=0, MATCHALL=_ALL_VALUES_, MATCHALL_CLAUSE=1 but with no explanation as to what they do or if other options can be used. Another option is to check the prompt value myself, but if nothing has been selected I get WARNING: Apparent symbolic reference PROMPTOPTION not resolved. So I'm a bit stuck. Thanks.

Martin_Bryant · ‎07-15-2022

The videos seem to have vanished (for me at least) and the paper gives only limited information. Does anyone have a proper piece of documentation for this? Something that fully defines all parameters and options. I have to say that generally SAS documentation is the worst I've ever come across as a developer and I can't find anything at all for this particular item.

Martin_Bryant · ‎12-21-2021

Not sure I can upload work files to the web. Especially not with our data in. I might well post a review of the process. My personal laptop runs Linux and so I don't use Excel on that, but I'll post what I can. 🙂

Martin_Bryant · ‎12-13-2021

Hi, thanks for the suggestion, but that isn't what we are looking to do. Regions are important as much as the data points. I don't think that this should be beyond the wit of man and I'm pretty sure that Excel can do it. Seems odd that SAS isn't capable. - Martin

Martin_Bryant · ‎12-10-2021

Thanks. I'll try that. If the block is so limited, what do you recommend I try as an alternative? Generally speaking I want UK maps, one area per LA (local authority), grouped into regions (which currently works well) and then one block / measurement per LA. Happy to try a number of solutions. Currently using SAS EG 7.

Martin_Bryant · ‎12-10-2021

Hi, I'm learning to use the GMAP functionality but I can't work out how to control the height of the BLOCK. My GMAP code is... goptions device=png Hsize=40cm Vsize=40cm; proc gmap gout=region_data data=region_data map=uk_map_w_region all; id id map_region; block thing / blocksize=1 legend=legend2 woutline=1; area map_region / legend=legend1; run; And this is my result... Map of the UK I know that there are a lot of blocks but I'd really like to make them all about 5% of the height that they currently are so that we can actually see the rest of the map. How can I do this?

Martin_Bryant · ‎02-26-2021

Thanks,I'm getting there with this. The SCAProc sounds useful, but there is no way I can get everyone to use it. So I think I'm stuck with this method.

Martin_Bryant · ‎02-25-2021

Once I have my full dataset listing the projects and their contents, then this will be used as a searchable repository of code. We will, for example, be able to enter a dataset name and find out which code refers to it. Then if we need to change the structure of said dataset, we can ensure that nothing else messes up.

Martin_Bryant · ‎02-25-2021

Maybe I need to restate my problem. I have the following code which works well. filename inzip zip "/user/Martin/myproject.egp" member="project.xml"; data _null_; infile inzip; input; put _infile_ ; run; Now, rather than display one file content in the log, I wish to create a dataset that holds two variables, the fileName and fileContent, and has one observation for each file I can find. I already have code that generate a dataset (fileList) that has one variable, projFile (full path and filename of the .egp files) and one observation for each file. So I wish to put the above code into a loop that uses projFile as the filename, and outputs to a new dataset. Does that help? I'm trying to write my own code but I clearly still have a lot to learn about SAS-EG code, especially macros. Thanks.

Martin_Bryant · ‎02-25-2021

Excellent, thanks. I will try that now.

Martin_Bryant · ‎02-24-2021

I'm a SAS newbie and I don't seem to be able to work out the correct syntax for this. I have a dataset (fileList) with one field (projFile) which holds a filename. I wish to open the file and read the contents into a second field that will be created. The file is zipped (it's a SAS-EG project file) and so I'm told that I should use Filename statement with the zip option to read the file. However, no matter how I reference projFile it doesn't like it. data fileList; set fileList; filename inzip zip "&projFile" member="project.xml"; infile inzip; input fileContent $char2000.; output; run; I may also have the input statement wrong, but until I can get past this issue, I don't know. Thanks.

Martin_Bryant · ‎02-17-2021

All of these are stored on a SAS server. We can't save locally.

Martin_Bryant · ‎02-16-2021

Hi, Is there a way to identify the SAS-EG code that opens a given dataset? We have a few core datasets that we want to update the structure of. Therefore we need to know any SAS-EG code that references this dataset so that we can update that code to prevent errors. I'd like to be able to search the folders listed under Servers->Files within SAS-EG. Failing this, any other way to search folders that contain .epg or .sas files. Thanks. - Martin

Martin_Bryant · ‎02-16-2021

Thanks. Found out what a PDV is and why you do the if 0 . Looks good. Will try that solution.

Online Status	Offline
Date Last Visited	‎04-04-2024 09:43 AM

Re: What is the best way to call a group of programs and reports repea...

Re: How to call one embedded program from another in SAS EG

How to call one embedded program from another in SAS EG

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

What is the best way to call a group of programs and reports repeatedl...

Re: What is the best way to call a group of programs and reports repea...

Re: Where is the documentation for _eg_WhereParam

Re: please explain %_eg_whereparam(....) for me.

Re: please explain %_eg_whereparam(....) for me.

Re: How can I Find Code that opens a given dataset?

Allow the option for programs to automatically be embedded in projects

Re: please explain %_eg_whereparam(....) for me.

Where is the documentation for _eg_WhereParam

Re: please explain %_eg_whereparam(....) for me.

Re: How to control the block height in gmap

Re: How to control the block height in gmap

Re: How to control the block height in gmap

How to control the block height in gmap

Re: Correct Syntax for Filename Statement using a dataset variable

Re: Correct Syntax for Filename Statement using a dataset variable

Re: Correct Syntax for Filename Statement using a dataset variable

Re: Correct Syntax for Filename Statement using a dataset variable

Correct Syntax for Filename Statement using a dataset variable

Re: How can I Find Code that opens a given dataset?

How can I Find Code that opens a given dataset?

Re: How to convert SQL to SAS code efficiently