First  |  Prev |  Next  |  Last
Pages: 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Where clause usage in %if in macro
I can't find this PROC SQL in the code you've posted. There second PROC SURVEYSELECT is not finished. Where is the run/quit? ... 27 Jun 2010 02:03
Where clause usage in %if in macro
Hi I am using a %if condition to test a condtion in a macro . If the condition is true I run a proc sql statement with WHERE clause inside thte %if statement. Surprising I get a ERROR message for the first pass "ERROR 180-322: Statement is not valid or it is used out of proper order." and the WHERE statement ... 25 Jun 2010 06:37
Syntax for CONTAINS in PROC SQL Where Statement
I connect to an SQL Server database using SAS PROC SQL. Everything works properly, I get the results I want from my query. Then, I add a WHERE clause to the SQL code. I want to search for any records that the variable spec in table db contains the character string PKG, so I add, in the proper location WHERE db... 24 Jun 2010 15:14
connect SAS server to SQL servers
Hi, We’re moving from PC SAS to SAS server. SAS server resides on Windows 2k3 OS. We’re having issues having SAS communicate with our SQL servers. Our SQL servers are set up with Windows Authentication only (no mixed mode). From PC SAS I used to connect to SQL servers using a libname statement such as: LIBNAM... 24 Jun 2010 17:28
I search an alternative to the GUESSINGROW option in the IMPORT procedure for a XLS file with SAS 9.2. Regards ... 24 Jun 2010 16:21
SAS performance tweaks under windows
I've read all the available SUGI papers etc on Windows performance tweaks but none of them have seemed to have a great effect. System: Windows XP Pro 32bit, 8 processors, 8 GB of RAM, 1TB drive, partitioned so that Windows/SAS is on C and SAS temp files and all data are on D. I have found that setting options ... 24 Jun 2010 13:00
flow option in proc report.............
Hi, all I want to use flow option to produce a report. This is working properly in output window , but the same flow option is not working while getting the result in pdf format. Please give me your suggestions how to use flow option in pdf format. ... 24 Jun 2010 03:07
Using # observations in conditional statements
Here's my dilemma. I have a data set, and what I want to do with it depends on whether there are duplicates. If there are duplicates, I want to write out the duplicate IDs to the output window and stop the program. If there are no duplicates, I want the program to continue uninterrupted. I've created a data set... 23 Jun 2010 16:11
Logic Behind this Data Structure
Dear all : This is th data i have data have ; input pat $ Dep $ rel $ out $ ds $ ; cards; 123 CLI MIL RES AE 123 CLI MOD RES DS 345 DMA SEV NOT AE 345 DMA SEV RES DS 436 TES SEV RRR DS 555 PRA SEV NOT DS 555 PRA MON RES AE ; run; I am trying to get to this data set. If there is a mismatch betw... 23 Jun 2010 16:11
Problem with data import
I have a tab delimited file with five variables. STAT-EAS454:1:2:140:785#0 81 5 57679715 37 50M HWUSI-EAS454:1:2:1351:1673#0 The first variable varies ... 23 Jun 2010 12:50
First  |  Prev |  Next  |  Last
Pages: 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30