Hi. I have completed MSc in Computer science this academic year. So I am fresher... While I am doing graduation and post graduation I did many projects using PHP and MySQL. Now I got opportunity to get into SAS(Statistical Analysis System) career, and I heard that SAS having better career growth than PHP developement. For the past 4 days...
I've used PROC TABULATE to generate 5 different tables and wrote those to a PDF document with ODS. Each table is on a different page. But the boss wants 3 of the smaller tables on the same page and wants the 2 bigger tables to each be on one page. Is there a way to control the page breaks with PROC TABULATE to get more than one table o...
I am very confused about making choice between being a Oracle DBA or SAS Data Analyst. I've got B.Sc.Maths degree and have decided to make inroad in computer and some friends have suggested me SAS as better option than DBA. But I have heard that DBA is money and job stability-wise better than a data analysyt. I have no very much programm...
I used to work as a Business Systems Analyst in the Financial Services industry. I've been looking for a career with better growth potential and more options in terms of variety of jobs, so I'm planning to switch to a SAS analyst position. I realize I need to learn SAS programming for this, and so I've been looking for institutes / orga...
I have 400,000 rows, each with an id, number of trials, and number of successes. I have (one) value for p, a hypothesized probability of success. I'd like to calculate an exact, binomial, one-sided p-value for each row, using its trials successes, and the global p. E.g., 1001 10 2 should give me 1001 10 2 2.639011e-01 for the pro...
Dear Folks, I am from DW/BI background using SAS for many years now I have task to find out number of records present in tables on the fly for postgresql tables i.e. In SAS we have meta tables which has details about tables and no of records, column info etc in system meta tables in a same manner is there any meta table available in p...
Is it usual that the Univariate Frequencies does not display the BY-variable while Univariate BasicMeasures does show the BY-variable? In the example below I load in some data and want to show gas prices by zipcode. The output for PROC FREQ shows the BY-variable (zipcode) in the output as does the UNIVARIATE BasicMeasures. But the UNIVA...
Say I've already sorted set1 and set2 by the variables 'sticks', 'stones', and 'bones' and then i do this: data merged; merge set1(in=a) set2(in=b); by sticks stones bones; if a and b then output; *else we don't want to do anything; run; Is there an easy way to drop all the variables from set2 in the merged dataset wit...
The problem, that if the else is executing, increment of S will not accomplish. Any idea? data osszes_folyositas; set osszes_tabla; retain old_xname; retain s 0; if xname ne old_xname then do; old_xname = xname; s = 0; end; else do; s = s + Foly_s_tott_t_rgyh_ban_HUF; delete; end; run; ...
Can you recommend me any SAS alternatives for Mac? I would not use any Parallel like solution. Which andvantage Oracle technology has in front of SAS? ...
hi, sorry for the vauge title. My data set looks essentially like this: ID X 18 1 18 1 18 2 18 1 18 2 369 2 369 3 369 3 361 1 what I want is to find the max value of x for each ID. In this dataset, that would be 2 for ID=18 and 3 for ID=361. Any feedback would be greatly appreciated. thanks ...
I saw some job offers for SAS Programmer. I hear nothing about SAS at my college and I really dont know what to think about it. Is it a niche programming platform like Oracle Forms or Lotus Notes? How does SAS Programming compare to Java, C# ? ...
I have a variable Deck1-Deck100 (Deck1 through Deck100 representing 100 trials of a task) with four possible values A' B' C' D'. I need to recode this variable so that A' and B' = 0 and C' and D' = 1. Can you help? I know nothing about how to compress variables. ...
I have a SAS dataset with around 3,000 variables, and I would like to get rid of the character variables for which all values are missing. I know how to do this for numeric variables-- I'm wondering specifically about the character variables. I need to do the work using base SAS, but that could include proc SQL, which is why I've tagged...
I am confronted with a 4-page SAS thing - macro? procedure? it has procedures within it, DATA blocks and PROC blocks, one PROC SQL block for importing from Oracle. Is there a tool that could translate SAS to something readable? Ideal would be SQL or PL/SQL (both seem applicable here), but almost anything procedural would be an improvem...
Hello all, I am rather new to SAS and I have run into a problem that I think probably has a better solution than what I've found so far. I need to update a Oracle db table that has around 1 million rows with data from a SAS data set that has about 10,000 records. I used an update statement within proc sql, but it takes hours to upd...
I am trying to write a zero padded field in a test file that a COBOL program will read using the picture clause 9(5)v999. However I am unable to find the proper format. I've tried z8.3 but SAS inserts the decimal point...ie 99.999 where as I need 00099999 as the result. Any help would be appreciated. ...
I'm trying to replicate my SAS work in R, but I get slightly different results -- differences that can't be explained by rounding error. Here's my SAS code: proc qlim data=mydata; model y = x1 x2 x3/ discrete(d=probit); output out=outdata marginal; title "just ran QLIM model"; run; quit; And here's my R code: mymodel <- glm...
How will the SAS program will help a bcom graduate person?? What is the future? Towards which industry should i go?? I have past experience in banking..... Please help Should I take this course??? ...
Hello, my SAS scripts worked fine when I was in XP, but now that I've upgraded to Windows 7, my access to MySQL has been impaired. I am sure that MySQL is running. If I open a browser then I can send commands.... The issue is with the SAS software itself. Has anyone else had this issue? Know how to fix it? ...