sas
Piping unzip in a SAS infile
Suppose I do the following in SAS: filenametmp pipe \'unzip -c -qq ./data_xml.zip\'; libnametmp xml xmlmap=TMMap access=READONLY;[详细]
2023-04-08 20:23 分类:问答Using UNIX SAS to ascertain Netezza DISTRIBUTE_ON key
Is anybody able to provide some SAS 9.1.3 code for ascertaining the DISTRIBUTE_ON key of a particular Netezza table?[详细]
2023-04-08 08:33 分类:问答Redefining and merging two tables in R or SAS
I have two tables (matrix) of same dimensions, one contains correlation coefficients and other with p values. I want to combine them into one table. For example let\'s say I have correlation coefficie[详细]
2023-04-07 06:37 分类:问答Macro returning a value
I created the following macro. Proc power returns table pw_cout containing column Power. The data _null_ step assigns the value in column Power of pw_out to macro variable tpw.I want the macro to retu[详细]
2023-04-04 18:09 分类:问答SAS -> Shell DB2 Passthrough and macro resolving
I\'m trying to automate a job that involves a lot of data being passed across the network and between the actual db2 server and our SAS server.What I\'d like to开发者_C百科 do is take a traditional pa[详细]
2023-04-02 16:47 分类:问答Fully Qualified Names from SQL Server in SAS
I need to be able to spec开发者_JAVA百科ify the schema that I want to access in SAS. I have used a connection string with the following schema=?? but SAS will not let me select or print the contents o[详细]
2023-04-01 12:11 分类:问答proc rank in sas
my data set has two variables ID and diagnosis. I am trying to assign row numbers in my dataset based on ID and diagnosis.[详细]
2023-03-29 00:42 分类:问答SAS Data Integration : SAP table extract error
This is the error code : Line 115: ERROR: RFC_ERROR_SYSTEM_FAILURE Error in module RSQL of the database interface.NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.[详细]
2023-03-28 06:56 分类:问答Discriminant Analysis Graph
I run a discriminant analysis & want to visualize the result. That means I want to check how well the discriminant functions demarcate dthe groups visually. Can anybody tell me开发者_运维技巧 how[详细]
2023-03-28 00:42 分类:问答ODBC issue with SQL-Server date field when migrating from XP32 to Win7 64
I am running an SQL pass-through query in SAS. When I run it on my 32bit WinXP box, the date field in the final SAS table is numeric.[详细]
2023-03-27 17:47 分类:问答