I have an Excel file S&P 500_230328.xlsx  on my desktop and want to rename it as S&P 500_230329.xlsx  via infile pipe as follows:   data _null_; infile "ren %sysget(USERPROFILE)\Desktop\""S%nrstr(&)P 500_%sysfunc(putn(%sysfunc(today()),yymmddn6.))"".xlsx ""S%nrstr(&)P 500_%sysfunc(putn(%sysfunc(today())+1,yymmddn6.))"".xlsx" pipe; run;   The problem arises because SAS considers &P as a macro expression. I tried both %str() and %nrstr() for the ampersands above but failed (it seems %superq() doesn't work as well); I cannot use single quotes because of the date changes. How can I prevent WARNING: Apparent symbolic reference P not resolved. in this case? ... View more

Excel lines (blue) and axes (gray) can easily introduce arrow tips as follows: I tried to do this in SGPLOT but couldn't find LINEATTRS or something for these arrow tips. Are the arrow tips above also available for SGPLOT SERIES and axes? Here is a sample snippet. data work; do x=1 to 10; y+rannor(1); output; end; run; ods results=off; ods listing gpath='!userprofile\desktop'; ods graphics/reset noborder imagename='versionsas'; proc sgplot; series x=x y=y; run; Thanks for your help! ... View more

The following histogram uses the year labels of observations: Can I do something similar to this in SAS? Here is a non-labeled replication using SGPLOT HISTOGRAM. Here I attach the snippet; in addition, I also wonder if the vertical bars can be drawn not centered around tick marks but in between two tick marks. filename raw url 'https://query1.finance.yahoo.com/v7/finance/download/%5EGSPC?period1=-9999999999&period2=99999999999'; proc import file=raw dbms=csv replace out=raw; run; data return; set raw; year=year(date); data return; set return; by year; if last.year; return=adj_close/lag(adj_close)-1; run; ods results=off; ods listing gpath='!userprofile\desktop'; ods graphics/reset noborder imagename='Example'; proc sgplot; where 1926<=year<=2017; histogram return/binstart=-.8 binwidth=.1 nbins=17 scale=count; xaxis values=(-.8 to .9 by .1) label='Return'; run; Thanks for your help! ... View more

SGPLOT VBAR is drawing all the 50 bars needed, but can I just apply label intervals to the x-axis below so that it changes from 1, 2, 3, …, 48, 49, 50 to 5, 10, 15, …, 40, 45, 50, for example? data SAMPLE; call streaminit(1); do X=1 to 50; do ITERATION=1 to 50; Y=rand('normal',X,X); output; end; end; run; ods results=off; ods listing gpath='!userprofile\desktop\'; ods graphics/reset imagename='SGPLOT'; proc sgplot; vbar X/response=Y stat=mean limits=both; run; Thanks for your help! ... View more

I was uploading a file via FTP using the following code: %put %sysfunc(dlgcdir(!userprofile\desktop)); filename original 'original.txt'; filename copy ftp 'copy.txt' host='my.address.com' user='myusername' prompt passive debug; data _null_; infile original; input; file copy; put _infile_; run; And I found that the PROMPT above is impossible in SAS OnDemand; I checked that only PASS works there. Is the PWENCODE-PASS combination the only way in SAS OnDemand? Or is there any other way to keep PROMPT here? ... View more

The current post relocates the previous post. The following code (1) downloads McDonald's stock prices from July 5, 1966 to November 1, 2021, (2) computes its percent returns, and (3) estimates the GARCH(1,1) model. /*-----------------------------------------------------------------------------+ | set filename using url=ticker, period1=start, period2=end | +-----------------------------------------------------------------------------*/ %let url=https://query1.finance.yahoo.com/v7/finance/download/mcd; %let period1=%sysevalf('5jul1966:0:0:0'dt-3653*24*60*60); %let period2=%sysevalf('1nov2021:23:59:59'dt-3653*24*60*60); filename mcd url "&url?period1=&period1%str(&)period2=&period2"; /*-----------------------------------------------------------------------------+ | download daily mcdonalds data from yahoo | +-----------------------------------------------------------------------------*/ proc import file=mcd dbms=csv replace out=mcd; run; /*-----------------------------------------------------------------------------+ | compute returns using prices | +-----------------------------------------------------------------------------*/ proc expand out=mcd; id date; convert adj_close=return/tout=(pctdif); run; /*-----------------------------------------------------------------------------+ | run garch(1,1) using autoreg | +------------------------------------------------------------------------------+ | the results are r(t)=0.0832+e(t) and | | h(t)=0.009160+0.0485*e(t)^2+0.9539*h(t-1) | | as ARCH1+GARCH1=0.0485+0.9539=1.0024>1, there is no unconditional variance | +------------------------------------------------------------------------------+ | however, sas assigns h(1)=3.8592544106 to the jul 6, 1966 observation | | where does this number come from? this is not ARCH0/(1-ARCH1-GARCH1)! | +-----------------------------------------------------------------------------*/ proc autoreg; model return=/garch=(q=1,p=1); output ht=variance out=mcd; run; Because ARCH1+GARCH1=0.0485+0.9539=1.0024>1, the unconditional variance is undefined. However, the output data set assigns 3.8592488163 as the variance of the first observation—how does AUTOREG compute this value of 3.8592488163 here? It seems this is not documented in The AUTOREG Procedure. ... View more

The following code (1) downloads McDonald's stock prices from July 5, 1966 to November 1, 2021, (2) computes its percent returns, and (3) estimates the GARCH(1,1) model. filename mcd url 'https://query1.finance.yahoo.com/v7/finance/download/ mcd?period1=-999999999&period2=9999999999'; proc import file=mcd dbms=csv replace out=mcd; run; proc expand out=mcd; id date; convert adj_close=return/tout=(pctdif); run; proc autoreg; model return=/garch=(q=1,p=1); output ht=variance out=mcd; run; Because ARCH1+GARCH1=0.0485+0.9539=1.0024>1, the unconditional variance is undefined. However, the output data set assigns 3.8592488163 as the variance of the first observation—how does AUTOREG compute this value of 3.8592488163 here? It seems this is not documented in The AUTOREG Procedure. ... View more

A SAS Communities page can be easily read as follows: data page(compress=char); do i=1 to 1; address=cats("https://communities.sas.com/t5/forums/recentpostspage/post-type/thread/page/",i); infile dummy url filevar=address truncover end=j; do until(j); input page $32767.; output; end; end; run; However, the code becomes incorrect if I change DO I=1 TO 1; to DO I=1 TO 10; instead. data page(compress=char); do i=1 to 10; address=cats("https://communities.sas.com/t5/forums/recentpostspage/post-type/thread/page/",i); infile dummy url filevar=address truncover end=j; do until(j); input page $32767.; output; end; end; run; Can't I repeat INFILE FILEVAR inside DO loops? Though I know that the following code works correctly, I want to know where I'm misunderstanding. data page; do i=1 to 10; output; end; run; data page(compress=char); set page; address=cats("https://communities.sas.com/t5/forums/recentpostspage/post-type/thread/page/",i); infile dummy url filevar=address truncover end=j; do until(j); input page $32767.; output; end; run; Thanks. ... View more

Suppose I read the following data. /*SPAN is incorrectly read*/ data want1; infile cards dlm="'""" truncover; input @"name='" name :$16. @'value="' value :$16. @'title="' title :$32. @"<span>" span :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="<b>results 2016</b>" <span>new york</span> etc="jimmy" name='canada' value="12345" title="yearly statistics" <span>toronto</span> etc="dawn" name='japan' value="1234567" title="annual bulletin" <span>osaka</span> etc="fujita" ; Then SPAN will be read incorrectly. The problem is that I cannot include < because some other variables include it. /*cannot include < as other variables contain it*/ data want2; infile cards dlm="'""<" truncover; input @"name='" name :$16. @'value="' value :$16. @'title="' title :$32. @"<span>" span :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="<b>results 2016</b>" <span>new york</span> etc="jimmy" name='canada' value="12345" title="yearly statistics" <span>toronto</span> etc="dawn" name='japan' value="1234567" title="annual bulletin" <span>osaka</span> etc="fujita" ; Thus, including < in DLM will influence TITLE. Instead, I saw DLMSTR, which can handle multi-character delimiters as follows. The problem, however, is that it also affects characters in DLM, so the results are totally changed as follows. /*DLMSTR worsens this issue*/ data want3; infile cards dlm="'""" dlmstr="</span>" truncover; input @"name='" name :$16. @'value="' value :$16. @'title="' title :$32. @"<span>" span :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="<b>results 2016</b>" <span>new york</span> etc="jimmy" name='canada' value="12345" title="yearly statistics" <span>toronto</span> etc="dawn" name='japan' value="1234567" title="annual bulletin" <span>osaka</span> etc="fujita" ; In this case, can I control the ending point of SPAN via @ so that I can correctly read the strings inside (new york, toronto, and osaka)? ... View more