we need to flag as yes for 3 or more consecutive values. but in my logic if i have 2 consecutive values also it is flagging yes but i do not want flag as yes if i have only 2 consecutives.
... View more
Hey sorry for the inconvenience, those are secret libraries. So we don't have path with us. those libraries configured in auto.exe files. we are using directly.
... View more
klength product $20.; /* it is throwing error*/ data d; set milk.app; asd=klength(product); /* it will give the length of the prodcut variable */ run; I was tried but the statement is throwing error and it is used out of order. any other suggestions.
... View more
I do not have the permanent path details with me to use the cvp. please let me know the alternate way of the cvp engine instead of libanme.
... View more
Hi Team, I'm reading a permanent dataset but values are truncating for a specific column. Even after applying length or format or informat statements in SAS viya. data abc; set milk.apps; run; milk.apps having product column and it contains length 20. product column contains value "mástan o' valishaikka" in ABC product column contains "mástan o' valishaikk". may I know how sas reading special values? Only truncating last character value in each record.
... View more
Hi Anand, we are using reflection to access the SAS and we are able to access Oracle db by using toad or sql developer. But using SAS only we are facing the attached issue. Here surprising thing is where the required things regarding db related information paths we do not know exactly. Please assist me on this issue
... View more
In the above code you gave like do i=1 to 6 ; code=catx('||',code,cats('strip(col',i,')')); end; you enter manually but i need like do i=1 to &cnt ; code=catx('||',code,cats('strip(col',i,')')); end; How to find out total number of variables in a dataset?
... View more
