About vinayakraja

vinayakraja · ‎03-29-2016

Thanks for the solution.

vinayakraja · ‎03-29-2016

Thanks for the solution.

vinayakraja · ‎03-29-2016

The variable has long string and has to be divided into substrings and divided into columns of substrings. At the end we need to have total for each observation which has total for each populated coloumn. I hope i cleared it. Thanks for all the help.

vinayakraja · ‎03-28-2016

its not raw data file but a coloum with a string. and its substring are seprated by '/'. thanks again for all your help.

vinayakraja · ‎03-28-2016

thanks a lot. i will look into this. really Appericiate your help.

vinayakraja · ‎03-28-2016

thanks a lot. can you please help me understand. NUM=input(LONG_STRING, ?? $32.); I understand input function but can you please explain the role of "??". i have never used it.

vinayakraja · ‎03-28-2016

Thanks a lot for your reply. I have used scan function but the data just not contain 3 substring but multiple substring( shared just snapshot of data in image) . I am dealing with 100,000+ observations so I need to have something that can be dynamic. I have been thinking of using do while loop while putting substring function having '\' something similar. Can you please suggest ? Thanks again.

vinayakraja · ‎03-28-2016

Thanks a lot for your reply. I have used scan function but the data just not contain 3 substring but multiple substring( shared just snapshot of data in image) . I am dealing with 100,000+ observations so I need to have something that can be dynamic. I have been thinking of using do while loop while putting substring function having '\' something similar. Can you please suggest ? Thanks again.

vinayakraja · ‎03-28-2016

I have been trying to create columns in sas based on substring. I need to create a coloumn of each sub string stored in a column seprated by '\'. For example:- prexa\Medical Information\Medical Letters 02 is a single string stored in one column. i would like to have three columns col1: prexa col2 :Medical Information and Col3 : Medical. I am new to sas and have tried but unable to proceed. this column has numeric values with no sub string as well.

Online Status	Offline
Date Last Visited	‎12-01-2016 10:02 AM

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

How do we create column from string where '\' is used to separate the ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

Re: How do we create column from string where '\' is used to separate ...

How do we create column from string where '\' is used to separate the ...