About Satish_Parida

strqimr · ‎03-07-2018

Many Thanks

andreas_lds · ‎03-07-2018

Maybe my eyes need to checked by a doc, but i can't see anything about having 600 vars in your starting post. Using an array with a simple loop seems to be appropriate. Untested fragment: data work.want; set have; by account; array vars fico beacon dpd ...; array diffs fico_diff beacon_diff dpd_diff ...; do i = 1 to dim(vars); diffs[i] = lag(vars[i]); if first.account then do; diffs[i] = 0; end; end; run;

ballardw · ‎03-05-2018

If your macro %find involves any procedures or calls a data step such as data _null_; <any other code> run; Then the data step "calling" find will quit as soon as it finds proc or data statement as that is a boundary. Example: data junk; x=3; proc print data=sashelp.class; run; the "proc print" tells SAS that the data step Junk is finished.

fri0 · ‎03-05-2018

It totally works! Thanks you very much!

visa · ‎03-05-2018

@SASJedi Using a bash command to trigger the ksh shell worked, also with the use of X command. I wrote something along the lines of call system ( X 'bash sample.ksh'); and it worked! 🙂 I am sure the below solution you have posted would also have worked! Thank you again, you have been a great help!

Kurt_Bremser · ‎03-05-2018

How should we validate this code without having the dataset map_num? Please post example data in a data step, eg by using the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 @Geo- wrote: hi,using code below will not return char type value,how to fix? %put %sysnc(scan(&numVarList.,1)); exact case,this will work: proc sql; create table tableA as select columnA into:valueA separated by ' ' from Map_num where variable='age'; and this couldn't work,the error shows could not find column age create table tableA as select columnA into:valueA separated by ' ' from Map_num where variable=%sysnc(scan(&numVarList.,1)); why and how to fix it?

Satish_Parida · ‎03-04-2018

/*This works*/ data have_gold; input Patient_ID:best12. Date1:mmddyy8. Date2:mmddyy8.; format date1 date2 date9.; datalines; 24 12/02/15 12/23/15 25 12/02/15 12/23/15 26 12/03/15 12/24/15 ; run; data have_log; input Patient_ID:best12. Date_of_Visit:mmddyy8. Form1:$10. Form2:$10. Form3:$10.; format Date_of_Visit date9.; datalines; 24 12/02/15 Yes No Yes 24 12/23/15 Yes Yes Yes 25 12/02/15 Yes No Yes 26 12/24/15 No Yes No ; run; proc transpose data=have_gold out=have_gold_trans(drop=_name_ rename=(col1=Date_of_Visit)); by Patient_ID; run; proc sort data=have_gold_trans; by Patient_ID Date_of_Visit; run; proc sort data=have_log; by Patient_ID Date_of_Visit; run; data want(drop=Form:); merge have_gold_trans(in=a) have_log(in=b); by Patient_ID Date_of_Visit; if a and not b then output; run;

kiranv_ · ‎03-03-2018

answer is important but asking question is even more important. it makes you successful. if you want to be successful it is very very important to ask question correctly and in effective manner, where in no one have to guess. Most of work in field depends on how to ask proper questions in business or in any other field

Kurt_Bremser · ‎03-02-2018

"does not work" is a VERY POOR description of your problem. Supply the log, and give a clear description how the result you got does not meet your expectations. Don't force us to pry important information out of your nose.

89974114 · ‎03-02-2018

This code is a lot better looking than the solution I managed to come out with: %macro BinData; %do i = 1 %to 8; Data Bin&i; set Import; If _N_ = &i; run; %end; %mend; %bindata(); Thank you for your code, I'll be using this to complete my project, looks great.

Satish_Parida · ‎03-02-2018

Something from Banking Domain: 1. Policy are renewed all the time, and in database we create a new record with a new start date for the renewed policy number. 2. IN Database we see Policy as Service, so we usually have a service serno assigned to each record which is usually the Primary key. 3. If you do not know the Primary key then you can certainly use Policy number, Start date/End Date and policy type together for an accurate result.

ChrisNZ · ‎02-28-2018

@Reeza Should we ask for proc setinit ?

s_lassen · ‎02-28-2018

Basically, it will select all rows where the begin-date is before or on the 31st of January 2017, and the end date is on that date or after. If you are doing standard SQL, that is (in SAS, that happens if you write Pass-through SQL calls, or if the where clause is passed directly to an external DBMS). But, if you are doing SAS SQL, it can also be the opposite, if the begin date is larger than the end date. Including if the end date is missing, and the begin date is after the date in question. SAS has a problem with missing values in where clauses, and with the between condition.

Aleixo · ‎02-28-2018

Thank you all answers people. I try with that task but the table is repeated 2 times. The columns are repeated(2x) with Date, and the goal is one time only. I will continue try to understand where is the problem. Regards, Aleixo

Kurt_Bremser · ‎02-28-2018

For clarity's sake, I'd write it a little differently: data test1 ( drop=_PastDueSince ); set Past_Due_Actual_Days2 ( rename=(PastDueSince=_PastDueSince) ); format PastDueSince date9.; PastDueSince = input(trim(_PastDueSince),date9.); run; This makes it more readable with regards to what is converted to what.

Online Status	Offline
Date Last Visited	‎04-17-2023 07:51 AM

Re: Reading CSV file with double quotes, line breaks and spaces

Re: Reading a csv file with records length more than 33,000

Re: Case when multiple conditions to create aggregated value

Re: Case when multiple conditions to create aggregated value

Reading a csv file with records length more than 33,000

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Control the Log and Listing Location from Batch Call in SAS Grid Serve...

Re: Using in-format (??) in proc fcmp

Re: Using in-format (??) in proc fcmp

Re: Control the Log and Listing Location from Batch Call in SAS Grid S...

Re: Replace null with value by looking back and ahead a certain number...

Re: break field with -

Re: SAS Programming

Re: Removing postfix (e.g Inc, Limited) in corporate names

Re: Deleting rows with condition

Re: XML LIBNAME reading data from URL

Re: SAS:how to use index to pick out macro array variable

Re: Case when multiple conditions to create aggregated value

Re: break field with -

Re: Deleting rows with condition

Re: calculate difference between two lists of variables

Re: call a macro through datatep

Re: Macro doesn't read the conditional

Re: Schedule a sas program to trigger a shell script

Re: SAS:how to use index to pick out macro array variable

Re: Merging & comparing datasets

Re: Keep only most recent records

Re: create a substract ing variables

Re: Repetitively executing a Maco

Re: How to find the Mismatched records?

Re: PC Ram usage cap at 7.8 Gig

Re: Where clause understanding

Re: How to add duplicates in a new column

Re: Base sas