Hi, I am not from Clinical SAS.

one way to handle this by using a simple macro variable as shown below. data words_in_string_not_sorted; length before_sort $40; before_sort="sat rat bat cat mat eat"; output; run; proc sql; select max(countw(before_sort)) into :varnums from words_in_string_not_sorted; /* code to sort words in a String in SAS*/ data words_in_string_sorted; set words_in_string_not_sorted; final_var= cats ('col', countw(before_sort)); array col(&varnums) $ _temporary_ ; /* creates col1 col2 col3 col4 col5 col6 temporary elements*/ /* scanning and extracting each value and assigning to each variable*/ do i=1 to countw(before_sort); col{i}=scan(before_sort, i, " "); end; call sortc(of col(*)); after_sort=catx(' ', of col{*}); drop i; run;

@@kiranvenna thanks for the reply, got it now 👍🏻

I have made lot of videos on Proc SQL including a proc sql tutorial which is 3:30 hrs long check it out. kzbin.info/www/bejne/nXzYpJKVh5d8aNU

Let me see but in below mentioned video I use call sort a particular call routine which is helpful to solve a problem. kzbin.info/www/bejne/bomTgaOqhLuggrs

@@kiranvenna sure thanks

Your answer was correct

you can always use a=1 to a, a=0 to not a but you can also do from if (a=1 and b=1) and salary=updated_salary then flag='No change'; if a=1 and b=0 then flag='No change'; to if ((a=1 and b=1) and salary=updated_salary) or ( a=1 and b=0) then flag='No change';

@@kiranvenna got it.. thankyou 😀

what should be output?

You have sas on demand for analytics, which is free for everyone.

@@kiranvenna i want clinical sas software

Thanks for kind comments. Usually I tried to give a link for sample data and code in my github repo, but I forgot for this one. Code and sample dataset discussed in this video is available at below link. I have also this github link in description now. github.com/kiranvenna/KZbinproblems_code/blob/master/consequtive_day_vid.sas

Can you paste the sample data here. I can check that.

Hi, Not sure what exactly what you would like to achieve.

How are you reading excel data.

​@@kiranvennaindividual excel import in sas and with same header and format...then I use your query to combine... But still data is truncated basis on first table...

I have not see when a particular error or warning in multiple lines. for example WARNING: Multiple lengths were specified for the variable var by input data set(s). This can cause truncation of data. All of above warning is one line. If you find anything which has multiple lines then let me know.

Please provide simple input and output, i can help you

Pick the length of variable where it is max. Avoid datastep and use Proc SQL (if possible) whenever you cannot max length of variable.

@@kiranvenna thanks much ❤️

Hi, I did not completely understand your question.

I am asking that if the loglines are there how it will merge... Please

you can SAS on demand for academics for free. It is free for everyone. www.sas.com/en_ca/software/on-demand-for-academics.html

please contact us at [email protected].

check this playlist, this has some interview based question and answers. kzbin.info/www/bejne/f4S9ZXqca8Sbmrc

Thank you for letting me know. Now fixed it.

Thank you Sir

Please checkout this video. kzbin.info/www/bejne/hJLOdKCaiNB6oMk

@@kiranvenna 🙏🙏

Please give me a sample input and output.

In proc means nmiss number of missing values for each variable. In our example we are trying to find missing values by observation.

Sure. few more are coming soon.

I did not delete your comment. Why would I will delete your comment. In fact always love your comments. Please feel to comment anything. Not sure what you commented earlier, please feel free to comment. In fact if you have an idea, I would love it.

Thank you