podarum Tracker

Re: How to find a string within anther string for different scenarios

podarum — Wed, 11 Feb 2026 19:53:02 GMT

Thank you

How to find a string within anther string for different scenarios

podarum — Wed, 11 Feb 2026 15:01:40 GMT

I have many fields that are like in this example here address = 'Lot B Plan 1234' however, I need to check if this matches the same field where it would be incased in address = 'PID 004-411-439 Lot B Plan 1234'.. but the problem is there are many scenarios like this so could be 1000s. So same field name but if 1 entry is encased in another entry then it would trigger a match, else no match.. could be 10000's rows and 1000s different scenarios. Is this dooable ?

Keep only part of a symput address path stationary

podarum — Thu, 18 May 2023 14:40:25 GMT

I have a daily symput address path that I get from another team, the only changes to this path is the current day. For example the name of this path is ABC_202305150700 and the next day it's ABC_202305160700, and so on every day - so I can hardcode the input path as ABC_TODAYSDATE0700. However, the team that sends this file sometimes randomly changes the name to ABC_TODAYSDATE0701, and they don't know why this is happening. Is there a way I can read this file and omit the last 4 digits of the path.. so if the name randomly changes it doesn't affect my input path address name? Thank you

Update and read excel data with drop-down column in Excel

podarum — Mon, 07 Nov 2022 21:42:31 GMT

Hi,

I'm tasked with updating an Excel file every week with data I get from SAS however the Excel file has a column with a drop-down box, then a manager does his manual Excel updates and then I read that file in SAS again. Is there a way that SAS can read and write data that is stored in Excel with a drop-down box? Say I have an excel file with 5 columns and 10 rows.. one of the column is a drop-down. I update the 10 rows with info from SAS including some info in the Drop-down column and the my manager makes some additions and some changes, and I want to read that newly created Excel into SAS and then make my change sin Excel including the filed data in the drop-down as it may change with info from SAS. And then the process starts all over again.. week after week..

Thanks in advance

Re: Group data into specific days of the week

podarum — Thu, 31 Mar 2022 12:57:04 GMT

Thank you , this is great

Group data into specific days of the week

podarum — Sun, 27 Mar 2022 12:06:16 GMT

Hi, I have data with a date (closing_date) spanning out to 120 days.. I'm trying to group them by different Thursday to Wednesday groupings and name them like "March-10-22 - March-16-22'... and show about 17 groupings each one with a Thr-Wed title..

Thanks

Finding if scheduled SAS job ran successfully in Virtual Machine

podarum — Thu, 27 Jan 2022 21:11:02 GMT

Hi, I am running a scheduled SAS job each day in the VDI (Virtual Desktop) and I would like to know if there is a creative way to notify me (either though email or other) if the daily job ran successful or not.. If there is success then I leave it as is, if it's not then I have to go in and manually re-run it. Perhaps a way that notifies me if there are more then 6 error messages (6 is normal as there is a connection error I always get) then send a notification? Thanks in advance.

See the number of rows created and if successful pull

podarum — Fri, 26 Nov 2021 20:49:17 GMT

I am not able to see the lines below (In the Log) after I do a SAS pull... How can I? Thanks

Re: importing an xlsm file (Windows 10)

podarum — Mon, 05 Apr 2021 12:37:06 GMT

The fix happened to be a combination between Windows bit size, Office bit size and SAS installed bit size... they all had to be a 64 bit. Once that was fixed, it worked. Thanks everyone.

importing an xlsm file (Windows 10)

podarum — Thu, 01 Apr 2021 02:29:35 GMT

Hi, I'm trying to import an xlsm file into SAS and am operating on a Windows 10 machine. For some reason it's not working. Any suggestion are greatly appreciated. Thanks

proc transpose with duplicate values

podarum — Sat, 16 Jan 2021 19:40:54 GMT

Hi, I'm trying to get the proc transpose with a duplicate value ... wanting it to show in the columns.. Here's what I mean:

HAVE;

Acct ID Type

234 123 BOR

245 122 BOR

245 124 COB

245 125 COB

245 126 POA

246 128 BOR

246 127 POA

WANT

Acct BOR COB1 COB2 POA

234 123

245 122 124 125 126

246 128 127

Thanks

Re: Select data with only 4 decimals

podarum — Mon, 05 Oct 2020 17:10:02 GMT

Thanks everyone, the answers are great

Select data with only 4 decimals

podarum — Mon, 05 Oct 2020 15:58:03 GMT

Hi, I have a dataset that is interest rate, most of the data is in a 2 decimal format (eg. 2.45), but some rows have a 4 decimals (eg. 2.4678) format. How do I chose the data that has only the 4 decimals? Thanks

Re: Make row values into column

podarum — Fri, 14 Feb 2020 21:10:13 GMT

You Rock.. Thank You !!!

Make row values into column

podarum — Fri, 14 Feb 2020 20:40:11 GMT

Hi, I have a list of accounts and their customer Ids, some accounts can have more than 1 customer and different customer types. I would like to transpose by type of customer. Here's what I mean:

HAVE

Acct Type_A Type_B Type_C

001 123 234

001 123 356

002 567 124 345

002 567 124 678

WANT

Acct Type_A Type_B1 Type_B2 Type_C1 Type_C2

001 123 234 356

002 567 124 345 678

This logic applied to a list of 1 million accouts.

thanks

Re: Importing cuts-off field length

podarum — Fri, 07 Feb 2020 19:19:48 GMT

Good idea, however I can't due to very sensitive personal information.. Is there a different way? Can I specify the length in the proc import for that specific field?

Importing cuts-off field length

podarum — Fri, 07 Feb 2020 19:08:47 GMT

Hi, when I proc import a raw .txt file, a specific field (name of customer) cuts off at a certain length, other fields remain in their lengths, some longer.. No idea why. Please help !!

Here's my proc import code:

proc import out = raw datafile = "S:\Banking\MIS\Reports\Report_&rpt_dt..txt"

dbms = dlm replace;

delimiter = '09'x;

run;

Re: Select earliest record by field change

podarum — Thu, 29 Aug 2019 14:53:55 GMT

Thanks everyone for the awesome responses.

Select earliest record by field change

podarum — Wed, 28 Aug 2019 20:53:33 GMT

I have a list of records by account and looking to only capture data (earliest) when there is an interest rate change.

HAVE

Acct Date Rate

123 Jan1 2.3

123 Jan2 2.3

123 Jan3 3.4

123 Jan4 3.4

123 Jan5 3.4

123 Jan6 5

345 Jan1 1.2

345 Jan2 1.2

345 Jan3 2

345 Jan4 2.4

345 Jan5 2.4

345 Jan6 3

345 Jan7 3

and so on for many accts...

WANT (only rate changes - including the first one)