About Shmuel

Shmuel · ‎09-01-2016

The program will sellect all the lines that contain the strings you scaned for. Better try it and see the results. Addapt to the strings you are interested in. Again - be aware of case: write the strings exactly as they apear in the log.

Shmuel · ‎09-01-2016

OOPS, sorry; I have missed the %end for the %do

Shmuel · ‎09-01-2016

Correct.

Shmuel · ‎09-01-2016

log is a text file, so you can write a small SAS program to read it and look for some strings, like: data my_log; infile "&out_dir\saslog.log" truncover; input a_line $200.; if index(a_line, 'ERROR:') > 0 or index(a_line, 'WARNING') > 0 then output; run; Depending on your system beaware of upcase/lowcase while defining strings to look for.

Shmuel · ‎09-01-2016

Here is your code addapted to your query: %macro lib(lib); %let program=\\ipt202wp.iplocal.dk\f-drev\; %let lib = %sysfunc(lowcase(&lib)); %do; libname &lib "&program.\&lib"; %mend; I have droped the %if statement, but if you want to check validity of values then change to: %macro lib(lib); %let program=\\ipt202wp.iplocal.dk\f-drev\; %let lib = %sysfunc(lowcase(&lib)); %if &lib = wfstat %or &lib = adhoc %or .... %then %do; libname &lib "&program.\&lib"; %else %put ... /* your message for invalid refference */ %mend;

Shmuel · ‎09-01-2016

On windows server you may leave the spelling as is, but from the estatic point of view and for educational point of view I suggest do either UPCASE or lowcase - according to your prefference.

Shmuel · ‎09-01-2016

few more points: when using macro variable there is no need to enter the string between apostrophs: %let lib = ABCD is right %let lib='ABCD' may cause truble libname &lib "&program/&lib"; may work fine with double quotes libname &lib '&program/&lib'; will not work

Shmuel · ‎09-01-2016

What OS do you use - Windows or Unix/Linux or other ? As mutch as I know, Windows is not sensitive to case of letters, but Unix and Linux are sensitive and you must replace the user's spellinhg to the right spelling as it is written on the HD.

Shmuel · ‎09-01-2016

Do you want to calculate the F_DATE L_DATE per each loan ? or per the whole file ? As mutch as I understand your input contains many loans. I suggest to run the two versions: 1) using BY sttaemant as I wrote: BY loan_number source_date_dte StatusNo NOTSORTED; 2) using BY StatusNo notsorted only Compare the two outputs and define what fits your expectations better.

Shmuel · ‎08-31-2016

I assume the dataset is sorted by: lOAN_NUMBAER and SOURCE_DATE_DTE inside the loan. Here is your code with small changes emphasized by underline: Data A_2300405201_GRP; set A_2300405201; by loan_number source_date_dte StatusNo NOTSORTED; retain F_Stat_Day; If first.StatusNo then Do F_Stat_Day=Source_Date_dte; /*Output; */ end; If last.StatusNo then Do L_Stat_Day=Source_Date_dte; Output; end; format F_Stat_Day mmddyy8. L_Stat_Day mmddyy8.; run; NOTES: 1) I havn't run the code. 2) Did you changed F_stat_day to F_Day ? L_Stat_day to L_Day ? or did you added labels to display on output ? (Your result doesn't fit your code variable names).

Shmuel · ‎08-31-2016

Can you upload the input dataset with two loans, displaying variable names and the order of the observations.

Shmuel · ‎08-31-2016

You wrote that the actual program is more complex, so in order to be able to help you more I need the whole log. May be the missing values of accountkey derive from a previous step.

Shmuel · ‎08-31-2016

It doesn't make sense to me. Using SQL the JOIN (merge) is cartesian. It means that ACCOUNTKEY with missing value got this value from the origin table. Which table contains the accountkey variable ? is this variable on both tables ? are you sure there are no observations with accountkey missing ? is accountkey numeric or characte defined ? if character then filter it by - accountkey ne ' '

Shmuel · ‎08-31-2016

To filter records where accountkey is missing is easy, but I need to know which table holds this variable. Let's say its origin is the B table, then the full code will be: proc sql; create table Payments as select a.*, b.* from work.DateKey(where=(date>'28Aug2016'd)) as A left join DWH.vwFactSalaryTransactions(where=(account_key ne .)) as B on (a.Datekey = b.Datekey) ; quit; if accountkey is in the lookup table (A) then: proc sql; create table Payments as select a.*, b.* from work.DateKey(where=(date>'28Aug2016'd and account_key ne .)) as A left join DWH.vwFactSalaryTransactions as B on (a.Datekey = b.Datekey) ; quit;

Shmuel · ‎08-31-2016

I understand that the key variable on both tables is DateKey. The error you got tells that Date_key could not be found in work.DateKey (A). Delte the hyphen . After running without syntax errors, if you still get observations with date =< '28Aug2016'd then please attach lines from output that you have not expected and the fuul log of your run.

Online Status	Offline
Date Last Visited	‎07-31-2024 01:23 PM

Re: PUTN error. What's the problem with the conversion to 6 characters...

Re: Explanation for calling a macro program in another macro program i...

Re: How to read and import files which sits under multiples folder

Re: SAS options management

Re: Concatenate

Re: Rename Columns Without Knowing The Order & When The Naming Convent...

Re: Rename Columns Without Knowing The Order & When The Naming Convent...

Re: How to use the latest wave's non-missing value to fill missing val...

Re: Multiple PROCs to Single Proc

Re: Multiple PROCs to Single Proc

Re: Macros

Re: "DO OVER" is Undocumented for SAS 9.4, Right?

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: convert numeric date to another format

Re: Conditionally move the files based on macro variable

Re: Turn Off the SAS Log - How we can do ?

Re: Removing embedded carriage returns

Re: Extract first and last name from character variable

Re: printing result as pdf, al tables same page

Re: ERROR: The SAS System stopped processing this step because of insu...

Re: Extract Errors and Warnings from log

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Extract Errors and Warnings from log

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Allocation of libery - %lib(libery name) - get is working with how...

Re: Find First and Last Dates in a dataset with repeating groups

Re: Find First and Last Dates in a dataset with repeating groups

Re: Find First and Last Dates in a dataset with repeating groups

Re: Using a date lookup table with a condition when the date is format...

Re: Using a date lookup table with a condition when the date is format...

Re: Using a date lookup table with a condition when the date is format...

Re: Using a date lookup table with a condition when the date is format...

SAS Users Group in Israel