About andreas_lds

andreas_lds · ‎04-24-2017

Seems to be a clone of https://communities.sas.com/t5/Base-SAS-Programming/sas-eg/td-p/351650. Please post code using the "running-man-icon". Please post the code you already have written. The condition "date_diff="31MAR2017-date" seems to depend on the data ...

andreas_lds · ‎04-20-2017

Posting code and log will help to answer your question.

andreas_lds · ‎04-19-2017

Similar questions are asked at least daily, please use the search functionality. New documentation site: http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=basewn&docsetTarget=helpcenterfeedback.htm&locale=de Related to your problem: http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=basess&docsetTarget=p19t3r1gxavpoin14jdd23gcheve.htm&locale=de

andreas_lds · ‎04-19-2017

The function prxparse checks the syntax of a regular expression, it does not check wether a something matches the expression. You need to use prxmatch for that.

andreas_lds · ‎04-18-2017

The filename statement [https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003041481.htm] can establish a connection to a sftp-server. filename narf sftp "DailyReport.xls" host="..." ...; proc export outfile=narf ...;

andreas_lds · ‎03-30-2017

Check the options of the client you are using. Enterprise Guide and SAS Studio have options to prevent the opening of generated results. Unfortunately this option is active or not for all results.

andreas_lds · ‎03-22-2017

Text decoration is only possible in reporting procedures. There are numerous papers explaning anything relevant in detail.

andreas_lds · ‎03-22-2017

What @Reeza with "converted" meant, was that you have to open the file in Excel and save it as xls/xlsx file manually. Only then it can be imported again.

andreas_lds · ‎03-21-2017

Thanks, wasn't aware of _htmlout Using cssStyle-options works also.

andreas_lds · ‎03-20-2017

In a stored process using a custom style is not to difficult: ods html5 body=_webout(no_bottom_matter url=&_replay title= "yet another title") path=&_tmpcat cssStyle="path-to-css-file"; This does not work in SAS Studio, research lead me to http://support.sas.com/documentation/cdl/en/webeditorug/68828/HTML/default/viewer.htm#n0npxqhd54fc7zn1fts08c6oe17z.htm explaining how to use a custom style. Unfortunately this does not work as expected. Expectation is, that the result tab contains, e.g. proc print, results formated with the information from my css file. The best result I had was an empty result tab and a well formatted html-file in WORK. Acceptable is a download/open link comparable to result tag in Enterprise Guide, when using explicit ods statements. Any ideas? Using SAS Studio 3.6 @ SAS BI Server.

andreas_lds · ‎03-20-2017

using a proepr datetime constant will most likely solve the issue, but because you have not posted the error message, this is just guessed.

andreas_lds · ‎03-17-2017

Instead of proc tabulate use: proc summary data=work.txn nway; class TxnType / mlf preloadfmt order=data; class date; var TxnAmount; format txntype $txncode.; output out=work.summed(drop=_:) sum=; run; proc transpose data=work.summed out=work.want(drop=_name_); by TxnType notsorted; var TxnAmount; id date; format date monyy7.; run;

andreas_lds · ‎03-14-2017

@gamotte wrote: Note that if you have several calls with no condition, the same output dataset name will be used and will thus be overwritten. You may want to add a suffix parameter to your macro. You also made a mistake in the macro call %extract(condition='a'); should be %extract(condition=a); Problem: the quotes are necessary if var is alphanumeric, so appending a dequoted version of condition to the dataset-name is recommended.

andreas_lds · ‎03-08-2017

@JuanS_OCS: Thanks for correcting my outdated information.

andreas_lds · ‎03-08-2017

You have to store the files the directory of the web application. Files used by Stored Process WebApp, e.g, have to be stored in ?:\SAS\Config\LevX\Web\WebAppServer\SASServer1_1\sas_webapps\sas.storedprocess.war (using SAS 9.4). To prevent losing your files when applying a hotfix you should add those files to the installation directory.

Re: Find client number

Re: problem with ODS in SAS EG 8.3

Re: How to Sleep/Rest during loops AND FREE all the resouce[not freeze...

Re: problem with where clause on numeric

Re: Code to search for .zipx files in a Windows directory and export l...

Re: order of data sets that appear in window

Re: order of data sets that appear in window

Re: How to Save Out PLOT from PROC SGPLOT into A PIC FILE with explici...

Re: Improving performance of a CSV export

Re: the highest result needs to be selected if ID has more than one va...

Fix ""buggish-like" behavior of DOPEN() and DNUM() functions.

Re: How to Sleep/Rest during loops AND FREE all the resouce[not freeze...

Re: Identifying consecutive values

Re: Copy the file

Fun With SAS and Emoji: What Might a Rebus-Influenced Programming Lang...

Re: problem with ODS in SAS EG 8.3

Re: Code to search for .zipx files in a Windows directory and export l...

Re: the highest result needs to be selected if ID has more than one va...

Re: Copy the file

Re: proc sql view vs table

Re: Date difference in days excluding holidays

Re: Readin in datasets from a mainframe host

Re: Merging Two data sets

Re: Perl Regular Expression PRXPARSE

Re: Move all files of one folder using sftp

Re: Not to genrate PDF automatically

Re: Changing color and styling for character variables

Re: import xls with numeric/characters data in SAS

Re: SAS Studio on MidTier, howto use custom css

SAS Studio on MidTier, howto use custom css

Re: DATETIME20 Format error on where clause

Re: How can I tranform a long table to wide table?

Re: How to create PROC SQL with conditional macro variables?

Re: SAS Stored Process will not read javascript

Re: SAS Stored Process will not read javascript

CoDe SAS German