data want; X= 'asadsfa'; x1=compress(x,'a'); run; ... View more

I have found that the first step to doing mastery in SAS is to have a computer with SAS installed on it.  Do you have that?  What SAS product(s) are installed? ... View more

@Best Another one although I like the previous one(personal preference)    data springgrads; infile cards truncover ; informat students $15. concentration $15.; input @; GPA=input(scan(_infile_,-1,' '),8.); _infile_=substr(_infile_,1 ,anydigit(_infile_)-1); input students concentration & ; cards; Johnson,Allison Biochemistry 2.56 Davis,jeffrey General Biology 3.91 Hall,Baniel Genetics 3.43 Hill,Courtney Ecology 4.00 Scott,Tiffany plan Biology 2.56 Martines,Terasa zoology 3.21 ; run;   ... View more

@Best wrote: Hi, I have two questions to ask. 1 is there any alternative if firstdot and last dot? Not using group by in proc sql 2 How can we transpose a data set without using Proc transpose? 1) A concrete example of what you are attempting would help. Some techniques might work for some cases but not others because this is very likely to be very dependent on data and result needed.   2) A data step relatively easy will transpose from wide to long data have; input a $5. var1 var2 var3; cards; 19701 8798 123 456 19701 5489 789 333 18054 3578 908 222 ; Run; data trans; set have; array v var1-var3; do i= 1 to dim(v); tranval= v[i]; output; end; keep a tranval; run; from long to wide takes a few more steps to determine max number of resulting variables, create the appropriate variable names, Retain statement and conditional output.   ... View more

@Best wrote: Can someone help me understand the difference between missover, trunover, flowover and pad with example? Maxim 1: read the documentation. All these options are covered in-depth in the documentation of the infile statement. ... View more