Video

TIL: The forward rescan rule for macros.

I have one question ? Data have; Input sex$ 1.; Cards; F F F F M M M ; Run; How to get output like ---> Sex F M F M F M F ;

how to extract the value of the maximum count sir ??

Excellent explaination sir

I know this video is 3 years old, but I only just recently saw it (randomly looking for tips and tricks in SAS). The 2nd version of the code will not work; there is a logic flaw. The value for NEWVAR in obs 4 will be null. For the 4th iteration, the COUNT variable will still have a value of 2, and it will meet the condition of setting NEWVAR to MONTH4, overwriting the original 'C' from MONTH3. The original version of the code is the correct way. Just thought I'd mention that in case anyone else is still watching this in 2024.

Very nice tutorial! A couple of important points you didn’t mention: 1. When you use NODUPKEY to remove some records, it keeps the first record in the data (or last one using DESCENDING option before BY variable). If you want to keep different ones, you need to do some manipulation of the data. 2. When you use all variables after NODUPKEY, It’s an equivalent of using NODUP.

Awesome technique Sir, extraordinary stuff of yours in SAS programming.

Sir, how do we fix the length if the variable length is differing?

Sir thank you for sharing but to do proper merging or joining we need as first explained id, age ,salery 3 records but not should not show the age proper output

Thank you so much sir ❤❤ Appreciate your efforts and knowledge 🙏🙏

Super sir as share your knowledge 🙏

Please create complete etl tutorial with sas.

can anyone help to get a free version of sas base

How to contact you

Example :-It helps to Print 1st obs 4 times 4th obs 2 times 19th obs 6 times l

Way of explanation is excellent sir

Thank you, sir, for this video, it's very helpful

Sir make series on interview questions in sas🙏

Thanks this was very helpful, keep up the good work!!!!!

Link is not able to open sir. Please look into it and do needful

Please make vedio on Diffrrence between Libname and pass thru query in points wise which functions not work in pass thru query

Sir i have a question suppose we have 3 different id with multiple observations. And i want to impute missing value with their mean vallue then how can we do that. for each id mean value will be different.

For numeric missing we can use nmiss in proc means too right?

Please do more short videos sir

I am sorry you had to delete my comment. It was just an idea for a video. I'll unsubscribe do i don't mistakenly post another comment.

Salute you sir.

Superb sir, I have learn lots of logic building from your channel.

Thank you 👍🏻 for this video

Please clarify how the consecutive missing values in the middle were (for E id) are not counted with the both the ways? And what if we need to consider this scenario also?

I tried %let dsn=sashelp.class; and then trying to apply proc sort (PROC SORT DATA=&dsn ; BY SEX; RUN;)step its not working why? do u have any idea ?

Sir, kindly create a video on symmetry macro function.

Clever! Thank you!!! I run into this problem at least twice a week.

Is there a way to group variable and then use lag function so that one id value does not go to second id.

Thank you sir for such a helpful video.

Hi Sir..Thanks for posting videos. I am learning macros and I have a doubt regarding %global statement. Could you plz clarify. %macro win; %global name country; %let name=Sunny; %let country=India; %MEND Win; But I am unable to resolve the macro variables. Pls help me on this and Thanks in Advance!

If i want to assign the smaller length than the existing length in dataset in that case we will get a warning even if we give before the set statement

Thanks for the quick explanation . Is there any alternative way to do that except doing in another data step?

This is ingenious! Thank you!!!!

If you use the implicit method you can use the name you give the connection in your join sections. If you use the pass through method, you have to use the schema name for the joins. Also if you are using pass through you have to be aware of what kind of database you are connecting to and which functions it supports. the SAS datetime function will not work in a POSTGRESQL passthrough but will work in a ORACLE passthrough, you would have to do something like "cret_dt::timestamp::date" instead of datetime(cret_dt) for POSTGRESQL. However in a implicit connection, you can use all of the SAS built-in functions since its not an instance in another database. Amazing video.

Does select statement works before than having statement?? Generally excution order from -where -group by- having- select - order by. By using having clause with new variable , you have filtered the data . As per order select works after having. Then when you use calculated variable it's working how . Please help me...

Thankyou so much sir.

How can i get vaccancy information

Very informative sir❤

Sir, we can do this by using an Array as well. right? If yes, then please explain by using an array statement as well. One more request is to please do a topic on Hash objects, rsubmit programs. Thank you for providing practical scenarios.

Very useful. Never imagined the same table could be self-joined or that the ON variable could be set as negative!

Thank you 🙏

Thank you for the video. It would be good if you could share the SAS Code so that we can try and experience it

Can you show one scenario where to create a table in proc sql add a column which can be blank

Sir where is notes in description

I love this one! I've tended to avoid using into with proc SQL, but I'll give it a whirl now. Thanks a million!