About SahooP

SahooP · ‎05-27-2021

However, I am notable to delete the file using Macro code.

SahooP · ‎05-27-2021

33 /*%check(file = 20210524_3904_TOT_RECS_MSTR_DS6_NEW_ADD-CHG_REC-OLD_SPH0_REC.csv); */ 34 %check (20210524_3904_TOT_VOL_8TH_POS_OF_DCN_1_OR_GREATER_%str(&)_CURR_DCN-OB.csv); MLOGIC(CHECK): Beginning execution. MLOGIC(CHECK): Parameter FILE has value 20210524_3904_TOT_VOL_8TH_POS_OF_DCN_1_OR_GREATER_&_CURR_DCN-OB.csv MLOGIC(CHECK): Ending execution.

SahooP · ‎05-27-2021

options symbolgen mprint; %macro check(file); X "rm /path/users/&file."; %mend check; /*%check(file = 20210524_3904_TOT_RECS_MSTR_DS6_NEW_ADD-CHG_REC-OLD_SPH0_REC.csv); */ %check (20210524_3904_TOT_VOL_8TH_POS_OF_DCN_1_OR_GREATER_%nrstr(&)_CURR_DCN-OB.csv); I am not able to resolve.

SahooP · ‎05-27-2021

20210524

SahooP · ‎05-27-2021

Below code trying to resolve. However file is not reading. %check (&date._3904_TOT_VOL_8TH_POS_OF_DCN_1_OR_GREATER_&_CURR_DCN-OB.csv);

SahooP · ‎03-10-2021

Thank you so much for your help.

SahooP · ‎03-10-2021

I am looking for the above screenshot as an example. I was trying to get resolve the value for totalpln should be 60 for resource1. Similarly for totalact should be 60 for resource1..

SahooP · ‎03-10-2021

Yes, I have create three different additional column for pl, act and var . That should be sum of each month. For example as per given screenshot the first row sum pln should be should be 60 for resource1 that column should be totalpln.

SahooP · ‎03-10-2021

Yes, sum of each after each Task and after each Prid and each resourcename.

SahooP · ‎03-10-2021

Hi , The above report I have created here i need a help how to create a new variable called totalpln which will be sum of "pln" for each month. Similarly other two variable as well.. . I have attached my SAS code. Can someone help me DATA planacthours; INPUT prid $ taskname $ resourcename $9. month :monyy5. pln act var; format month monyy5.; CARDS; pr15614 task1 resource1 Jan-21 20.0 10.0 10.0 pr15614 task1 resource1 Feb-21 20.0 20.0 0.0 pr15614 task1 resource1 Mar-21 20.0 30.0 -10.0 pr15614 task2 resource1 Apr-21 40.0 10.0 30.0 pr15614 task1 resource2 Jan-21 60.0 70.0 -10.0 pr15614 task2 resource2 Feb-21 60.0 40.0 20.0 pr15614 task1 resource2 Mar-21 20.0 10.0 10.0 pr15614 task2 resource2 Apr-21 80.0 10.0 70.0 pr15614 task1 resource3 Jan-21 20.0 10.0 10.0 pr15614 task1 resource3 Feb-21 40.0 60.0 -20.0 pr15614 task3 resource3 Mar-21 20.0 10.0 10.0 pr15614 task3 resource4 Jan-21 20.0 10.0 10.0 pr15614 task4 resource4 Apr-21 20.0 50.0 -40.0 pr15614 task4 resource4 Feb-21 20.0 10.0 10.0 ; RUN; PROC REPORT DATA=test NOWD ; COLUMN prid taskname resourcename month,(pln act var); DEFINE prid / group; DEFINE taskname / group; DEFINE resourcename / group; DEFINE month / across order=data; DEFINE pln / analysis FORMAT=3.2; DEFINE act / analysis FORMAT=3.2; DEFINE var / analysis FORMAT=3.2; /*DEFINE totalpln / display FORMAT=3.2;*/ /*define total/computed FORMAT=3.2;*/ /*compute total;*/ /*total=pln.sum;*/ /*endcomp;*/ RUN; .

SahooP · ‎11-02-2020

Scenario1: There might be one or more files for a month, if the Practitioner is listed on the monthly file generated previously and the same is listed in the current file without any changes, then update the date to the latest file generated date in 'File Date' column. File Date column I have extracted in my above screenshot document which is date variable. Scenario2: Practitioner is listed on the monthly file generated previously and the same is listed in the current file with any changes/updates, then update it as a new record with file generation date in file date column, where the old record remains same. Example: Group1. ABC_20200909_INITIAL ABC_20200901_INITIAL Group2. ABC_20200909_RECRED ABC_20200909_RECRED Note: The comparison should happen based on file prefix and suffix name. It seems we have same prefix but suffix is changed.(INITIAL AND RECRED) This will be as dynamic process. So the same file might not be fall in next month. It can be some other file as well. It shouldn't hard coded. I have given screenshot is one of the example. Data sets will reside work library.

SahooP · ‎10-30-2020

Hi, I have SAS datasets like this attached image. Based on FILENAME I am able to import as SAS datasets from source. Once after that I would like compare datasets based on COL1 and COL2 group as per the prefix file name. This will be as dynamic process. So the file name might be differ in next month. It shouldn't hard coded. We might be receiving same prefix name files with in a month twice or thrice in different dates. So how to compare two different SAS datasets to find out if there are any records difference. For example: ABC_20200909_INITIAL ABC_20200901_INITIAL I would like to know some sample Macro to do this. Could you please provide me?

Online Status	Offline
Date Last Visited	‎09-14-2022 10:47 AM

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Filename having special character. How to pass macro parameter.

Re: Proc Report Summarize

Re: Proc Report Summarize

Re: Proc Report Summarize

Re: Proc Report Summarize

Proc Report Summarize

Data-Driven Programming Techniques Using SAS®

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Re: Filename having special character. How to pass macro parameter.

Filename having special character. How to pass macro parameter.

Re: Proc Report Summarize

Re: Proc Report Summarize

Re: Proc Report Summarize

Re: Proc Report Summarize

Proc Report Summarize

Re: Dynamically how to compare two different sas datasets based on sam...

Dynamically how to compare two different sas datasets based on same pr...