About filippo_kow

filippo_kow · ‎08-06-2025

Hi again, I'd really appreciate any tips or advice anyone can share 🙂 Thanks, Filip

filippo_kow · ‎08-04-2025

Hi everyone, I have an issue. I’m running SAS 9.4 on a Windows Server, and I’d like to integrate it with Airflow, which is running on a Linux machine. The current setup is very simple: I'm using the Windows Task Scheduler to trigger SAS programs locally on the Windows Server. As you can see, the architecture is quite basic. Now, I’d like to replace Windows Scheduler with Airflow. Here's the idea: Airflow runs on a Linux machine. I want to schedule a sample DAG that sends the appropriate command to the Windows Server (something like sasbatch.sh -sisin ... -log ... , etc.). The Windows Server should then execute that command using SAS. I’ve previously worked with a similar setup where both Airflow and SAS were on separate Linux servers, using the SSHOperator . However, in this case, SAS is installed on a Windows Server, and I’m not sure what’s the best way to approach this. Has anyone dealt with a similar configuration? If so, I’d really appreciate any advice or examples on how to set this up. Thanks in advance, Filip

filippo_kow · ‎01-14-2025

Hi guys, Thanks a lot for you answers, it helped me a lot 🙂 Best, Filip

filippo_kow · ‎01-13-2025

Hi guys, I have a quite trivial problem. I have a number which can have one decimal point and I want to "trunc it down" by 0.5 step. It means: if I have 2.2 I want 2. If I have 2.4 I want 2. If I have 2.6 I want 2.5, like shown in the following code: data numbers; input have $3. want $5.; datalines; 2.2 2 2.6 2.5 2.9 2.5 3.1 3 ; run; Can anyone help me please? 🙂 Thanks in advance! Filip

filippo_kow · ‎10-21-2024

Hi all, Thanks a lot for your support! It works perfectly 🙂 Just one remark, maybe it will be somehow useful for other people. When run the stored process from SAS Add-In (not using ods excel) we need to use proc report (instead from proc print). Thanks again! Filip

filippo_kow · ‎10-16-2024

Hi @Cynthia_sas , Thanks for your reply. In general I need to fill excel file based on data from SAS. What I am doing is: 1. I have created a stored process that selects data from SAS. In that stored process I am gathering all the data and finally I am running the following proc sql: proc sql; select * from my_data; quit; 2. Then, in the excel file I am running the process from SAS add-in. In the 'results' pane of add-in I see data from my last query (select * from my_data). 3. I am inserting resulting data into new excel sheet 4. Based on those results I need to fill form that is in another sheet. 5. Here comes my question: sometimes it might happen that for one observation I can have multiple values (in one row), eg.: 6. In my final form I want to show those orders one above another: 7. Originally I thought I can create formula for excel in SAS ( ="Order_123"&char(10)&"Order_456"&char(10)&"Order_789") and when inserting it into excel it will be properly handled. Unfortunately, excel claims that there is an error in the formula. So what I am trying to do now is to add line breaks after each "order" so that in the final form all orders will be one above another (in the same cell). I hope it is more clear now 🙂 Thanks, Filip

filippo_kow · ‎10-16-2024

Hi guys, Before I ask the question let me paste the code: %let string = "This is line 1 <line_break> This is line 2 <line_break> This is line 3"; data test; var=&string.; run; proc sql; select * from test; quit; I want to have a dataset with only one observation, but in the final ODS I want to show one line above another. I need this because later on I am using stored process to fill data in the excel file, so I want to fill the data in the following way: Btw. I was also trying to prepare the formula for excel in SAS: but for some reason excel doedn't want to parse it properly (I have "#name?" error after applying somethink like this: sheet_1.Cells(16, 5).Value = my_data.Cells(2, 30) (what's interesting it is working when I press F2 and Enter on the cell) ). Thanks in advance for any help! Filip

filippo_kow · ‎10-14-2024

Hi all, Thanks a lot for your replies, that works perfectly! 🙂 Best, Filip

filippo_kow · ‎10-14-2024

Hi guys, I have a quite simple problem, but I don't have a clue how can I solve it. I have a macrovariable that contains quotes and ampersand (I need it for the excel file). Take a look at this code: %macro x; /* ... */ %let string = "This is sample string" & char(10) & "This is second line of sample string"; %put &=string; data x; a=&string; run; %mend; %x; But the problem is that I don't know how can I add such a string into data set (data x in my sample code). Does anyone have any idea? Thanks! Filip

filippo_kow · ‎03-16-2024

Hi guys, I am a little bit confused with usage of one of the option in Table Loader transformation. In Options->Additional Loader Options there is an option to select load time column. In jobs that I am currently changing there is already one column selected. However, I would like to leave it empty (I am appending data from old environment to the new one and I would like not to overwrite this column). And here comes my question. For some jobs, I can simply press 'Reset' button and this column is empty, but for some other jobs after pressing 'Reset' nothing happens (this column is still filled). As I see, the Table Loader looks the same for all jobs (I mean the same options, load techniques and so on). Does anyone have an idea what should I do to leave this option empty? Thanks in advance! Filip

filippo_kow · ‎07-19-2023

Hi again @Quentin , Of course, I fully understand 🙂 I really appreciate your help, it was really nice to investigate the problem with MATADATA_GETNOBJ(). Thanks again & have a nice rest of the day! 🙂

filippo_kow · ‎07-19-2023

Thanks a lot @Quentin for your reply, You are right - when I added this line and try to run the code from 'admin' account I have an error: ERROR: metadata_getnobj returned an unhandled value nobj=-4 And when I use my own user I have some records returned (unfortunately not all of them). Well, I am just wondering why my personal user can read only some metadata (only few persons) and not all of them... Maybe you have some idea?

filippo_kow · ‎07-19-2023

Hi @Quentin , I just noticed one more thing. I am connecting to metadata using the following options: options metaserver="<server>" metaport=8561 metauser="<user>" metapass="<password>" metarepository="Foundation"; Previously I was using user with full privileges, but when I changed the user to different, I can see some records - but unfortunately not all that are in metadata. Do you think it might be connected to some privileges or so? Also, as I mentioned at the beginning I am running the same code with the same options of different servers and I have problem only with one of them.

filippo_kow · ‎07-19-2023

Hi @Quentin , I did what you asked for and here are the results: 1. There is no "No persons available" note in the log file 2. I added this grpassn handling but there are no errors, so it looks that values -3,-4 and grater than 0 are correct. So my understanding is that the code finds metadata objects, but for some reasons it is not fetching it. In the log file I have only note that there are no observations. NOTE: The data set WORK.GROUPMEMPERSONS_INF has 0 observations and 13 variables. I know it is very hard to investigate, but maybe you have any other hints? Do you think it might be related to server configuration/encoding? Thanks, Filip

filippo_kow · ‎07-18-2023

Hi, Thanks for the info. I will check it, but one more thing - the code was working some time ago on this machine. I think admins changed something in the configuration and after that it doesn't work properly. So I am assuming it is related to some configuration, but of course I will check your suggestion.

Online Status	Offline
Date Last Visited	‎08-06-2025 05:40 AM

Re: SAS 9.4 (on Windows) with Airflow integration

SAS 9.4 (on Windows) with Airflow integration

Re: Trunc by 0.5

Trunc by 0.5

Re: Line break in ods

Re: Line break in ods

Line break in ods

Re: How to insert macrovariable with quotes into data set

How to insert macrovariable with quotes into data set

SAS DI - "Load Time" column in Table Loader

Re: Export the whole report/page into one excel/pdf file

Re: Delete 'Clear filter' and default value of parameter in drop-down ...

Re: Export the whole report/page into one excel/pdf file

Re: Delete 'Clear filter' and default value of parameter in drop-down ...

Re: Delete 'Clear filter' and default value of parameter in drop-down ...

Re: Delete 'Clear filter' and default value of parameter in drop-down ...

Re: SAS 9.4 (on Windows) with Airflow integration

SAS 9.4 (on Windows) with Airflow integration

Re: Trunc by 0.5

Trunc by 0.5

Re: Line break in ods

Re: Line break in ods

Line break in ods

Re: How to insert macrovariable with quotes into data set

How to insert macrovariable with quotes into data set

SAS DI - "Load Time" column in Table Loader

Re: Retrieving metadata objects gives no values

Re: Retrieving metadata objects gives no values

Re: Retrieving metadata objects gives no values

Re: Retrieving metadata objects gives no values

Re: Retrieving metadata objects gives no values