About sss

sss · ‎01-12-2024

Appreciate your help

sss · ‎01-12-2024

Any suggestion mates 🙂

sss · ‎11-15-2023

HI Harry, I appreciate your help, your code works great however my requirement is different from your output. Let me try to simplify it. from the first 1st row, i highlighted the values i'm looking for. FOr ex: if the input data is ffreg45646 %345^$45e 0005353532342 ertehf%43432- 435-- erte0034344 the expected output is 45646 ; 43432; 34344 in this case the delimiter is space from the first delimited value ffreg45646 i'want to have value 45646. as it has length of 5 digits continuously. from 2nd delimited value %345^$45e it has special character in between and the length 3 char and 2 char which not a valid value for me. it should continuous 5 digits in this case it has special character in between. from 3rd delimited value 0005353532342 we need to ingore all preceeding zeros(0) and the length should be equal to 5 however it have length 10. this also doesn't meet my requirement so it should be excluded from output from 4th delimited value ertehf%43432 it has char and special char both should be trimmed and leftover numbers are equal to exactly 5 , which meets the requirement hence should be part of output for 5th delimited value 435-- erte0034344 , i would like to extract only last 5 digit because it had number less then 5 length and special char and char should be trimmed

sss · ‎11-15-2023

HI Harry, I appreciate your help, your code works great however my requirement is different from your output. Let me try to simplify it. from the first 1st row, i highlighted the values i'm looking for. For ex: if the input data is ffreg45646 %345^$45e 0005353532342 ertehf%43432- 435-- erte0034344 the expected output is 45646 ; 43432; 34344 in this case the delimiter is space from the first delimited value ffreg45646 i 'want to have value 45646. as it has length of 5 digits continuously. from 2nd delimited value %345^$45e it has special character in between and the length 3 char and 2 char which not a valid value for me. it should continuous 5 digits in this case it has special character in between. from 3rd delimited value 0005353532342 we need to ignore all preceding zeros(0) and the length should be equal to 5 however it have length 10. this also doesn't meet my requirement so it should be excluded from output from 4th delimited value ertehf%43432 it has char and special char both should be trimmed and leftover numbers are equal to exactly 5 , which meets the requirement hence should be part of output for 5th delimited value 435-- erte0034344 , i would like to extract only last 5 digit because it had number less then 5 length and specialchar and char should be trimmed

sss · ‎11-08-2023

Hi All, I'm working on a text mining project which has millions of reports. My problem statement is little weird. I have column with alph number column with all possible values. from the given data i would like to select only number which has exactly 5 digits. below are the some criteria 1. values are separated by comma,colon, semi colon, space 2. the data i want to fetch might has pre text and post text value 3. i want to select values which are highlighted in bold color 4. if the leading numbers as zero(0) and followed by digits which is 5 digit will be selected, example is given in 1st row I appreciate your help 5 digit column output ffreg45646 %345^$45e 0005353532342 ertehf%43432- 435-- erte0034344 45646;43432;34344 4235354 sfd4t5345345 erteyye 45634# ye54545 54545 00055 0545554 54454545 000000052345 52345 wer43423, 445wsfsf4535, 4344%455 43423

sss · ‎07-16-2017

Yes its works, thank you shmuel and Astounding 🙂

sss · ‎07-16-2017

HI All, I am currently working on below logic, i tried couple of tricks but didn't got desired results. I want to group 3 countinues months and assign last month values for previous 2 months including current month record . for instance: dec16,jan17 and feb17 i want to assign as feb17. Basically wants to tried as quarter(not using qtr function). i have enclosed the sample code and desired output, your help is appreciable. data have; input run_month:date9.; format run_month date9. ; datalines; 01dec2016 01jan2017 01feb2017 01mar2017 01apr2017 01may2017 01jun2017 01jul2017 01aug2017 01sep2017 01oct2017 01nov2017 01dec2017 ; run; Desired output: Months Qtr_month 1-Dec-16 1-Feb-17 1-Jan-17 1-Feb-17 1-Feb-17 1-Feb-17 1-Mar-17 1-May-17 1-Apr-17 1-May-17 1-May-17 1-May-17 1-Jun-17 1-Aug-17 1-Jul-17 1-Aug-17 1-Aug-17 1-Aug-17 1-Sep-17 1-Nov-17 1-Oct-17 1-Nov-17 1-Nov-17 1-Nov-17 1-Dec-17 1-Feb-17

sss · ‎10-30-2015

Hi All, I have small query, I want to generate unique records from temp dataset on variable var, but the out dataset should have values in same order a c d b e. Output: ---------- a c d b e data temp; input var$; datalines; a a a c c c d b b b e e ; run;

sss · ‎09-15-2015

Hi All, Used following code to create dataset Matrix dataset. data Matrix(drop= i j); array r(5); do i=0 to 20 by 5; do j=1 to 5; r(j)=i+j; end; output; end; Below transpose code transpose the dataset as i required. but i would like to do same with dataset using do loops and arrays. proc Transpose prefix=r out=Transpose(drop=_NAME_); Below code could not give me same output as proc transpose. could you please help me to transpose dataset in datastep? data Transpose2(drop= i j r1-r5 flag); set Matrix; flag=0; array v(5); array r(5); do i=1 to 5; do j=1 to 5; _N_=j; v(j)=r(i); end; end; run; I am trying to read first column of data set Matrix and storing it as a first row in data set Transpose. I am using _N_ automatic variable to switch between rows of dataset matrix so that I can read all values of first column. Here I read 1st value of 1st column(then 2nd value of 1st column & so on), and then switching to second row by setting the value of _N_to 2 (so that SAS will jump to 2 nd row in PDV.) and reading the 3rd value of 1st column & so on….. But it’s not working. Is this right way? Please give any hint about the logic or hint related to using array in different way.

sss · ‎08-20-2015

below code will do my job. thank you all. data one; input d_time_with_bank_crs_i_fmt $50.; datalines; 1-10 ; run; data two; input X_DAY_SA12_crs_i_fmt $50.; datalines; 1-11 ; run; data three; input der_time_cross_x4_crs_i_fmt $50.; datalines; 1-12 ; run; %macro dataset_exists(lib,suffix); proc contents data=&lib.._all_ out=work.datasets(keep=libname memname name where=(upcase(name) contains '&suffix')) noprint; run; Data null_; Set datasets end=end; by memname; if first.memname then do; count+1; output; end; call symputx('dset'||left(count),memname); call symputx('old_var'||left(count),name); call symputx('new_var'||left(count),tranwrd(name,"_CRS_I_FMT",'')); if end then call symput('max',count); Run; %do i = 1 %to &max; /* TITLE Sample records for dataset – &lib..&&dset&i.;*/ proc datasets lib=&lib; modify &&dset&i.; rename &&old_var&i. = &&new_var&i.; run;quit; %end; %mend; %dataset_exists(work,_CRS_I_FMT); %put _user_;

sss · ‎08-20-2015

Hi mark, Code is to complex to modify it, it might effect other reports if i modify the code. Renaming is required for only few datasets as a standard process we will not rename the variables.i am trying to write code not getting desired output. it would be great if u share sample code.

sss · ‎08-20-2015

Hi All, My code create hundred of sas datasets, and this datasets are imported to excel. Depending up on business requirement required datasets are exported to excel file.below datasets has variable end with crs_i_fmt, I want to rename this variables and should not ends with "crs_i_fmt". some dataset many not variables which ends with crs_i_fmt in such case it should rename variables. sample input and output are shown below. table name has variables new variables dataset1 d_time_with_bank_crs_i_fmt d_time_with_bank dataset2 X_DAY_SA12_crs_i_fmt X_DAY_SA12 dataset3 der_time_cross_x4_crs_i_fmt der_time_cross_x4 dataset4 r_bal_crlim_v1_crs_i_fmt r_bal_crlim_v1 dataset5 r_tot_dep_exp_v1_crs_i_fmt r_tot_dep_exp_v1 dataset6 d_resid_status_crs_i_fmt d_resid_status dataset7 income_by_dependents_crs_i_fmt income_by_dependents dataset8 X_MTH_SA3_BANK_EX14D_crs_i_fmt X_MTH_SA3_BANK_EX14D dataset9 c_mnths_cur_empl_crs_i_fmt c_mnths_cur_empl dataset10 r_ast_liab_crs_i_fmt r_ast_liab thank you for you help

sss · ‎03-30-2015

Hi Ray, I got the desired utput thanks for your support. %em_register(key=REPORT,type=FILE, extension=xls); data x; Var1='100'; Var2='200'; Var3='56045634'; run; %em_report (KEY=REPORT, VIEWTYPE = FILEVIEWER, autodisplay=Y, block=%bquote(GRM Reports), DESCRIPTION=TESTREPORT); ods html file="&em_user_REPORT"; proc print data=x;run; ods html close;

sss · ‎03-30-2015

Hi Ray, Thanks for your suggestion. Added your code in report code editor of SAS code node. Unfortunately no CSV file was launched. but, a csv file was created in EMCode folder. I tried your option earlier to create CSV output from SAS code,It execution fine but not no excel file is lanched. I want to integrate csv/excel output with view button. When we click on view button the output is opened in RTF file which i want to create in CSV/EXCEL output. Request you to help to execute the code no matter how tricky/complex it is.

sss · ‎03-27-2015

Hi Ray wright, Thank your for your suggestion. Tried your suggestion its work. My client is looking something else below is requirement. When we execute code node with EM_Register and %EM_Report it produce reports. After right click on results it opens below window. The default output of %EM_Report is in Rtf or PDF. when we click on view button(highlighted in red circle) it open in word document as the extension is in .rtf Is there any way i can integrate the excel/csv/xml into view button. All your inputs and suggestion is appreciated.

Online Status	Offline
Date Last Visited	‎01-16-2024 11:34 AM

Re: Text Mining

Re: Text Mining

Re: Text Mining

Re: Text Mining

Text Mining

Re: assign last month value to previous 2 records

assign last month value to previous 2 records

Retaining unique values in same order

Transposing dataset using do loops and arrays.

Re: Renaming of variable

Re: Retaining unique values in same order

Re: Select Records In Group By

DATE VALUES

Re: Text Mining

Re: Text Mining

Re: Text Mining

Re: Text Mining

Text Mining

Re: assign last month value to previous 2 records

assign last month value to previous 2 records

Retaining unique values in same order

Transposing dataset using do loops and arrays.

Re: Renaming of variable

Re: Renaming of variable

Renaming of variable

Re: Eminer %EM_Register and %EM_Report Macros

Re: Eminer %EM_Register and %EM_Report Macros

Re: Eminer %EM_Register and %EM_Report Macros