About rudfaden

rudfaden · ‎10-21-2019

You can either send the format catalog or send the format in a data set and then let the reciever read the format themselves. By using the latter you avoid compatability issues.

rudfaden · ‎10-21-2019

I dont believe you can use a column directly for input. But you could make a macro that would take and input and run a ttest for each value in the input.

rudfaden · ‎10-01-2019

I can see that you put an i at the end of the statement. if (Issue_Date GE intnx('year', (today()- (i)), -1,'same')) and (Issue_Date LE (TODAY()- (i)) ) = i Is that a mistake? Maybe you want this data work.out_want; set work.data_have; array var(60) var_1 - var_60; do i=1 to 60; if (Issue_Date GE intnx('year', (today()- (i)), -1,'same')) and (Issue_Date LE (TODAY()- (i)) ) then var(i) = Amount; format var_1 - var_60 eurox18.2; end; drop i; run;

rudfaden · ‎10-01-2019

You need to describe what you want the condition to be.

rudfaden · ‎10-01-2019

Then you need to change your if statement. It does exactly what you told it to do.

rudfaden · ‎10-01-2019

It is not reallu clear to me what your problem is. The code seems to work fine.

rudfaden · ‎07-26-2019

Your need to give the columns you create a name PROC SQL; CREATE TABLE WORK.MATRIX_OUT AS SELECT t1.QT_APPENDICE, ((input(COMPRESS('12 / 10000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName1, ((input(COMPRESS('12 / 15000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName2, ((input(COMPRESS('12 / 20000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName3, ((input(COMPRESS('12 / 25000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName4, ((input(COMPRESS('12 / 30000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName5, ((input(COMPRESS('12 / 35000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName6, ((input(COMPRESS('12 / 40000'n),COMMAX10.2))) FORMAT=COMMAX10.2 as GiveMeAName7 FROM WORK.TRNSTRANSPOSED1 t1 WHERE t1.Origine NOT = 'Incrocio'; QUIT;

rudfaden · ‎05-23-2019

It does not work. As far as I understand this can only be done with the Excel engine which is not availible on unix. But if I am wrong, please let me know. I get the error ERROR: XL.Raaderum.DATA cannot be deleted because files cannot be deleted from the XL library.

rudfaden · ‎05-23-2019

As far as i can tell, the Excel libname engine is not supported on unix. the xlsx engine is, but is does not allow for deleting excel sheets. So is there a way to delete a excel sheet on a unix server running SAS?

rudfaden · ‎05-03-2019

I think the best solution is to make 2 charts. But if you want to keep both in one, you can use y2axis, to make the 2 charts use different y-axis. proc sgplot noborder data=test; styleattrs datacolors=( CYAN PALG); vbar date/ response=shares nooutline; vbar date/ y2axis response=open nooutline seglabel seglabelattrs=(size=6pt color=red) ; xaxis fitpolicy=thin display=(nolabel) valueattrs=(size=6 color=black); yaxis grid display=(nolabel) valueattrs=(size=6 color=black); keylegend / location=outside position=bottom noborder valueattrs=(size=6) autooutline; format date monyy. open 5.2; run; Of course you have to make them transparent or increase the max of your y2axis to display both charts.

rudfaden · ‎03-21-2019

Put up a minimal working example of your code.

rudfaden · ‎02-28-2019

Please post a minimal working example

rudfaden · ‎01-16-2019

Not really sure what you are trying to archive. But you might look into using a proper sql join or limit your number of variables. I also think the spedis function is a little heavy run.

rudfaden · ‎01-15-2019

First of all, you should import your date as a date. Else the date function year will not work. infile datalines dsd truncover; input company_id:BEST12. ticker:$4. COMNAM:$25. start:date10. end:date10.; format company_id BEST12. start datetime9. end datetime9.; Second, there is a lot of syntax errors in your sql statement. This works proc sql; create table want as select a.*,b.* from have1 as a, have2 as b where (a.year>=year(b.start)) and (a.year<=year(b.end)) group by a.CNAME having spedis(a.CNAME,b.COMNAM)=min(spedis(a.CNAME,b.COMNAM)); quit;

rudfaden · ‎01-15-2019

ANYDTDTM also works with datetime values with day first

Online Status	Offline
Date Last Visited	2 weeks ago

Re: How do i aggregate and count a variable where X < 2 correctly?

Re: Troubleshooting a Macro Error: Resolving 'No Matching DO/SELECT St...

Re: SAS DI Version Control Archiving Error

Re: single quote working similar to double quotes in dsd option

Re: populating previous date not working

Re: populating previous date not working

Re: Having trouble with conditional color formatting using Proc Report

Re: Compare dates and check if an event occurs within "n" days

Re: automating downloading and unzipping a file

Re: Drop down Y/N (data validation list) in Excel using PROC REPORT an...

SAS Packages Framework, version 20240927

Re: automating downloading and unzipping a file

Using SAS macrovars in LUA

Re: .SAS file with text and pwencode

SAS Packages Framework, version 20231210

Re: %let macro variable using in proc sql

Re: How do i aggregate and count a variable where X < 2 correctly?

Re: populating previous date not working

Re: populating previous date not working

Re: Compare dates and check if an event occurs within "n" days

Re: How to share SAS data set with custom formats?

Re: proc ttest

Re: Create Variables with Do Loop

Re: Create Variables with Do Loop

Re: Create Variables with Do Loop

Re: Create Variables with Do Loop

Re: Convert text variable into numeric after traspose

Re: Deleting an Excel sheet with SAS on a unix server

Deleting an Excel sheet with SAS on a unix server

Re: Stacked vbar seglabel value not displayed when value too small

Re: BABE Analysis

Re: CALCULATIONS IN SAS

Re: Matching companies by names (also fuzzy matching or Perl matching)

Re: Matching companies by names (also fuzzy matching or Perl matching)

Re: Import csv file with datetime variable

SAS Community Nordic

SAS Innovate 2026

SAS Analytics Explorers