Hi I have a test data with missing values and I want to fill the table by taking previous month's value. Test data month A B C Jan 1 2 3.3 Feb 4 . 56 Mar 3 . . Apr 5 3 4 May . 6 2 data I want to have month A B C Jan 1 2 3.3 Feb 4 2 56 Mar 3 2 56 Apr 5 3 4 May 5 6 2 Here's the code I wrote, but it gives me the exact original table with missing data and I do not get an error message in the log. I wonder why the lagged values are not applied according to my if statement logic.. I appreciate if someone could help me shed a light on this. data test; input month $ A B C; datalines; Jan 1 2 3.3 Feb 4 . 56 Mar 3 . . Apr 5 3 4 May . 6 2 ; run; data no_missing(drop=i); set test; array ticker(*)A--C; do i=1 to dim(ticker); if ticker{i}=. then ticker{i}=lag(ticker{i}); else ticker{i}=ticker{i}; end; run; ... View more

Hi I was trying to find an example code to draw a horizontal chart like below. I know how to write a code if there was only series 1, but I could not find any sample code online if there were multiple series 1,2,3,...5 It would be greatly appreciated if someone can let me know a sample code so I can learn from it. Thanks! ... View more

Hi I was wondering if there is a way to remove a page title and keep graph titles in SAS when I create a PDF file containing several graphs. I tried several different no title options in SAS, but they did not work.. If you run below code, you'll get a title of "title 4" in the second page and then you also get "title 4" for the graph itself. I want to remove this page title or at least separately specify a page title from the graph titles. Additionally, I know that I could use inset statement to avoid this problem, but I was wondering if we can separately specify page/graph titles or remove page titles all together.. data mydata;     var1=1;     var2=2; run; %macro pic; %do i=1 %to 6; proc sgplot data=mydata;     title "Title &i";     vbar var1 / response=var2; run; %end; %mend; ods pdf file = "C:\temp\test.pdf" STARTPAGE=NEVER style=SASweb; ods noproctitle; %pic; ods pdf close; ... View more

Hi I am having trouble importing xls files contained in Zip files and below is the code. Below code up to downloading the Zip file should be fine as I was following instructions from SAS blog and I was able to import txt files successfully. but I'm not sure how to do the same with xls files contained in a Zip, so if anyone knows how to do this, I really appreciate your help. The error msg I got is below and I think I need to specify xls file name contained in the Zip because I only specified zip file location, but I could not find similar example online and I'm not sure how to specify this. ERROR: Physical file does not exist, C:\Users\datafile.zip.xls. /* detect proper delim for UNIX vs. Windows */ %let delim=%sysfunc(ifc(%eval(&sysscp. = WIN),\,/)); /* create a name for our downloaded ZIP */ %let ziploc = %sysfunc(getoption(work))&delim.datafile.zip; filename download "&ziploc"; /* Download the ZIP file from the Internet*/ proc http method='GET' url="http://www.philadelphiafed.org/research-and-data/real-time-center/business-conditions-index/ads_vintages.zip" out=download; run; /* Import an excel file directly from the ZIP */ PROC IMPORT OUT= WORK.test DATAFILE= "&ziploc" DBMS=xls REPLACE; GETNAMES=YES; DATAROW=2; RUN; ... View more

Hi I have monthly growth rates (Growth_A and Growth_B) and my aim is to create indicators(Index_A and Index_B) based on these growth rates. Index always starts with the value of "1" and then take the value of (previous month's index value)*(1+monthly growth rate) after the first month. For example, Index_A starts with 1 and then 1.2 after 20% growth. Then 1.2*(1+0.3) = 1.56 so on and so forth. Month Growth_A Growth_B Index_A Index_B Jan . . 1.00 . Feb 20% . 1.20 1.00 Mar 30% 10% 1.56 1.10 Apr -50% 30% 0.78 1.43 May 10% -5% 0.86 1.36 Here is the code I wrote, but I get missing values because the lag function somehow does not retain the value of "1" from the very 1st period. I tried with if..then..else statement and other ways of coding, but I get the same error because the lag function is not working. It would be great if someone could let me know other ways to code this multiplication based on previously calculated value. Data new; set have; Index_A=ifn(growth_A=".",1,(1+growth_A)*lag(index_A)); run; ... View more