About FK1

FK1 · ‎09-11-2018

Hi @SASKiwi, thank's for the hint with the utility macro. I'll just use this as a work around. Cheers, FK1

Kurt_Bremser · ‎09-04-2018

Passiert jedem mal.

RW9 · ‎06-14-2018

Post the log, with options mlogic mprint symbolgen turned on. Also, please avoid coding in SHOUTING case, it really makes code hard to read.

Kurt_Bremser · ‎04-06-2018

In my macro definition, inval is a positional parameter, identified by its position in the list; what you are thinking of are keyword parameters (see http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#macro-stmt.htm). It all depends on your macro definition; with positional parameters, you have to keep the correct order, with keyword parameters, you need to supply their name when calling the macro. Since I like shorter code, I usually use positional parameters.

Tom · ‎03-08-2018

It is a "feature" of SAS. If you use the wrong type of format/informat SAS just fixes it for you. Mainly in PUT/INPUT statements I think. 2646 data _null_; 2647 set sashelp.class (obs=2); 2648 put name best. ; ----- 484 NOTE 484-185: Format $BEST was not found or could not be loaded. 2649 run; Alfred Alice NOTE: There were 2 observations read from the data set SASHELP.CLASS. By naming the formats the same, except for the $ prefix, I was able to take advantage of it. In your real program you would probably want to use the right format for each specific variable.

FK1 · ‎01-31-2018

Thanks, novinosrin! It works perfectly fine.

FK1 · ‎01-11-2018

Sometimes the easiest things are the ones that cause trouble 🙂

Astounding · ‎12-14-2017

A small step to try ... this particular command does not require %nrbquote. Try getting rid of %unquote and %nrbquote and the two sets of parentheses and see if that improves the information you receive about where the problem lies.

FK1 · ‎12-14-2017

Hi there, I do want to pick up on this topic again, as I am still having troubles: Like last time I want to execute a shell command from within SAS, but this time using %unquote(%nrbquote(.....)) : %sysexec %unquote(%nrbquote( ssh johndoe@some.server.host <MYSQL credentials> > /home/some/path/test42.txt <<< "select * from information_schema.TABLES WHERE table_schema = 'some_value' ")); I do get neither Errors nor Warnings, however, when I %PUT the &SYSRC. I can see, it has a value of "2", i.e. ERROR-message. I do know for sure that the shell command is correct, as I tested it interactively in the shell prompt and it worked just fine, meaning: it "filled" the textfile "test42". What's going on herre?

FK1 · ‎11-20-2017

You can use the "Finfo" (=file information item) function which is offered by SAS: data info; length infoname infoval $60; drop rc fid infonum i close; rc=filename('abc','physical-filename'); fid=fopen('abc'); infonum=foptnum(fid); do i=1 to infonum; infoname=foptname(fid,i); infoval=finfo(fid,infoname); output; end; close=fclose(fid); run; Depending on the Operating System (Windows, UNIX, z/Os, etc.) you get some information bits about your DataSet. For more information: http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p0cpuq4ew0dxipn1vtravlludjm7.htm Cheers, FK

FK1 · ‎10-06-2017

Thanks everybody for your help! Glad to see, there are so many SAS Specialists 🙂

FK1 · ‎08-21-2017

Hello Ann, even though I cannot help you with the BING API issue, I was wondering whether you could help me with a "How-to-Guide" regarding GA. I am trying to access the Google Analytics API from SAS (version 9.3.) using SAS Enterprise Guide. However, I do have SAS DI as well, so I could try it with DI, too. So far I have never worked with SAS DI, however. Is it very complicated? Cheers, FK

Quentin · ‎02-22-2017

Nice explanation @Kurt_Bremser. Note that due to the timing issues you address, &unique_values1 and &unique_values2 both resolve to null on the %PUT statements in the macro. (Assuming they don't already exist in global symbol table) This is because the %PUT statements execute before the SQL step executes.

ballardw · ‎02-09-2017

Or place it in a separate library that only you have access to.

FK1 · ‎01-27-2017

Just in case, someone want to know, here ist the "translation" of (regexp_replace (COL2, '[^[:digit:]]', ''), 0) into ANSI-SQL: CASE WHEN input(COL2, $1.) IN ("1" "2" "3" "4" "5" "6" "7" "8" "9") THEN 1 ELSE 0 END as flag @ReezaI have already figured out the decode() function...

Online Status	Offline
Date Last Visited	‎10-26-2023 05:25 AM

Re: Generate SAS Dataset out of Deployment Registry Report (Deployment...

Generate SAS Dataset out of Deployment Registry Report (DeploymentRegi...

Re: Interim RHEL 8 Tuning Guidelines for SAS

Data Integration Studio: problematic code generation

Macro Variable Resolution Problenm

Re: WRS-Report (.srx) >> IMAP >>> Datasets

WRS-Report (.srx) >> IMAP >>> Datasets

sasevs@saspw polluting Metadatalog and Object Spawner Log

Special missing value(s)

Re: Advanced use of PROC FORMAT

Re: Special missing value(s)

Re: Interim RHEL 8 Tuning Guidelines for SAS

Re: Odd decimal behaviour - precission error?

Re: Security Report with SAS-Autocall Macros mdsec**

Re: Security Report with SAS-Autocall Macros mdsec**

Advanced use of PROC FORMAT

Wildcard Infile Statement: use Logfile NOTE information of <Number of ...

Re: Git in combination with code executed on SAS server

Re: List deployed Jobs which are not in a Flow

Re: List deployed Jobs which are not in a Flow

Re: PROC CONTENTS with DB2-Tables

Re: Formats showing wrong weekday.

Re: %COPY Statement, Error: "Macro keyword END appears as text.

Re: Looping through Macro Execution

Re: Replace _NULL_ values

Re: break SCD2 values into single years

Re: RETURN VALUE OPTIONS for GETOPITON

Re: Shell command from SAS-EG

Re: Mask/Unmask Macrovar in %sysexecute - statement

Re: SAS query - Dataset Owner

Re: BATCH vs. INTERACTIVE EG-SESSION

Re: Bing Ads API and Sas

Re: CALL EXECUTE trouble with local vs. global scope (and how to loop)

Re: Restrict Access to a specific Table within a Library to certain us...

Re: CONVERT ORACLE-SQL TO (SAS) ANSI-SQL

SAS Analytics Explorers

SAS Plattform Netzwerk

SUGA

CoDe SAS German