ManoharNath Tracker

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 17:50:41 GMT

its completed and got done in two steps. Thank you.

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 17:39:15 GMT

able to solve problem in two step, after some hour of testing and it got done.

I know SAS very well and I was hoping if some one can share some ideas because as I was missing on few points but any way know no one here is to share ideas or thoughts.

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 17:31:31 GMT

Thanks you, I was able to solve the problem in two steps, first combining and later on creation of flag.

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 12:34:08 GMT

above code working for me to find all sas files and combines in output table and apologies I am not sure how to find for string within those codes as I am not sure how to do that.

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 12:27:54 GMT

I tried some codes , its working while combing all the .sas files but unable to do another task which is finding strings

Re: read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 12:24:35 GMT

First step: I am trying to read all .SAS files which sits in all directory and its subdirectory

2nd step: then Create a flag for particular string for like datamart word which are written any codes.

3rds step: then create columns like file path and file name and String name and string flag value as 1 if its getting used in code.

read all directory and its subdirectory for (.SAS extension) files and then find specific string

ManoharNath — Thu, 05 Oct 2023 12:30:50 GMT

%macro list_files(dir,ext);
  %local filrf rc did memcnt name i;
  %let rc=%sysfunc(filename(filrf,&dir));
  %let did=%sysfunc(dopen(&filrf));      

   %if &did eq 0 %then %do; 
    %put Directory &dir cannot be open or does not exist;
    %return;
  %end;

   %do i = 1 %to %sysfunc(dnum(&did));   

   %let name=%qsysfunc(dread(&did,&i));

      %if %qupcase(%qscan(&name,-1,.)) = %upcase(&ext) %then %do;
        %put &dir\&name;

        data _tmp;
          length dir $512 name $100;
		   
          dir=symget("dir");
          name=symget("name");
		  full_path = catx('\',dir,name);
        run;
        proc append base=want_new data=_tmp;
        run;quit;

      %end;
      %else %if %qscan(&name,2,.) = %then %do;        
        %list_files(&dir\&name,&ext)
      %end;

   %end;
   %let rc=%sysfunc(dclose(&did));
   %let rc=%sysfunc(filename(filrf));     

%mend list_files;
%list_files(\\path,sas)

I am trying to read all directory and its subdirectory for .SAS (SAS extension) files and then find specific string and create columns as file path and file name and string flag name for a specific string like datamart used in code and then create flag and assign value as 1 if its getting used within code and output as table.

Re: SAS: How to Look into folder/subfolder. Open and concatenate data files (if condition was satisf

ManoharNath — Thu, 05 Oct 2023 11:43:34 GMT

is it possible to check for any string within code and create a flag for that string if its have been in code. if yes can you help me how to incorporate within this code.

How to read and import files which sits under multiples folder

ManoharNath — Tue, 16 May 2023 10:03:49 GMT

Issues is: file sits under multiple folder.

For example parent path is: 'C:\users\manohar\downloads\data' then we have multiple folder with name of date as.

example 01may2023, 02may2023,03may2023, under this folder. I have files named as

Each folder have 1 file for example for folder 01may2023 file name is Trans 250423.xls

02may2023 file name is trans 260423.xls

03may 2023 folder file name is trans 270423.xls

Can some one help me here. how to import and read this file, I have to read from 2018 onwards.

Re: How to send email using SAS

ManoharNath — Fri, 25 Nov 2022 19:37:07 GMT

Thank you for your revert.

Re: How to send email using SAS

ManoharNath — Fri, 25 Nov 2022 19:38:10 GMT

Sorry for delay in response and thank you everyone for your revert.

I was able to solve the prolem by using %if and %len method.

This resolved the problem.

%if %length(Video_segment1) > 0 %then %do;

%put &Video_segment1.;

%put &Video_Desc.;

end;

Re: Send Dynamically email to individual Person by SAS Code

ManoharNath — Fri, 25 Nov 2022 19:38:19 GMT

Sorry for delay in response and thank you everyone for your revert.

I was able to solve the prolem by using %if and %len method.

This resolved the problem.

%if %length(Video_segment1) > 0 %then %do;

%put &Video_segment1.;

%put &Video_Desc.;

end;

Re: How to send email using SAS

ManoharNath — Wed, 02 Nov 2022 11:07:39 GMT

How to remove missing values from email.

for below example:

put " ";
 put "&segment1_Desc. "; /*no values and coming as " " in log and output */
 put "&segment1_link. "; /*no values and coming as " " in log and output */
 put "&segment2_Desc. "; /*no values and coming as " " in log and output */
 put "&segment2_link. "; /*no values and coming as " " in log and output */
 put "&segment3_Desc. "; /*no values and coming as " " in log and output */
 put "&segment3_link. "; /*no values and coming as " " in log and output */
 put "&segment4_Desc. ";
 put "&segment4_link. ";
 put "&segment5_Desc. ";
 put "&segment5_link. ";
 put "&segment6_Desc. "; /*no values and coming as " " in log and output */
 put "&segment6_link. "; /*no values and coming as " " in log and output */
 put " ";

for this I am getting " " in sas log and in sas test outlook email

below is log:

SYMBOLGEN: Macro variable SEGMENT2_DESC resolves to
MPRINT(EMAILHV): put " ";

in output it coming as

" " " " " " Video desc

video link

" "

I am trying to supress this " " to coming in mail.

Regards,

Manohar

How to supress Macro variable resolve to put " "; in SAS Email

ManoharNath — Wed, 02 Nov 2022 09:07:41 GMT

Hi Everyone,

I need one help related to macro variables which have null or no values which is resolving to " ".

I want to remove or supress " " this in output in SAS Email.

put "&segment1_Desc. "; /*have no values*/
put "&segment1_link. "; /*have no values*/

but in output getting " " " ". any ideas how to supress this " ".

Regards,

Manohar

Re: Send Dynamically email to individual Person by SAS Code

ManoharNath — Mon, 31 Oct 2022 15:00:21 GMT

I appreciate the help and I am able to solve the problem and now I am getting only one problem.
I can see video link and its description but for some customers whom we don't have videos, for that its resolving to "" and coming in email. I am looking to avoid this "" in email. can you please suggest how to overcome this problem

for 1st customer it have 1st segment video link and description and I am getting that information, but for rest segment it don't have video segment as expected and it has to be missing but getting "" "" "" this.

Output I am getting:

Take a look at the short video.

Collections Strategies

" " " " " " " " " "

Now trying to avoid or compress this (" " " " " " " " " ) from the email.

Send Dynamically email to individual Person by SAS Code

ManoharNath — Mon, 31 Oct 2022 19:00:18 GMT

Hi Everyone, I need one help related to SAS automated email which send email to every other individuals.

Task is : There is 6 unique segments of videos link and its description which need to be send to customers.

suppose AAA customer is receiving 1 videos link and 1 video description and others can receive 2 or more videos link with its description for every customers.

Others customers can not see others email, it has to be send to every individual or row wise.

I appreciate the help and I am able to solve the problem and now I am getting only one problem.
I can see video link and its description but for some customers whom we don't have videos, for that its resolving to "" and coming in email. I am looking to avoid this "" in email. can you please suggest how to overcome this problem

Output I am getting:

Take a look at the short video.

Collections Strategies

" " " " " " " " " "

Now trying to avoid or compress this (" " " " " " " " " ) from the email.

For example;

Link Desc: Collection Stratigies

Link: https://www.youtube.com/watch?v=6TK20Y5oD9s

need help to write sas code which can send email to this customers dynamically.

first_name	EMAIL_ADDRESS	Video_segment1	Video_segment2	Video_segment3	Video_segment4	Video_segment5	Video_segment6
AAA	AAA@COM	Yes
BBB	BBB@COM	Yes	yes
CCC	CCC@COM	Yes	yes	yes
DDD	DDD@COM	Yes
EEE	EEE@COM				Yes	yes
FFF	FFF@COM	Yes	Yes	Yes	Yes	Yes	Yes
GGG	GGG@COM	Yes

Re: Want to find weekly start and end date for dates.

ManoharNath — Sat, 23 Jul 2022 13:04:31 GMT

Thank you for quick and prompt response.

Re: Want to find weekly start and end date for dates.

ManoharNath — Sat, 23 Jul 2022 13:06:11 GMT

Thank you for effecient solution and for quick and prompt response.

Want to find weekly start and end date for dates.

ManoharNath — Thu, 21 Jul 2022 19:24:06 GMT

Hello Friends, need help on urgent basis, I want to calculate weekly start date and weekly end date in SAS.

I am trying to achive similary mentioned in linked link output: https://savvytime.com/week-number/australia/2022

below is sample data and also attached this data for your references.

we have only one input column which is Business_dt and based on Business_dt column I want to create other 3 column which i have mentioned below.

I need 3 columns in output which are

Week_yyweekv8

Start_week_dt

End_Week_dt

Business_dt	Week_yyweekv8	Start_week_dt	End_Week_dt
27-12-2021	2021-W01	27-12-2021	02-01-2022
28-12-2021	2021-W01	27-12-2021	02-01-2022
29-12-2021	2021-W01	27-12-2021	02-01-2022
30-12-2021	2021-W01	27-12-2021	02-01-2022
31-12-2021	2021-W01	27-12-2021	02-01-2022
01-01-2022	2021-W01	27-12-2021	02-01-2022
02-01-2022	2021-W01	27-12-2021	02-01-2022
03-01-2022	2022-W02	03-01-2022	09-01-2022
04-01-2022	2022-W02	03-01-2022	09-01-2022
05-01-2022	2022-W02	03-01-2022	09-01-2022
06-01-2022	2022-W02	03-01-2022	09-01-2022
07-01-2022	2022-W02	03-01-2022	09-01-2022
08-01-2022	2022-W02	03-01-2022	09-01-2022
09-01-2022	2022-W02	03-01-2022	09-01-2022
10-01-2022	2022-W03	10-01-2022	16-01-2022
11-01-2022	2022-W03	10-01-2022	16-01-2022
12-01-2022	2022-W03	10-01-2022	16-01-2022
13-01-2022	2022-W03	10-01-2022	16-01-2022
14-01-2022	2022-W03	10-01-2022	16-01-2022
15-01-2022	2022-W03	10-01-2022	16-01-2022
16-01-2022	2022-W03	10-01-2022	16-01-2022
17-01-2022	2022-W04	10-01-2022	16-01-2022
18-01-2022	2022-W04	10-01-2022	16-01-2022

Re: Merging in SQL, want to write this code in sql: if (ab and mn) = 1 then flag = "Y"; el

ManoharNath — Mon, 28 Mar 2022 16:01:58 GMT

Thank you, its working and giving right output.