About ralizadeh

ralizadeh · ‎06-15-2023

No, that doesn't work. I tried that before. I almost tried all the possible locations.

ralizadeh · ‎06-15-2023

How do I get a total for each months in here? I've tried many ways and none worked so far. I want to have something like this:

ralizadeh · ‎06-14-2023

I generated the M03_Step1 table below using the M03_Step1 program. I want to alter the position of the library within the code, but I don't want to run the program again because it will take some time to complete. Is it feasible to move that table from the current library to another location (new library), assign the new library to this project, and somehow relink this table? Essentially, I want this table to be loaded from the new library location rather than where it was originally stored. It doesn't appear like I can accomplish this, but I wanted to ask anyhow. Perhaps someone knows a trick?

ralizadeh · ‎05-17-2023

Thanks @TomKari I am getting somewhere now. So, in this case, if I want to pull the CINs that are NOT in t2 table how should I proceed? should I just use Inner Join with t1.CIN ^= t2.CIN? I am trying to get this with SAS EG: ELECT * FROM TableA LEFT OUTER JOIN TableB ON TableA.name = TableB.name WHERE TableB.id IS null

ralizadeh · ‎05-16-2023

Thanks @Tom , but I am not sure if I get your point. In the picture I shared, the ON condition is based on CIN i.e. t1.CIN1 = t2.CIN2. So, it won't make sense to me to have t1.CIN1=t2.CIN2 in my INNER JOIN and also t1.CIN1 ^= t2.CIN2 as another condition. Am I missing something here?

ralizadeh · ‎05-16-2023

Could someone clarify the effect of using different conditions, such as "greater," "smaller," or "not equal," when joining tables? I initially thought that an inner join requires an equal condition, but now I see that other conditions are possible. How does selecting "not equal" instead of "equal" impact the inner join? PROC SQL; CREATE TABLE WORK.Non_Preg_Count AS SELECT t1.CIN AS CIN1, t1.New_Month AS New_Month1, t2.CIN AS CIN2, t2.New_Month AS New_Month2 FROM WORK.MERGED_FINAL t1 INNER JOIN WORK.MERGED_PREG_FINAL t2 ON (t1.CIN ^= t2.CIN); QUIT;

ralizadeh · ‎05-12-2023

I successfully addressed my specific requirement by utilizing the query builder in three distinct steps. Initially, I divided the relevant date periods and created a separate table for each. Then, I applied the Case statement to the newly generated tables. Finally, I appended all three tables, allowing me to count occurrences for each specified month.

ralizadeh · ‎05-12-2023

Thanks @LinusH While my original goal was to identify the duplicate row values, your suggestion proved to be valuable in a broader sense. It allowed me to at least determine the count of rows with duplicate values.

ralizadeh · ‎05-11-2023

Found why it wasn't working. I did not check off "Generate filter for a prompt value". Now it is working! 😀

ralizadeh · ‎05-11-2023

I am trying to make a filter in SAS EG using the Filter Data tab and the prompt date. I get the error below. Not sure why. 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET DateRange_max = 31Dec2022; 4 %LET DateRange_min_label = November 01, 2021; 5 %LET DateRange_min = 01Nov2021; 6 %LET DateRange_max_label = December 31, 2022; 7 PROC SQL NOEXEC; 8 SELECT t2.CIN, 9 t2.Month, 10 t2.Year, 11 t2.DATE, 12 /* October */ 13 (Month( intnx('month', "&DateRange_min"d, 11, 'end'))) FORMAT=Z2. AS October, 14 t2.Age_Group, 15 t2.Elig 16 FROM WORK.NO_DUP t2 17 WHERE t2.DATE BETWEEN &DateRange_min AND &DateRange_max; NOTE: Line generated by the macro variable "DATERANGE_MIN". 17 01Nov2021 _______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !!, *, **, +, -, /, AND, ||. ERROR 76-322: Syntax error, statement will be ignored. 18 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 19 %SYMDEL DateRange_max_label; 20 %SYMDEL DateRange_min_label; 21 %SYMDEL DateRange_min; 22 %SYMDEL DateRange_max; 23 24 QUIT; RUN;

ralizadeh · ‎05-11-2023

Never mind. I found why. I did not assign the prompt to the query.

ralizadeh · ‎05-11-2023

I want to write a CASE WHEN statement. I would like to use my prompt date that has an start date and end date. SAS EG will code it as "&DateRange_min"d and "&DateRange_max"d. No need to think about the end date for this question. I want to choose those rows in my table that their dates are between "&DateRange_min"d and 12 month later. For example if "&DateRange_min"d is 11/01/2021 then "&DateRange_min"d + 12 months should come out as 10/31/2022 (last day of that month). I need any rows between these two dates (which easily can be done with CASE WHEN statement if I could figure out the end date). I need to make sure the codes would work properly when the interval crosses the year boundary e.g. "&DateRange_min"d is in 2021, and 12 month later is another year e.g. 2022 while also taking into consideration that not all months have the same number of days in them. I wrote the code below to first create a computed column in Query Builder that will add 12 months to "&DateRange_min"d, however I get an error. Any thought, why? intnx(month, &DateRange_min, 12, e) This is also failed intnx(month, "&DateRange_min"d, 12, e)

ralizadeh · ‎05-11-2023

Thanks @LinusH. Just to confirm, did you mean that I should add CIN, YY, MM to the Select Data (columns) in the Query Builder, then use COUNT as a summary function for MM. Then add CIN, YY to the Group By. Add Count(*) >1 to HAVING clause under Filter tab?

ralizadeh · ‎05-10-2023

Let me rephrase my question. I have three columns named ID, Month, and Year. My goal is to create a new column called "new_month." The values for the "new_month" column will be determined based on a prompt that will get two dates (as shown in the previous picture), start and end date. I will provide two dates in response to the prompt. the month of the start date will be the start point. The values in the Month column that fall between the month of the start date and month (start date)+2 should be assigned to month (start date) +2. If the values in the Month column falls between the month (start date) +1 and month (start date) +3 should be assigned to month (start date) +3. Last round would be, if the values in the Month column falls between the month (start date) +2 and month (start date) +4 should be assigned to month (start date) +4. None of the IF conditions should overwrite the pervious month assignment for a given row but rather create a new row with the new month assignment, if needed. There will be duplicated values for IDs because a single month, such as 10, may belong to multiple categories (10, 11, and 12). 10 is between 8 and 10, between 9 and 11 and also between 10 and 12. This duplication is intentional as I need to count the number of IDs from two months prior to my measuring period. The measuring periods, in this case, are 10, 11, and 12. Example, if the prompted date start date is 08/01/2022, and end date is 12/31/2022 any values in the Month column that fall between 8 and 10 should be assigned the value 10. Similarly, values between 9 and 11 should be assigned 11, and values between 10 and 12 should be assigned 12. And it stops here.

ralizadeh · ‎05-10-2023

Is there a way in SAS EG to find duplicated values? Must have duplicated rows in CIN and YY columns but have distinct MM. And I need all three columns in the output. Example data below:

Online Status	Offline
Date Last Visited	‎06-22-2023 06:55 PM

Re: How to fix this summary table?

How to fix this summary table?

Is it possible to change the output table location generated by a prog...

Re: Condition on Inner Join and the rest.

Re: Condition on Inner Join and the rest.

Condition on Inner Join and the rest.

Re: How to let SAS duplicate rows when multiple conditions are met in ...

Re: Find duplicated values in SAS EG

Re: SAS EG Filter error

SAS EG Filter error

Re: How to remove duplicate rows based on some columns in SAS Enterpri...

Re: What is SAS EG equivalent method to create a Case statement?

Re: What is SAS EG equivalent method to create a Case statement?

Re: "Group By" clause keep giving me an error, not sure why.

Re: Importing Excel data after Excel file location changes in SAS EG

Re: How to remove duplicate rows based on some columns in SAS Enterpri...

Re: How to fix this summary table?

How to fix this summary table?

Is it possible to change the output table location generated by a prog...

Re: Condition on Inner Join and the rest.

Re: Condition on Inner Join and the rest.

Condition on Inner Join and the rest.

Re: How to let SAS duplicate rows when multiple conditions are met in ...

Re: Find duplicated values in SAS EG

Re: SAS EG Filter error

SAS EG Filter error

Re: Date + number of month combination

Date + number of month combination

Re: Find duplicated values in SAS EG

Re: How to let SAS duplicate rows when multiple conditions are met in ...

Find duplicated values in SAS EG