cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
smantha
‎08-19-2022
  • 246 Posts
  • 22 Likes Given
  • 37 Solutions
  • 76 Likes Received

Re: find a probable substring within a string using lookup value

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 01:20 PM
‎06-04-2020 01:20 PM
There are two aspects to this  1. how do you find similarity of two strings (spedis, soundex functions etc. are some viable options ). Prx (perl regular expressions ) but they do not do a fuzzy match and very memory intensive. 2. Get to the final layout.            a. use a hash table and iterate over all the elements you want to find.           b. create a cartesian join and then do a transpose ... View more

Re: Shortcut for variable names

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 01:03 PM
‎06-04-2020 01:03 PM
%macro repeat (max=) ; %do i = 1 %to &max ; pay_0&i= round(sum(gross_0&i,pension_0&i, nic_0&i,0) , 0.01) ; %end ; %mend repeat ; %repeat (max=6) ; ... View more

Re: Shortcut for variable names

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 01:01 PM
‎06-04-2020 01:01 PM
did you try using the sum function ... View more

Re: Convert elapsed time character to minutes

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 12:59 PM
1 Like
‎06-04-2020 12:59 PM
1 Like
data have; input claim_id $ time ; if time > 60 then do; time=(int(time/100)*60)+mod(time,100) end; cards; 3 9 2 14 98 349 99 1459 ; run; ... View more

Re: Convert elapsed time character to minutes

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 12:58 PM
‎06-04-2020 12:58 PM
data have; input claim_id $ time ; if time >60 then do; time=int(time/100)+mod(time,100); end; cards; 3 9 2 14 98 349 99 1459 ; run; ... View more

Re: How to convert SAS Code to SQL ?

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 12:51 PM
‎06-04-2020 12:51 PM
Some SQL languages support lag and (may be dif) but I haven't seen a construct where first. and last. exist. Things that come close to this behavior is using a windowing function and creating a non tied rank. Us teh rank so obtained in the processing ... View more

Re: SAS date and time constraints by group

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 12:45 PM
‎06-04-2020 12:45 PM
are your fields numeric or character. If the fields are numeric you can use missing(<fieldname>) instead of <fieldname>='.'. ... View more

Re: Replace more than one space with ^n

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 11:20 AM
‎06-04-2020 11:20 AM
What happened to plain old cmpbl (compressible function). ... View more

Re: Assigning Page Numbers Based on Occurrences Regrouping

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2020 10:24 AM
‎06-04-2020 10:24 AM
My bad the last. should be last.track_number   proc sort data=input_data; by OrderNumber SetNumber TrackNumber;   data output_data; set input_data; by OrderNumber SetNumber TrackNumber; retain counter ; if first.OrderNumber then counter=10; if last.TrackNumber then counter=counter-1; PageNumber=2; if counter  > 0 then PageNumber=1; run; ... View more

Re: Assigning Page Numbers Based on Occurrences Regrouping

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 05:11 PM
‎06-03-2020 05:11 PM
OrderNumber SetNumber TrackNumber  SubGNumber   proc sort data=input_data; by OrderNumber SetNumber TrackNumber;   data output_data; set input_data; by OrderNumber SetNumber TrackNumber; retain counter ; if first.OrderNumber then counter=10; if last.OrderNumber then counter=counter-1; PageNumber=2; if counter  > 0 then PageNumber=1; run;   ... View more

Re: Transpose_count diagnosis

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 05:10 PM
‎06-03-2020 05:10 PM
Thank you but I am biased against proc transpose. However I agree that is a simple solution. ... View more

Re: Sas connection to oracle

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 03:56 PM
‎06-03-2020 03:56 PM
To add on to dave prinsloo's response. you need to have a SAS/Access for Oracle or SAS/Access to ODBC. For SAS/Access to ODBC you need to setup other than the module itself you need to setup configuration on your system. ... View more

Re: Transpose_count diagnosis

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 01:24 PM
1 Like
‎06-03-2020 01:24 PM
1 Like
proc sql; select count(distinct DiagCode) into: ndiagcode from Data_Have; quit; proc sort data_have; by ind_ID; run; data DataWant(Drop=DiagCode); length DCode1 -- Dcode&ndiagcode. $8.; Set Data_Have; by ind_ID; array s{} DCode1 -- Dcode&ndiagcode.; retain DCode1 -- Dcode&ndiagcode. '' Num_diag 0; if first.ind_ID then do; Num_diag=0; end; Num_diag=Num_diag+1; s{Num_diag} = DiagCode; if last.ind_ID then output; run; ... View more

Re: How to get all macro parameters from a macro(You don’t know which ...

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 12:23 PM
‎06-03-2020 12:23 PM
sashelp. is a good resource for anything SAS metadata related such as names of tables in a library, columns in the respective tables, macros, parameters etc. Refer to this article https://www.lexjansen.com/nesug/nesug06/po/po06.pdf Besides using symbolgen ... View more

Re: How to merge two datasets by two variables

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2020 12:10 PM
‎06-03-2020 12:10 PM
proc sort data=work.Data1; by ICBSUC Jahr; run;   proc summary data=Data1 nway;     class  icbsuc Jahr;     var KehrwertM;     output out=sum1 sum=sum1 n=n; run;   data Data2;     merge Data1 sum1 (in =in2);     by icbsuc Jahr;     if in2; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-19-2022 12:25 PM
Group Hubs for smantha
View All
Likes given to
Likes from
Quick links