About rhapsody

rhapsody · ‎10-21-2019

Yes

rhapsody · ‎10-21-2019

Done! I've edited the question

rhapsody · ‎10-21-2019

Is there a way to use proc ttest and use a column of null hypothesis? The simple proc ttest looks like this proc ttest h0=80 sides=u alpha=0.1 data=temp_table; var time_series1 time_series2; run; Instead of having h0=80 is there a way to take a column of h0 rows? h0 80 120 150 90 70 60

rhapsody · ‎08-13-2019

data prediction_&number_name_conv.; set raw_data; run;

rhapsody · ‎08-13-2019

I have a string called number_name='1','18','19';. What I want in the end is for that number variable to end up in the name of my final dataset (prediction_&number_name_conv.) . All of this is summarized in the example below. %let number_name='1','18','19'; data _null_; call symput('number_name_conv', trim(left(input("&number_name.", comma10.)))); run; data prediction_&number_name_conv.; set raw_data; run;

rhapsody · ‎06-20-2019

Sorry, but I made a small typing error, for the 10 months example (the 10 should be easily changed if required in the code) the results looks like this. The resulting table id1 id2 date value 7899 11774 31MAR2010 10 7899 11774 30APR2010 20 7899 11774 31MAY2010 20 7899 11774 30JUN2010 40 7899 11774 31JUL2010 40 7899 11774 31AUG2010 60 7899 11774 30SEP2010 60 7899 11774 31OKT2010 60 7899 11774 30NOV2010 60 7899 11774 31DEC2010 60 8110 45987 31DEC2010 100 8110 45987 31JAN2011 100 8110 45987 28FEB2011 100 8110 45987 31MAR2011 100 8110 45987 30APR2011 100 8110 45987 31MAY2011 100 8110 45987 30JUN2011 100 8110 45987 31JUL2011 100 8110 45987 31AUG2011 100 8110 45987 30SEP2011 100

rhapsody · ‎06-20-2019

Almost but I suppose I wasn't clear about one important thing. I want to be able to set how many time periods to extrapolate. I wrote in my example 10 months. But this I want to be able to change to let's say 20, 40 or whatever. So for the 10 month example, the result should look like this. The have table I have table with many id1 and id2 pairs id1 id2 date value 7899 11774 31MAR2010 10 7899 11774 30APR2010 20 7899 11774 30JUN2010 40 7899 11774 31AUG2010 60 8110 45987 31DEC2010 100 The resulting table id1 id2 date value 7899 11774 31MAR2010 10 7899 11774 30APR2010 20 7899 11774 31MAY2010 20 7899 11774 30JUN2010 40 7899 11774 31JUL2010 40 7899 11774 31AUG2010 60 7899 11774 30SEP2010 60 7899 11774 31OKT2010 60 7899 11774 30NOV2010 60 7899 11774 31DEC2010 60 8110 45987 31DEC2010 100 8110 45987 31JAN2011 100 8110 45987 28FEB2011 100 8110 45987 31MAR2011 100 8110 45987 30APR2011 100 8110 45987 31MAY2011 100 8110 45987 30JUN2011 100 8110 45987 31JUL2011 100 8110 45987 31AUG2011 100 8110 45987 30SEP2011 100

rhapsody · ‎06-19-2019

I have table with many id1 and id2 pairs id1 id2 date value 7899 11774 31MAR2010 10 7899 11774 30APR2010 20 7899 11774 30JUN2010 40 7899 11774 31AUG2010 60 8110 45987 31DEC2010 100 ...... Then I want to add 10 months for every id1 and id2 pair from the starting date and on. If a value is missing I want it to use the previous months value. The resulting table will then look like this. id1 id2 date value 7899 11774 31MAR2010 10 7899 11774 30APR2010 20 7899 11774 31MAY2010 20 7899 11774 30JUN2010 40 7899 11774 31JUL2010 40 7899 11774 31AUG2010 60 7899 11774 30SEP2010 60 7899 11774 31OKT2010 60 7899 11774 30NOV2010 60 7899 11774 31DEC2010 60 8110 45987 31DEC2010 100 8110 45987 31JAN2011 100 8110 45987 28FEB2011 100 8110 45987 31MAR2011 100 8110 45987 30APR2011 100 8110 45987 31MAY2011 100 8110 45987 30JUN2011 100 8110 45987 31JUL2011 100 8110 45987 31AUG2011 100 8110 45987 30SEP2011 100 Ideas how to do this?

rhapsody · ‎04-23-2019

This is what I have libname tables "c:\Data"; In the libname "tables" I have many tables looking like this (this is just part of all the tables, there are at least a 100 more with the same name format) result_201103_credit result_201106_credit result_201109_credit result_201112_credit result_201903_credit I want to write a sas code that extracts the latest date and turns it into a macro variable. So when I write %put &date.; it returns 201903

rhapsody · ‎04-09-2019

I have the following code %let date=31MAR2019; data _null_; date_var="&date."d; format date_var date9.; month_name=put(date_var, monname.); call symputx('month_name',month_name); run; %put &month_name; This generates the the month name March. But I want the month name in Swedish, which is Mars Anyone knows how to do this?

rhapsody · ‎03-11-2019

I wanna open the Excel file "January_Alex..xlsx". I'm using the following code %let name=Alex; x '"C:\Folder\January_&name..xlsx" '; But the problem is that SAS doesn't understand that "&name" is a macrovariable. I get the error message "Windows cannot find 'C:\Folder\January_&name..xlsx'. Make sure you typed the name correctly, and then try again" Any ideas how to fix it?

rhapsody · ‎02-19-2019

Hello! Sorry. It works now. and I just accepted your solution. Thank you very much 🙂

rhapsody · ‎02-19-2019

I just ran your code again. I've attached an exact copy of that code to show you. It's this one data have; input theta1-theta3; datalines; 0.2 0.5 0 0.3 0.6 0.023 0.5 0.1 0.05 0.7 0.2 0.01 ; run; options cmplib = work.cmpar; %let rc = %sysfunc(array2array(have, want)); Then I get the foloowing message in the log 1 data have; 2 input theta1-theta3; 3 datalines; NOTE: The data set WORK.HAVE has 4 observations and 3 variables. NOTE: Compressing data set WORK.HAVE increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.00 seconds 　 8 ; 9 run; 10 11 options cmplib = work.cmpar; 12 13 %let rc = %sysfunc(array2array(have, want)); WARNING: No CMP or C functions found in library work.cmpar. ERROR: The ARRAY2ARRAY function referenced in the %SYSFUNC or %QSYSFUNC macro function is not found. WARNING: Argument 2 to function PUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.

rhapsody · ‎02-14-2019

When I run your code I get the error ERROR: Unable to open data set "WORK.have" in function READ_ARRAY. ERROR: Second parameter passed to DYNAMIC_ARRAY must be a positive number. ERROR: Error reported in function 'READ_ARRAY' in statement number 3 at line 8 column 1. The statement was: 0 (8:1) rc = READ_ARRAY( inds="have", theta=(ndim=1, dim1=1 [.,...]) ) ERROR: An illegal argument is used in the function call in statement number 5 at line 10 column 1. The statement was: 0 (10:1) cols = DIM2( theta=(ndim=1, dim1=1 [.,...]) ) ERROR: A TO value is missing in the DO statement in statement number 8 at line 13 column 1. The statement was: 0 (13:1) do j = 1 to cols - 1; INFO: Created Data Set want with 1 Rows and . Cols. WARNING: Argument 2 to function PUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.

rhapsody · ‎02-14-2019

I suppose the last lines are not complete? options cmplib = work.cmpar; %let rc = array2array(have, want); They should be written in a datastep or something? All you do now is defining a macro variable using the %let statement

Online Status	Offline
Date Last Visited	‎03-27-2024 01:54 PM

Re: proc ttest

Re: proc ttest

proc ttest

Re: Convert a string into a dataset name

Convert a string into a dataset name

Re: Use previous value if the date is missing

Re: Use previous value if the date is missing

Use previous value if the date is missing

Find the table whose name has the latest date

Change a date variable to Swedish

Re: proc ttest

Re: proc ttest

proc ttest

Re: Convert a string into a dataset name

Convert a string into a dataset name

Re: Use previous value if the date is missing

Re: Use previous value if the date is missing

Use previous value if the date is missing

Find the table whose name has the latest date

Change a date variable to Swedish

Macroname in file name

Re: use Array in a proc fcmp function

Re: use Array in a proc fcmp function

Re: use Array in a proc fcmp function

Re: use Array in a proc fcmp function