About Junyong

Junyong · ‎03-28-2023

Thanks—I tend to code Command Prompt and pipe directly for readability. It seems that, according to your filevar suggestion, this ampersand resolution issue, unlike others, cannot be addressed by %str , %quote , or %superq families.

Junyong · ‎03-28-2023

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?

Junyong · ‎11-11-2022

In the following sgplot , can I just italicize Yahoo Finance in footnote so that it can be Source: Yahoo Finance for example? Here is the working snippet. filename SNP500 url 'https://query1.finance.yahoo.com/v7/finance/download/%5EGSPC?period1=-1388534400&period2=1767225599'; proc import file=SNP500 dbms=csv replace out=SNP500; run; ods results=off; ods listing gpath='!USERPROFILE\Desktop\'; ods graphics/reset imagename='SNP500'; title 'S&P 500 Index'; footnote 'Source: Yahoo Finance'; proc sgplot; series x=date y=close; yaxis type=log; run; Thanks for your help!

Junyong · ‎11-09-2022

Does xaxis or yaxis have something similar to arrowheadpos for series ? I want to apply the arrow tips for axes per se as follows: Many thanks for your help again.

Junyong · ‎11-09-2022

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!

Junyong · ‎11-07-2022

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!

Junyong · ‎11-04-2022

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!

Junyong · ‎07-13-2022

The following data have both tabs (delimiters) and spaces (not delimiters). I tried EXPANDTABS with a colon in INPUT as follows: data international_stock_exchanges; infile cards expandtabs truncover; input EXCHGCD EXCHGDESC :$80. Country $80.; cards; 0 Subsidiary/Private Canada 0 Subsidiary/Private United States 1 Non-traded Company or Security Canada 1 Non-traded Company or Security Germany 1 Non-traded Company or Security Switzerland 1 Non-traded Company or Security Taiwan 1 Non-traded Company or Security United States 2 Consolidated Parent or Tracking Stock Company United States 3 Leveraged Buyout United States 4 Additional Company Record-PreSFAS 94, ProForma, PreAmended United States ; However, this colon made the second variable EXCHGDESC skip also at spaces as well as tabs as follows: How can I correctly use these tabs and spaces as delimiters and strings, respectively?

Junyong · ‎04-25-2022

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?

Junyong · ‎11-08-2021

So it seems ε02=OLS MSE and h0=(ARCH0+ARCH1*MSE)/(1-GARCH0) in autoreg . %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"; proc import file=mcd dbms=csv replace out=mcd; run; proc expand out=mcd; id date; convert adj_close=return/tout=(pctdif); run; ods select none; ods results=off; proc autoreg; model return=/garch=(q=1,p=1); output ht=variance out=mcd; ods output fitsummary=fit parameterestimates=para; run; ods results=on; ods select all; data _null_; set fit; if _n_=2 then call symput('mse',nvalue1); run; data _null_; set para; if _n_=3 then call symput('arch0',estimate); else if _n_=4 then call symput('arch1',estimate); else if _n_=5 then call symput('garch1',estimate); run; data _null_; set mcd; if _n_=2 then call symput('variance',variance); run; %put %sysevalf((&arch0+&arch1*&mse)/(1-&garch1)); %put &variance; (1) Is there a reference for the formulation used for h0? (2) Is this stated in the guide?

Junyong · ‎11-02-2021

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.

Junyong · ‎11-01-2021

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.

Junyong · ‎10-08-2021

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.

Junyong · ‎10-07-2021

I'm trying to scrape webpages. The following minimum example collects the HREFs and titles of current Latest Post items from a SAS Support Communities homepage. data _null_; infile "https://communities.sas.com/" url truncover; input; _infile_=strip(tranwrd(_infile_,"09"x,"")); if _infile_="" then i+1; else if _infile_="" then i+-1; file "!userprofile\desktop\page.htm"; if _infile_^="" & i then put _infile_; run; data page; infile "!userprofile\desktop\page.htm" dlm='"' truncover; input @; if _infile_=:'<a class="p' then do; input @'href="' href :$160.; input title :$160.; end; run; I'd like to give more detailed directions as the data aren't readily available.

Junyong · ‎10-07-2021

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 :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="results 2016" new york etc="jimmy" name='canada' value="12345" title="yearly statistics" toronto etc="dawn" name='japan' value="1234567" title="annual bulletin" osaka 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 :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="results 2016" new york etc="jimmy" name='canada' value="12345" title="yearly statistics" toronto etc="dawn" name='japan' value="1234567" title="annual bulletin" osaka 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="" truncover; input @"name='" name :$16. @'value="' value :$16. @'title="' title :$32. @"" span :$16. @'etc="' etc :$16.; cards; name='united states' value="123456" title="results 2016" new york etc="jimmy" name='canada' value="12345" title="yearly statistics" toronto etc="dawn" name='japan' value="1234567" title="annual bulletin" osaka 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)?

Online Status	Offline
Date Last Visited	‎05-05-2024 01:30 AM

Re: How to Prevent Resolution of Ampersand?

How to Prevent Resolution of Ampersand?

How to Italicize Just One Word in FOOTNOTE?

Re: Applying Arrow Tips to SGPLOT Lines and Axes

Applying Arrow Tips to SGPLOT Lines and Axes

Displaying Values for Histograms

SGPLOT VBAR XAXIS Label Interval?

Reading Tab-Delimited Data with Spaces

FILENAME FTP PROMPT in SAS OnDemand

Re: What Unconditional Variance Does AUTOREG Use?

Re: In VIEWTABLE, How Can I Directly Go to Certain Observation?

In VIEWTABLE, How Can I Directly Go to Certain Observation?

DO Loop and INFILE FILEVAR Together

Re: How to Download a Folder from SAS OnDemand?

Re: Skipping Invalid Lines