About pp2014

pp2014 · ‎08-26-2016

I have almost 170 email addresses.. Anyway I was able to fix my code. Thanks Reeza for help...

pp2014 · ‎08-26-2016

I am trying to read the email_list file and output only email addresses separated by semi-column. But my code goes into a loop. Can anybody help me in this?? email_file.txt has following records: Doe, John <john.doe@abc.com>;Smith, Jeff <jeff.smith@abc.com>; lever, dave <dave.lever@abc.com> Below is my code: data test; length text $32767; infile 'c\email_file.txt' lrecl=32767 dsd dlm='09'x truncover; input text $; run; data t1; set test; length tx3 $500; tx3=""; tx1=text; do until (length(cats(tx1))=0); space_position = INDEX(tx1, '<'); slash_position = INDEX(tx1, '>'); space_to_slash = slash_position - space_position; tx2 = substr(tx1, space_position+1, space_to_slash-1); tx3=cats(tx3,tx2,";"); tx4=substr(tx1,find(tx1,";")+1); tx1=tx4; end; run;

pp2014 · ‎08-26-2016

I am trying to read the email_list file and output only email addresses separated by semi-column. But my code goes into a loop. Can anybody help me in this?? email_file.txt has following records: Doe, John <john.doe@abc.com>;Smith, Jeff <jeff.smith@abc.com>; lever, dave <dave.lever@abc.com> Below is my code: data test; length text $32767; infile 'c\email_file.txt' lrecl=32767 dsd dlm='09'x truncover; input text $; run; data t1; set test; length tx3 $500; tx3=""; tx1=text; do until (length(cats(tx1))=0); space_position = INDEX(tx1, '<'); slash_position = INDEX(tx1, '>'); space_to_slash = slash_position - space_position; tx2 = substr(tx1, space_position+1, space_to_slash-1); tx3=cats(tx3,tx2,";"); tx4=substr(tx1,find(tx1,";")+1); tx1=tx4; end; run;

pp2014 · ‎08-26-2016

Thanks Reeza for all the help...

pp2014 · ‎08-26-2016

It can be considered 3 separate fields. Final output should have only email addresses separated by ; delimiter

pp2014 · ‎08-26-2016

Yes, the structure is exactly same all the time

pp2014 · ‎08-26-2016

I have following data in Text file separated by ; delimiter. I want only the email addresses separated by ; delimiter. Input: Doe, John <john.doe@abc.com>;Smith, Jeff <jeff.smith@abc.com>; lever, dave <dave.lever@abc.com>; Output should be: john.doe@abc.com;jeff.smith@abc.com;dave.lever@abc.com Any help in this will be greatly appreciated.

pp2014 · ‎07-05-2016

Thanks John...

pp2014 · ‎07-05-2016

I have time in the format timeampm8. For eg. 2:35 AM, 5:03 Am etc. etc. I want to group the time as following : "1 AM - 3 AM" "3 AM - 5 AM" "5 AM - 7 AM" ---- etc.

pp2014 · ‎06-08-2016

Yes, SAS code worked perfectly until yesterday..

pp2014 · ‎06-08-2016

Thanks Reeza. If I run VBA macro, then it works. It formats the Report. But when I let SAS run the Same Madcro, it does not work..

pp2014 · ‎06-08-2016

I have following code which I have been running for couple months in my daily job. But since yesterday it stopped working. It opens the excel file and then it does not do anything (not running the VBA macro at all). Below is my code. Please let me know if any settings need to be changed... Below is my code: %let macDrv=c:\Temp\Reports; %let macBook=Macro_Format_Scorecard.xlsm; %let macName=FormatAllReports; filename exl dde 'excel|system'; options noxwait noxsync; x "'C:\Program Files\Microsoft Office\Office15\EXCEL.EXE' &macDrv.\&macBook"; data _NULL_; x=sleep(5); run; data _null_; file exl; put '[RUN("'"&macBook"'!'"&macName"'",FALSE)]'; put '[ERROR(FALSE)]'; put '[SAVE()]'; put '[CLOSE()]'; run; data _null_; file exl; put '[QUIT()]'; run;

pp2014 · ‎04-22-2016

I am using Proc import to read excel file. It has more than 300 columns. But it reads only 255 columns. Does anybody know whether there is any option to read more columns? I am using SAS 9.2 version. Following is my sample code: PROC IMPORT OUT= want DATAFILE= "c\have.xlsx" DBMS=excel REPLACE; RUN;

pp2014 · ‎04-04-2016

I have a field in the dataset called webpage: It has values as follows: www.abc.com/about www.abc.com/about-afib www.abc.com/about/activations www.abc.com/home/ www.abc.com/mobile www.mobileabc.com/xyz.php I want the following output: www.abc.com/about www.abc.com/home/ www.abc.com/mobile

pp2014 · ‎03-30-2016

Any help???

Online Status	Offline
Date Last Visited	‎04-15-2020 05:53 PM

Re: Help with Transposing Columns into rows

Help with Transposing Columns into rows

Help with Removing Blanks in the field

Re: Help in finding the New Rx Writers

Re: Help in finding the New Rx Writers

Help in finding the New Rx Writers

Re: Filling up and down missing values with non-missing values

Re: Filling up and down missing values with non-missing values

Filling up and down missing values with non-missing values

Re: Carriage Returns - Need to be removed

Re: Filtering URL addresses

Re: How to subtract hours from datetime Variable in proc sql

Re: Help in Reading the Text file and output only the email

Help with SAS code which is in a loop

Re: Help in Reading the Text file and output only the email

Re: Help in Reading the Text file and output only the email

Re: Help in Reading the Text file and output only the email

Re: Help in Reading the Text file and output only the email

Help in Reading the Text file and output only the email

Re: Need Help in Grouping Time

Need Help in Grouping Time

Re: Problem Running Excel VBA Macro through SAS

Re: Problem Running Excel VBA Macro through SAS

Problem Running Excel VBA Macro through SAS

How to Import an Excel File to SAS University Edition

Filtering URL addresses

Re: Help with the data