NickK Tracker

Re: Filter on N digits

NickK — Fri, 26 Mar 2021 16:25:46 GMT

There's no leading 0s or blanks in this case.

Re: Filter on N digits

NickK — Fri, 26 Mar 2021 14:40:45 GMT

So now the question is if the variable is character, how do I filter on that?

Filter on N digits

NickK — Fri, 26 Mar 2021 14:24:37 GMT

Hello,

I have a numeric variable that is 6 numbers in length. I'd like to use SQL to only keep the numbers that are 3 digits long. So, for example, I would keep 123 but not 1234 or 12345 or 123456.

Thanks.

Re: Code to identify platform

NickK — Fri, 26 Mar 2021 14:05:11 GMT

Some users prefer to use EG, some base SAS. I have a script that send program info to an SQL database. The code works in EG but not in Base SAS

Code to identify platform

NickK — Wed, 13 Jan 2021 16:31:10 GMT

Is there code that SAS can use to identify whether it's being run on SAS EG or Base SAS.

Basically, I want to create an condition that says if the user is using Base SAS then run "Code A'. If the user is running SAS EG then run "Code B"

Thanks in advance.

Re: Extracting and converting dates in strings to new date string

NickK — Mon, 20 Jan 2020 17:50:39 GMT

Thanks. Works perfectly.

Extracting and converting dates in strings to new date string

NickK — Mon, 20 Jan 2020 16:39:46 GMT

I have some code which works to extract the Last Modified date from an excel file:

data last_mod_date;

rc = filename("onefile","F:\test.xlsx");

fid=fopen("onefile"); /*fid is the file-id*/

Mod_Date=finfo(fid,'Last Modified');

rc = fclose(fid);

rc = filename("onefile");

run;

The data is stored as at 200 character length as the following

January 14, 2020 12:25:02

Now I want to take the above and convert it to the following string

YYYYMMDD_HHMM

I've tried several difference methods to try and extract the month/day/year/hours/minutes individually but none of them seem to work. Any ideas?

Note; I need this to work for any string date I extract (dates will be after January 1, 2020 if that helps)

Thanks