Hi You can use the HMS function with the appropriate arguments. See sample below. How can you know that the 1 in 129 is hour 13? data have; infile cards; input post_time : 8. ; date_s = hms(int(post_time / 100), mod(post_time, 100), 0); format date_s time8.; cards; 129 203 252 ;
... View more
Hi You can use ODS LAYOUT to have several graphs side by side, you need to know how many "columns" you are going to have, so you can adjust it accordingly. See code sample below. Before each graph or table you need an ODS REGION statement. ods layout gridded columns=2; ods region; proc gchart data=sashelp.cars; vbar type; run; quit; ods region; proc gchart data=sashelp.cars; vbar origin; run; quit; ods layout end;
... View more
Hi The DATATYPE= has to be time, also the directives are case sensitive, it should work using the following code: PROC FORMAT; PICTURE Diff_Format LOW-HIGH = '%n days, %H hrs, %M min, %S sec' (DATATYPE=time) ; QUIT; data _null_; StartDate = '15APR2015:15:23:32'dt; EndDate = '18APR2015:16:44:56'dt; Difference = EndDate - StartDate; /* Calculating the difference */ PUT Difference = Diff_Format.; RUN;
... View more
You can convert these type of text strings using the ANYDTDTM informat. Unfortunately it will not read the milliseconds. In the code below two methods are shown, one using the ANYDTDTM informat, the other uses a combination of two informats for the date and time part and then combine the date and seconds together using the DHMS function. data want; dateHave = "2015.03.03 11:19:41.440"; dateWant = input(dateHave, anydtdtm19.); dateWant2 = dhms( input(substr(dateHave, 1, 10), yymmdd10.) , 0 , 0 , input(substr(dateHave, 12), time16.) ); format dateWant: datetime22.3; run;
... View more
Hi change WHERE t1.V_Date_Create_At >= intnx('year',input(today(),MMDDYYP10.),-2,'same'); to WHERE t1.V_Date_Create_At >= intnx('year', today(), -2, 'same'); Since the TODAY() function already returns the date as a number, there is not need to do any type conversion using the INPUT() function.
... View more
Die Variable "ind" kann nicht gleichzeitig "FIRE=" und "Banking" enthalten. Ich gehe davon aus, dass ind "FIRE=" oder "Banking enthalten soll. Das Where kann so aussehen: where year>2000 and ind in ("FIRE=", "Banking"); Eventuell ist das = in "FIRE=" noch ein Tippfehler.
... View more
The TODAY() function will return the current date as a number of days since 01Jan1961, see also SAS(R) 9.4 Language Reference: Concepts, Fourth Edition SAS has a function called INTNX which allows you to subtract a time interval like DAY, MONTH, YEAR an so on, by default the date returned is always the beginning of an interval to subtract 2 years and go to the same day see log below: 32 data _null_; 33 now = today(); 34 now2years = intnx("YEAR", now, -2 , "SAME"); 35 36 format now: date9.; 37 putlog _all_; 38 run; now=30APR2015 now2years=30APR2013 _ERROR_=0 _N_=1
... View more
With SAS9.4 the following code sample will do what you are after. It uses the ODS LAYOUT feature. Before each output you create you will have an ODS REGION statement, to say you are starting a new region to place output into. I might not do the exact same thing in SAS9.1.3, but have a go. goptions reset=all ; options orientation=portrait; ods _all_ close; ods pdf startpage=never; ods pdf file="C:\temp\aa.pdf" ; ods layout gridded columns=1; ods region; ** A Listing; proc print data=sashelp.cars(obs=40); var make model type driveTrain invoice horsepower; run; ods region; ** A graph; goptions /* horigin=8cm*/ /* vorigin=8cm*/ hsize=8cm vsize=8cm ; symbol v=dot h=2 c=blue; proc gplot data=sashelp.class; plot height*weight; run; quit; ods layout end; ods pdf close; ods listing;
... View more
This paper may also be of interest. I talks about using ODS LAYOUT to position output at specific areas on the PDF http://analytics.ncsu.edu/sesug/2008/SIB-097.pdf
... View more
hi You can use the following options to control the start position and size of the graph. goptions horigin=4cm vorigin=4cm hsize=14cm vsize=12cm ; Please note, that the lower left corner is the zero point for the HORIGIN and VORIGIN
... View more
Hi George Proc SQL expects a format name in the syntax, you could use a generic one like BEST. for numeric values. In order to remove a format from a variable, you can use Proc DATASETS. Something like proc datasets lib=work nolist; modify two; format y; run; contents data=two; run; quit; Will work
... View more
Hi In case this is of any help, the code sample below will translate all sorts of characters which are not valid for a SAS Name into an underscore. Beside that I would recommend Proc DATASETS with the RENAME statement, this way you avoid reading the again. data test; infile cards truncover; input name $50. ; name2 = name; if find("0123456789", char(name2, 1)) then do; substr(name2,1,1) = "_"; end; name2 = basechar(name2); name2 = prxchange("s/[^a-z¦A-Z¦0-9¦_]/_/", -1, strip(name2)); cards4; übergang valid_name lt-acnt 1 year some name a.id ;;;;
... View more
Hi It looks like you are using SAS/CONNECT with RSUBMIT. Please have a look at the doc SAS/CONNECT(R) 9.4 User's Guide, Second Edition, Maybe you have to transfer a local macro variable to the remote system, so that the value can be resolved.
... View more
