Say y = %scan(&list, &k., ",")   Now if you need character output in double quotes, you just need to make the following change:   y = "%scan(&list, &k., ",")"   Also use %scan in a loop only   ... View more

There is no KEYS window in SAS Studio as function keys are not customisable. ... View more

Depends on which version of Windows your are using. Try asking SAS Support. Technical Support Form ... View more

Hi: That's probably a question for Tech Support. This note http://support.sas.com/kb/7/816.html has 3 other references to more notes about this same error. cynthia ... View more

Thank you, Ksharp and DanielSantos! Very helpful! ... View more

Hi Art, Thank you. I just focused on “convert char to num for all _CHARACTER_”. ... View more

While DOW loops are a construct that can be beneficial, and can be faster (especially if your data are already sorted), the programming can easily get to be a lot more complex than what you are currently doing and, as a result, the likelihood of your producing erroneous results can increase significantly. Yes, SQL can be slow with large files (although that has improved quite a bit with recent SAS versions), but quite easy to code.  If you are looking for faster processing, and don't want to risk errors due to faulty programming, I would compare proc summary with proc sql for what you are doing. ... View more

it all seems like too much work! just embed the 3 (rolling period) element array and the stats derivations in a per-variable macro like %Macro stats( var, period=3, idx= idx ) ; Array ar__&var( &period ) ; Ar__&var( &idx ) = &var ; Mn_&var = mean( of ar__&var(*) ) ; St_&var = STD( of ar__&var(*) ) ; %mend stats ; Using this macro depends on having the data sorted in PEMNO order. If there might be gaps in the data these need to be filled with some default which might be missing. Given these conditions in the original data then the process would be this short step Data want ; Do row = 1 by 1 until( last.PEMNO ) ; Set original ; BY PEMNO; Idx = 1+ mod( row, 3 ); %stats( ret ) ; Output ; end ; run; Needs a by statement! Message was edited by: Peter.C ... View more

Thanks, Pattrick, for help. I'd read the book on Output several times, and didn't quite really catch the idea until I've read your code! I just couldn't think of using Output right after the MOD function. Yesterday I found a macro from a university for this rolling, and the macro was far, far complicated than yours. Basically, they used Proc Means for each 3-month and 9-month interval, then output the datasets, then use Proc Append to concatenate all datasets, and for the same thing it has at leas 5 SAS programs. Thanks so much and I've learnt a lot from your codes. Message was edited by: smilingmelbourne ... View more

I missed the file extension for the SAS dataset, so I didn't work. It should have been........ data _null_; call system('gzip /temp/myname/something.sas7bdat'); /*Add file extension "sas7bdat and it works"*/ run; ... View more