Have a look at this code: data want; application_month = 201202; * convert numeric value to SAS Date ; appMonthDate = INPUT(PUT(application_month, 6.), yymmn6.); * convert SAS Date to formatted char string ; appMonthFormatted = put(appMonthDate, yymon7.); format appMonthDate date9.; run;
... View more
Hi Have a look at this sample code, it should give you a starting point. There are several functions that return information from a date like DAY, YEAR, MONTH, QTR etc. You can also use the PUT function together with a date format to get your char values %let fromDate = 01Jan2010; %let toDate = 31DEC2014; data want; length key 8; do date = "&fromDate"d to "&toDate"d; key + 1; RSA_WorkdayInd = ( 2 <= weekday(date) <= 6); WeekendInd = (not RSA_WorkdayInd); Calendar_Week_Number = week(date, "V"); DayOfWeek = put(date, downame3.); Fin_Year = year(intnx("year.7", date, 0)); output; end; format date date9. ; run;
... View more
Hi bollibompa See code sample below, it uses some techniques available since SAS9.2 where you can specify data sets lists and the INDSNAME= option on the SET statement. Bruno data data_2010 data_2011 data_2012 data_2013; do id = 1 to 5; source = char("ABCDEFG", id); output; end; run; data data_want; set data_2010 - data_2013 indsname=_dsname; length year $ 4; year = scan(_dsname, 2, "_"); run;
... View more
Hi Have a look at the code below. the first DATA Step creates some data according to what you mentioned. The second DATA Step reads the data from the text file using a semicolon as a delimiter for the firstname, lastname combination. The SCAN function then separates the two names. filename sugus temp; data _null_; file sugus; put "Sanjeev,Kuridi ;Ramesh ,varma;Rajesh,kumar"; run; data want; infile sugus dlm=";"; input fullName : $256. @@ ; length firstName $ 64 lastName $ 64 ; firstName = scan(fullName, 1, ","); lastName = scan(fullName, 2, ","); run; filename sugus clear;
... View more
Hi With proc report you can find out when a "group" begins, but there is no way to find out whether you are in the last line for a group. But you can use a DATA Step giving you this information. See sample code below. currently the report does print more columns than needed, but it will in understanding what is happening. data have; infile cards; input mon : 8. date : anydtdte. day : $ 8. x : 8. ; week = substr( put( date, weeku.), 1, 8); format date date9.; cards; 1 1/1/13 Tue 10 1 1/2/13 Wed 5 1 1/3/13 Thur 10 1 1/4/13 Fri 8 1 1/5/13 Sat 6 1 1/30/13 Wed 20 1 1/31/13 Thur 2 2 2/1/13 Fri 4 2 2/2/13 Sat 5 2 2/28/13 Thur 7 ; data want; set have; by mon week; mFirst = first.mon; mLast = last.mon; wFirst = first.week; wlast = last.week; run; proc report data=want nowd; column mon week date day x mtd ytd mFirst mLast wFirst wLast _dummy; define mon / order; define date / order; define week / order; define day / display; define x / analysis sum; define mtd / computed; define ytd / computed; define mFirst / display; define mLast / display; define wFirst / display; define wLast / display; define _dummy / computed; compute _dummy / char length=64; _dummy = _break_; if mFirst = 1 then do; h_mtd = 0; end; if missing(_break_) = 1 then do; h_mtd + x.sum; h_ytd + x.sum; end; if wLast = 1 then do; mtd = h_mtd; ytd = h_ytd; end; endcomp; run;
... View more
Hi Format names are not allowed to end in a number since this number is taken as the length of the formatted value call your format $Credit_Grp2X and it should work
... View more
Die Chance eine Antwort zu bekommen, ist viel grösser wenn die Frage auf English gestellt wird. SAS stellt die FILEEXIST und FEXIST zur Verfügung. Mit diesen Funktionen kann geprüft werden ob ein File existiert. Um festzustellen, ob das File leer ist, muss man das File lesen, zum Beispiel mit dem DATA Step
... View more
Hi Have a look at this blog entry Implement BY processing for your entire SAS program - The SAS Dummy by https://communities.sas.com/people/Chris%40SAS it provides excellent explanation on a programming pattern how to approach this. Bruno
... View more
Hi Kelly Have a look at this blog entry Implement BY processing for your entire SAS program - The SAS Dummy by https://communities.sas.com/people/Chris%40SAS it provides excellent explanation on how to approach this. Bruno
... View more
Hi Scott Have a look at the code below. As mentioned all the integrity constraints are copied, but not the audit information. options obs=0; proc datasets lib=work; append base=_class data=class; exchange class = _class; delete _class; run; quit; options obs=max;
... View more
Hi PGStats One can use arrays in a compute block. You can also change the sequence of across and analysis vars to make the headers look nicer See sample code below: data test; input grp across $ value @@; datalines; 1 a 1.1 1 b 1.3 1 c 1.2 2 a 2.1 2 b 2.3 2 c 2.2 3 a 3.1 3 b 3.2 3 c 3.3 ; proc report data=test nowd; column grp value, across _dummy; define grp / group; define across / "" across; define value / "" mean; define _dummy / computed /* noprint */; compute _dummy; * define array for across values; array _xacross{*} _c2_ _c3_ _c4_; acrossOffset = 1; maxRowValue = max(OF _xacross{*}); * for checking; _dummy = maxRowValue; * find the colum equal to max ; do i = 1 to dim(_xacross); if _xacross{i} = maxRowValue then do; call define(cats("_C", i + acrossOffset, "_"), "STYLE", "style={textdecoration=underline}"); end; end; endcomp; run; Bruno
... View more
Hi angorwat You might be able to use the TERMSTR option to get what you want. If your field 3 also contains the separator character (,) then the value for field 3 is usually in quotes. See also this discussion The following code will read a CSV file created in excel as outline by you data test; infile "c:\temp\csv_cr.csv" dsd dlm="," missover termstr=cr ; input emp_id : $8. dept_id : $8. free_text : $1024. Product_code : $8. country_code : $8. ; run;
... View more
