Brilliant solution! Thank you for sharing this explanation!!!
@deepakkumaar9665
3 жыл бұрын
Every step so clearly explained, thanks sir
@9356079
5 жыл бұрын
Very useful video and nicely explained
@MegaLex22
Жыл бұрын
you saved me a ton of work! thank you!
@jonathannnabu3962
2 жыл бұрын
Awesome video. thank you
@manikantach545
4 жыл бұрын
countw is not working for me ,the same code when i tried to do practice.Your tutorials are much helpful.
@kiranvenna
4 жыл бұрын
Can you paste the code. So that I can check
@manikantach545
4 жыл бұрын
data one; length string $30.; input string $; cards; ab bc cd ef gh ij kl mn op qr st uv ; run; data two; set one; cnt_string=countw(string," "); run; proc print data=two; run; output: Obs string cnt_string 1 ab . log; no erros
@kiranvenna
4 жыл бұрын
you are reading only ab in dataset one. change your input statement to input string & $ ;
@manikantach545
4 жыл бұрын
Yes sir,After changing also it's not working.I think it May be because of I'm using version 9.
@International_Sanatani
3 жыл бұрын
@@kiranvenna what does '&' represent in input statement?
@sharathreddy159
5 жыл бұрын
Nice
@sharathreddy159
5 жыл бұрын
I want joins interview scenario based questions and imp topics
@rimalmahesh
3 жыл бұрын
Can you make a video on Hash object and Array in SAS
@kiranvenna
3 жыл бұрын
I would like to make videos on SAS hash object sometime in future.
@_Prav_n
4 жыл бұрын
Hi, You are doing great work! Could you make a video for overlapping dates concept. It would be of great help!!
@kiranvenna
4 жыл бұрын
Thank you Can you get me an example or sample data of what you are asking
@MANOJKUMAR-hs4wq
11 ай бұрын
Please tell me gow to solve this . I have column id and columns more than 200 (numeric) like jan p_jan_2007,p_feb_2007,.....p_jun_2023 Q1) sum row wise Q2) drop the columns having zeros by id wise Ex below: Q1) Id p_jan2007 ..p_jun_2023 total Mx1 24 ... 112.5 136.5
@kiranvenna
11 ай бұрын
Made a video on the first point, I did not clearly understand question2. kzitem.info/news/bejne/sKttyal5nmuYlXo
@sagarmandal4990
3 жыл бұрын
Hi Sir, I have this dataset below. data Test; length Marks $15.; input Name $ Roll_Number Marks $; cards; Name1 101 70,80,90 Name2 102 80,90,90,80 Name3 102 90,80,90,80,90 ; run; The marks column have values in comma separated way like 70,80,90 i.e math, eng, Hindi right but observation 2 for marks have 4 values comma separated 80,90,90,80 i.e math, eng, Hindi, some other subject so basically what is want to do is I want to get each comma separated value in their respective column the catch is that we don't know how many values will be there in the Marks column it is dynamic it could be 3 or 4 or 5 I wan to use loop & scan or substr but I'm confused if you could please make a video or give an explanation on this
@kiranvenna
3 жыл бұрын
I thought this video does that
@nithingowda1678
Ай бұрын
how to extract the value of the maximum count sir ??
@kiranvenna
Ай бұрын
Please provide simple input and output, i can help you
@seminvikram6544
3 жыл бұрын
hello how to split one column into many
@kiranvenna
3 жыл бұрын
unfortunately, I am unable to understand, can you give an example
Пікірлер: 27