cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
monona
‎04-18-2019
  • 34 Posts
  • 14 Likes Given
  • 0 Solutions
  • 1 Likes Received

How to improve Efficiency

by Obsidian | Level 7 in SAS Programming
‎04-17-2019 08:32 PM
‎04-17-2019 08:32 PM
I am left-joining two tables. table A has 11M rows with 600mb and the table B is 430mb. If i just run this code only with the first 1000 rows of table A, it produced the output as desired.(takes only few seconds) However, If I run this whole thing, it doesn't end.  proc sql; create table want as select a.*, b.rsid from A left join B on a.chr=b.chr and b.start <= a.bp <= b.end order by id; quit; Since my computer has 64gb Ram, I modified SAS memory size from 2gb to 6gb on cfg file. What can I do to improve the speed. I modified  ... View more

Distinct observation with condition

by Obsidian | Level 7 in SAS Programming
‎04-16-2019 05:21 PM
‎04-16-2019 05:21 PM
As you see, observations of rsid are identical. I need just a single row whose start value is minimum of them and end value is maximum of them. Appreciate if someone help me out. ... View more

Simple plot

by Obsidian | Level 7 in SAS Programming
‎03-31-2019 06:17 PM
‎03-31-2019 06:17 PM
... View more

Re: Naming variables of transposed table

by Obsidian | Level 7 in SAS Programming
‎03-24-2019 06:25 PM
‎03-24-2019 06:25 PM
may be I can drop label! ... View more

Re: Naming variables of transposed table

by Obsidian | Level 7 in SAS Programming
‎03-24-2019 06:24 PM
‎03-24-2019 06:24 PM
pear works, but apple doesn't appear. ... ... View more

Re: Naming variables of transposed table

by Obsidian | Level 7 in SAS Programming
‎03-24-2019 06:06 PM
‎03-24-2019 06:06 PM
i tried this already, doesn't work for my case ... View more

Naming variables of transposed table

by Obsidian | Level 7 in SAS Programming
‎03-24-2019 05:46 PM
‎03-24-2019 05:46 PM
proc transpose data=exercise_mean out=t_exercise_mean; by Treatment; run; I generated a data set through above code. But I would like to rename 2nd and 3rd variable to, say apple, pear respectively. ... View more

Plot!

by Obsidian | Level 7 in SAS Programming
‎03-24-2019 05:10 PM
‎03-24-2019 05:10 PM
  How can I plot line graph using this table by treatment. So there should be 2 line graphs. X-axis should be 'days' with 0,2,4,8,10,12, and Y-axis should be strength.   I tried as below but quite doesn't work.. goptions reset = all; symbol1 value=circle color=black interpol = join; symbol2 value=triangle color=red interpol = join; axis1 order =(0 to 12 by 2) label=('Days'); axis2 order =(50 to 90 by 1) label = ('strength'); proc gplot data=t_exercise_mean; plot strength1*treatment; run; quit; ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 10:13 PM
‎03-01-2019 10:13 PM
my problem is libname db odbc noprompt = "server=MYSERVER;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes" DATABASE = MYDB schema = dbo; this doesn't work but the first one works....TT ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 08:16 PM
‎03-01-2019 08:16 PM
My question is simply why the second chunk of code(about proc append) doesn't create any table in the corresponding table at ms sql server, but the first one does. ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 08:15 PM
‎03-01-2019 08:15 PM
same result as shown above. Empty. ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 08:08 PM
‎03-01-2019 08:08 PM
My question is why this is reflected to sql server, BUT the second chunk is not relfected. proc sql; connect to odbc as db (required="driver=sql server native client 11.0; server=MYSERVER; Trusted_Connection=Yes; Database=MYDB;"); execute(drop table mvp_lipid) by db; execute(create table mvp_lipid ( chr varchar(2), bp numeric(18), beta float, p_value float, trait varchar(20) )) by db; disconnect from db; quit; libname db odbc noprompt = "server=MYSERVER;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes" DATABASE = MYDB schema = dbo; proc datasets library = db; append base = db.ukbb_statin data=sasdata.ukbb_statin; run; ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 07:59 PM
‎03-01-2019 07:59 PM
Your code does work, and db.mvp_lipd has created in SAS, but that doesn't affect ms sql server...T_T   The empty mvp_lipid shown in sql server is created by the following code. proc sql; connect to odbc as db (required="driver=sql server native client 11.0; server=MYSERVER; Trusted_Connection=Yes; Database=MYDB;"); execute(drop table mvp_lipid) by db; execute(create table mvp_lipid ( chr varchar(2), bp numeric(18), beta float, p_value float, trait varchar(20) )) by db; disconnect from db; quit; ... View more

Re: Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 06:07 PM
‎03-01-2019 06:07 PM
Hello, this works without error and generated a table under the connected library, but this doesn't push to sql server. I am attaching my code below.   proc sql; connect to odbc as db (required="driver=sql server native client 11.0; seerver=MYSERVER; Trusted_Connection=Yes; Database=MYDB;"); execute(drop table mvp_lipid) by db; execute(create table mvp_lipid ( chr varchar(2), bp numeric(18), beta float, p_value float, trait varchar(20) )) by db; quit; libname db odbc noprompt = "server=MYSERVER;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes" DATABASE = MYDB schema = dbo; proc datasets library = db; append base = db.mvp_lipid data=sasdata.mvp_lipid; run; ... View more

Execute statement for MS SQL Server

by Obsidian | Level 7 in SAS Programming
‎03-01-2019 04:59 PM
‎03-01-2019 04:59 PM
    Hello. I made a connection to ms sql server, successfully set up a table using execute statement, and this directly updated to the ms sql server.   Now, I would like to insert sas dataset( let say work.abc) into there (columns attribute are exactly like that:chr, bp, beta, p_value,trait). How can I do that? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-18-2019 06:20 PM
Likes given to
Likes from
View All
Quick links