About _el_doredo

_el_doredo · ‎06-29-2021

@PaigeMiller Thank you so much.. I'll work on this one and i'll learn about it

_el_doredo · ‎06-29-2021

@Ksharp ,Thank you so much. But, Can you please explain about your code. I know that prxchange will check based on the bracket. But, Not getting completely. So it would be helpful if you explain your code Thanks in advance

_el_doredo · ‎06-27-2021

@PaigeMiller , Thanks for your answer. But, I need alternate 'o' to be upper case

_el_doredo · ‎06-27-2021

Thank you so much... I tried with the sub query.. proc sql; select a.dept_name, a.emp_id, count(emp_id) as count, b.total_bonus, (b.total_bonus/ calculated count) as bonus from emp_table a left join dept_table b on a.dept_name=b.dept_name group by a.dept_name; quit;

_el_doredo · ‎06-27-2021

Hi Experts, I am learning on SAS. I came across this query. I am not able to find answer for this one. I hope you guys will help me on this with the method. data dept_table; input dept_name $ total_bonus ; cards; IT 50000 HR 69000 GL 90000 ; run; Data Emp_table; input dept_name $ emp_id; cards; IT 1 IT 2 IT 3 IT 4 IT 5 HR 23 HR 45 HR 86 GL 96 GL 52 GL 25 ; run; I need to split the total dept bonus to all the employees in that specific dept. I tried but doing so my subquery resulting multiple rows so not getting exact result... My expected result is This is the program i tried: proc sort data=dept_table; by dept_name; run; proc sort data=emp_table; by dept_name; run; data final; merge dept_table(In=A) emp_table(IN=B); by dept_name; proc print; run; proc sql; select dept_name,emp_id,(select count(emp_id) from final group by dept_name) from final; quit; I hope you guys can help me on this

_el_doredo · ‎06-27-2021

Hi Experts, I have one doubt .. I hope you guys can clarify my doubt.. %let string=the quick brown fox jumps over the lazy dog; /*all low case letters*/ This is the string, now I need to update all the second occurrence of 'o' letter to capital one... how I will achieve it? Any ideas?? My output should be like this "the quick brown fOx jumps over the lazy dOg" Thanks in Advance

_el_doredo · ‎03-17-2021

Hi Ksharp, Thanks for the solution.Let me try this from my end

_el_doredo · ‎03-17-2021

Hi Mkeintz, Thanks for your solution... It working fine as expected.. I am not familiar with hash approach.. So thanks for introducing one new concept to me...

_el_doredo · ‎03-17-2021

Hi Clemmensen, Thanks for your solution... It working fine as expected.. I am not familiar with hash approach.. So thanks for introducing one new concept to me...

_el_doredo · ‎03-17-2021

Hi William, Thanks for you solution.. It is working perfectly fine. But, I have few doubts.. 1) What's the purpose of using type 'C'. Is it used to mention fmtname is character variable?. I tried with using Dollar symbol($) and _CHARACTER_ but it throughing some error... It will be helpful if i got to know the purpose 2)Why we are using hlo='0'. I know it has to do with formatting.. Because it throughing error if we removed that line. So i am not sure about the purpose of this..

_el_doredo · ‎03-17-2021

Hi Reez, I tried this way and it worked.I am looking for any better code to use with all type of hierarchy scenarios data hierarchy; input parent $ child $ ; cards; A B B K K C ; run; proc sql; create table master as select A.parent from hierarchy as A union all select A.child from hierarchy as A where A.child not in (select B.parent from hierarchy as B) ; quit; data dummy(drop=counter); set master; counter=_n_; if counter=1 then relationship='great grand parent'; else if counter=2 then relationship='grand parent'; else if counter=3 then relationship='parent'; else if counter=4 then relationship='child'; proc print noobs; run; proc transpose data=dummy out=final(drop=_name_); id relationship; var parent; run;

_el_doredo · ‎03-15-2021

Hi Reeza, So far i didn't used PROC BOM or subgraph... If you send a code using PROC BOM or subgraph means it will be useful for my learning. I tried with repeating the code one more time but not getting expected results.. Thanks, Syed

_el_doredo · ‎03-15-2021

Hi Experts, I need to find out great grandparent for the child using this dataset. DATA hierarchy; input parent $ child $; cards; A B B K K C ; RUN; In this dataset, Value C's parent is K and C's grandparent is B and C's great grandparent A. So i need result like this I tried with PROC SQL. I am able to find out till Grandparent but i am not able to find out Great_grandparent hierarchy. I used this code proc sql; select child,parent, (select parent from hierarchy where child=a.parent) as grandparent from hierarchy as a where child='C'; quit; but i am not able to find great grandparent... Can you guys please suggest a way to achieve this use proc sql itself Thanks in advance Regards, Syed

_el_doredo · ‎02-02-2021

Yeah sure.. It will be helpful for me to learn more about SAS macros.. Thanks for your suggestion

_el_doredo · ‎02-01-2021

Yeah exactly like this. I am in learning phase... but,this method worked for me %macro ibrahim; data ibbu; set sashelp.class; If Age>=13 then do; status= "&status" ; end; else do; status= "&stat"; end; %mend ibrahim; %ibrahim;

Online Status	Offline
Date Last Visited	‎10-31-2024 05:40 PM

Re: Transposing Data with Blank Rows and Repeating Instances

Re: How to print table name using proc fedsql

How to print table name using proc fedsql

Re: How to find count of each dataset

Re: How to find count of each dataset

How to find count of each dataset

I need to check whether the variable is available if yes means I need ...

Re: How to import only the first obs from each file into sas

Re: How to import only the first obs from each file into sas

How to import only the first obs from each file into sas

Re: How to print table name using proc fedsql

Re: How to print table name using proc fedsql

Re: How to print table name using proc fedsql

Re: How to find count of each dataset

Re: How to find count of each dataset

Re: How to use macro variable that created using CALL SYMPUT in anothe...

Re: How to use macro variable that created using CALL SYMPUT in anothe...

Re: Updating all the second occurance of specific letter in a string

Re: Updating all the second occurance of specific letter in a string

Re: Updating all the second occurance of specific letter in a string

Re: Split the dept bonus equally to all employees in that dept

Split the dept bonus equally to all employees in that dept

Updating all the second occurance of specific letter in a string

Re: How to find great grand parents in the dataset

Re: How to find great grand parents in the dataset

Re: How to find great grand parents in the dataset

Re: How to find great grand parents in the dataset

Re: How to find great grand parents in the dataset

Re: How to find great grand parents in the dataset

How to find great grand parents in the dataset

Re: How to use macro variable that created using CALL SYMPUT in anothe...

Re: How to use macro variable that created using CALL SYMPUT in anothe...