About archcnu

archcnu · ‎02-05-2015

I would suggest SAS published books are the best source for learning SAS and advanced SAS skills. There are good examples cited in these books that are tricky enough. Personally I have been through these books and also cleared my SAS Base Certification last Tuesday. Though you can also find some stuff using Google, I would still prefer SAS books to get a good understanding on SAS. https://communities.sas.com is also a very good source for understanding real world problems that are posted on this site and gaining skills.

archcnu · ‎01-29-2015

prxchange('s/_/ /i',-1,str); The value i indicates to ignore the case of the character in the expression. For this particular example i can be ignored. The value -1 indicates that the matching pattern replacement should happen till the end of string is reached. If 1 is used the replacement ends when the first match is found.

archcnu · ‎01-29-2015

If you are looking just to return the row number or the observation number then use SAS automatic variable _N_ thats holds the observation number of the observation read. data test; input id x y; if x=21 then do rowno=_n_; /* rowno holds the observation number*/ y = 8; /* control is on the current observation */ end; cards; 1 10 2 2 15 3 3 21 6 4 7 15 ; run;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Please let me know,most helpful blogs/communities/sites that are a...

Re: Replacing '_' with ' '(Spaces)

Re: how to get row number /observation number

Re: how to get row number /observation number

Re: Please let me know,most helpful blogs/communities/sites that are a...

Re: Please let me know,most helpful blogs/communities/sites that are a...

Re: Replacing '_' with ' '(Spaces)

Re: how to get row number /observation number