in data step   The following will create a new variable newvar based on myvar and drop myvar   data newtable(drop = myvar);    length newvar %5;    set table;    if myvar = N then newvar = No    if myvar = Y then newvar = Yes run; How can I replicate this in SAS proc sql?   ... View more

I have this routine whereby I need to analyze data from the server.   However, I find that doing the analysis locally is much more pleasant than using the server.   What's the best way to download the a sas data to a local folder?   *connection to server; rsubmit; proc sql; create table tolocal as select * from servertable where <conditions> ;quit; endrsubmit; * tolocal is now in Rwork; *define local folder on desktop; libname mylocal "C:\Users\Working folder"; *download data to mylocal; data mylocal.tolocal; set rwork.tolocal;run; Is it possible to do everything within rsubmit? It seems that I can't define the local folder within rsubmit.. ... View more

proc sql; select month(transdate) from table; quit; Above gives me the month in numeric i.e 1 2 3 4 etc I want to convert these numbers to Jan Feb Mar Apr respectively.   Is there any function in proc sql allowing this? ... View more

  /*Append all table*/ data spay.contactless; set usage transactions active ratio; run; all the 5 tables above has a variable _NAME_. However when I append them by row as above, the variable _NAME_ has truncated values. How can I redefine the length for _NAME_? Or how can I create another variable as below? /*Combine for Contactless Table*/ data spay.contactless; input new_NAME_ $20; set spay.usage spay.transactions spay.active spay.ratio; new_NAME_ = _NAME_; *copy _NAME_ to new_NAME_; run; ... View more