See http://www.sascommunity.org/wiki/Split_Data_into_Subsets Be sure to notice the advisory against doing this. skallamp wrote: Hi, Could you please help me to split the data in to multiple data sets based on the Year and month. For e.g My input data contains two year data, I want to split it in to 24 small data sets based on the month and year. I used the below query to get month and year. data set claim_file informat x_date date8. format x_date date8. M = month(x_date) Y = year(x_date) run Out put should have a data set name like Jan_2011, Feb_2011 etc.. Please help. Thanks. ... View more

I don't know what the intended usage is, but if it's to generate suitable variable names in PROC MEANS, the OUTPUT statement's AUTONAME option does this for you. jbonito wrote: Hi, I have string variable which is an input to a macro.  It's a variable list that looks like so: (var1 var2 var3).  I need to create another string variable that appends text to each of those variable names, for example (var1_mean var2_mean var3_mean).  Seems I should be able to make a version of the following work, but not having success with the concatenating: vars=(var1 var2 var3); %let meanlist =;  %let items = %sysfunc(countw(&vars)); %do i = 1 %to &items;                %let word = %qscan(&vars,&i,%str( ));         %let meantemp = input ("&word._Mean", 8.1);                %let &meanlist = input ("&meanlist.&meantemp",8.1); %end;  It's that last %let statement that's not working.  SAS says the equals sign is out of order.  Thanks in advance for your help. Joe ... View more

See http://www.sascommunity.org/wiki/Generating_Holiday_Lists Reeza wrote: What about holidays? You could do something like the following to double check but someone might have a more sleek answer using a custom interval and intck. The following may also need to be adjusted by 1 depending on if you're including the boundary dates or not. data my_data;   set my_data;    date=datepart(Trade_date_time);   exp_date= '22-SEP-2011'd;   weeks_left= week(exp_date)-week(date);   time_left = exp_date-date;   time_left_adj = exp_date-date-(2*weeks_left); time_left_check=0; do i=date to exp_date;      if weekday(i) not in (1, 7) then time_left_check+1; end; run; ... View more

It's not an automatic variable. It is a SAS Variable List. http://support.sas.com/documentation/cdl/en/lrcon/62753/HTML/default/viewer.htm#p0wphcpsfgx6o7n1sjtqzizp1n39.htm sambasiva.ravuri@tcs.com wrote: Hello Ksharp, Codes are worked very well and i really appreciate for your help. If you don't mind, what is the significance of "_numeric_ "  Automatic variable which you used in the code ? Can you please share if you have a list of Automatic variables in SAS with explanations and that will be really helpful going forward. Regards, S Ravuri. ... View more

Here's a variation using CATS rather than NMISS. data check ; input v1 - v5 ; cards ; 1 2 3 4 5 ; data look ;   set check ;   cats1 = cats(of v1 - v5  ) ;   cats2 = cats(of _numeric_) ; run ; Both new variables receive the value 12345, but CATS1 is character while CATS2 is numeric. I explain in my SESUG paper Using SAS® Variable Lists Effectively (pp. 14-15). ... View more

Consider the EXCEPT operator in PROC SQL. ... View more

A DATA step with a MODIFY statement would also preserve the index. Rah should understand that the DATA TEST; SET TEST; construct does not change an existing table. Rather it creates a new table which replaces the pre-existing one. ... View more

I think you need %SYSFUNC, as in data have ; myvar = 0 ; run ; data want ; set have(rename=(myvar=%sysfunc(upcase(myvar)))); put _all_ ; run; ... View more

It's documented (http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p1bk7i6jqseje7n1lifcip8kzhpp.htm😞 "Outer joins are inner joins that have been augmented with rows that did not match with any row from the other table in the join.". ... View more

The stored LENGTH of a numeric variable is pretty much independent of the number of decimal digits in its formatted representation. You apparently used a LENGTH statement to override the default stored length of 8. Don't do that. Note: Advice is different for a character variable. ... View more