it.rss24h.com

Question:
Hi EE:
How can I format date to get 31DEC2010 in sas?
Solution:
Use DATE9. as the format.

Question:
Hi EE
How can I compare macro two variables in SAS (for equality in numeric value). For example,
&macro1=&macro2
And I would also like to the parent shell program an exit code. If the above two macro values are equal then 0 (no error) and if not then 1.
thx
Solution:
If that is the case you could always set a [...]

Question:
Hi EE
I am having difficulty doing the If Then Else statements below due to syntax. Any idea howto work this?
DATA _NULL_;
if %compare(150,100)=0 then do;
PROC SQL INOBS=10 OUTOBS=10;
CREATE TABLE WORK.TEST1 AS SELECT * FROM MYLIB.TABLE1;
QUIT;
else do;
PROC SQL INOBS=10 OUTOBS=10;
CREATE TABLE WORK.TEST2 AS SELECT * FROM MYLIB.TABLE2;
QUIT;
end;
run;
Solution:
Try removing the COMPARE function you had in the statement.  Are [...]

Question:
Hi experts,
I’m trying to create a trigger which will make sure I can’t enter a total value for my deliveries which would make the total quantity ordered is busted. Ex: I ordered 100 parts, delivered 25 the first time, 50 the second time, I can’t deliver more than 25 the third time.
The attached code doesn’t [...]

Question:
Hi guys,
Can anyone see what i have done worng in my syntax to
alter this table and trim the spaces off barcode1 field?
update table supbarcode set barcode1 = trim(barcode1)
Solution:
That’ll remove any spaces from the beginning and end of the data in the barcode1 field, in every row in the supbarcode table.

Question:
please help me….working new in oracle forms 10g….. its web application (using forms 10g front end, oracle 10g back end)….I try to call crystal report 11 Ver  in my forms….how can i call the report…please give some ideas
Solution:
Using the Oracle Forms Web.Show_Document() Built-in to call Oracle Reports on
the Web is an alternative to the Run_Report_Object() [...]

Question:
How many collations are available in oracle db?
Solution:
Oracle will use the codepages available in UNIX or LINUX where it would be installed by default and rarely in Windows boxes..
And in Oracle, it would be referred as Codepages instead of Collation but its an equivalent and this would list all codepages available:
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm