About SVoldrich

Sajid01 · ‎10-17-2024

Hello Your server appears to be connecting to the server defined by authdomain=SQLSVR . Your SAS Admin should be able to provide the details. You can try a direct libname statement to connect to the new server. This link has the details. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0gz66qe8msnkyn1jgnhrr0l2k8y.htm

SVoldrich · ‎09-15-2020

This solves it. PenetrationRate is importing as char(4) format=$4. TotalDollars is importing as char(8) format=$8. (input(TotalDollars,Dollar15.10)/input(PenetrationRate,Comma32.)) as TotalToBeConsidered What I'm expecting is 10.4/.9 = 11.56 if the penetration rate is less than 100% 10.4/1 = 10.4 if the penetration rate is 1.

Tom · ‎01-16-2020

How consist is the data? How many digits could there be? Why not convert the digits to a number and then back to digits? cats(char(dataelement,1),input(substr(dataelement,2),32.))

JuanS_OCS · ‎05-23-2019

Hello @SVoldrich , good question. I think all the answers so far are very good. My personal approach is closer to what @SASKiwi mentioned. If you present a couple of cases, real cases, and you incentivate argument, is a good way to test not only the knowledge, but also how your applicant reacts into certain scenarios. It is a good balance for evaluating hard and soft skills. And you might learn something as well from the applicant... nevertheless, you incorporate people also for learning from each other. Right?

RW9 · ‎03-01-2019

So, effectively what I posted above then... Anyways, if the code is passed through, that means all the code gets picked up and passed to the database, therefore it has to conform to syntax understood by the database, using functions that the database understands. the '..'x is a SAS specific syntax, so the database probably wont understand it. If you want to see in action, write the code directly in the database, you will see the problems. Oh, and please avoid coding all in uppercase, and use the code window, its the {i} above post area, so we can clearly read your code.

ballardw · ‎12-31-2018

and may want to add options(sheet_interval='BYGROUP') to the ODS EXCEL depending on how you are building the report.

SVoldrich · ‎09-01-2016

sorry, i was looking at the wrong data _null_ Yay! it works now!

SVoldrich · ‎10-30-2014

Thanks! I did it... but my program is currently running, guess i'll have to wait until i run a new one to tell the difference.

SVoldrich · ‎05-20-2014

I'll research that RW9 - Not everything in that code makes sense to me, but I will research it...

SVoldrich · ‎06-27-2014

I ended up completing the project while stoping the code manually, and changing the info, and restarting... it's just that it takes 6 hrs to pull all the data... and i wanted this to run overnight with little to no intervention so i can get in the morning and move on to the next task and not have my system tied up all day waiting for this to run and constantly paying attention to it to make sure i'm inputting stuff as needed. I now have a little bit of downtime and thought I would circle back to this to see if I could figure it out. Astounding, this just might be what i was looking for. most of that code is still foreign to me (only been using SAS for about 10 months, no prior coding/SQL experience). Especially the last bit of code - the proc sql sleect count. I think i understand what it's supposed to do... but i can't get it to do it... But thank you for the response. I will play with this! Fingers crossed!

Ksharp · ‎04-06-2014

It would be easy to settle in SQL. data have1; input name : $2. x $ id; cards; NB sds 1 RN sdft 1 ; run; data have2; input name $ x : $14. id; cards; NB sdsfsddfs 2 RN sdsdfsdfsder 3 BOTH sdsds 4 ; run; proc sql; create table temp as select memname,name,max(length) as max_len from dictionary.columns where libname='WORK' and memname like 'HAVE%' and type='char' group by name order by memname,name; quit; data _null_; set temp end=last; by memname; if _n_ eq 1 then call execute('proc sql;'); if first.memname then call execute('alter table '||memname||' modify '); call execute(name||' char('||put(max_len,8.)||')'); if not last.memname then call execute(','); else call execute(';'); if last then call execute('quit;'); run; data want; set have1 have2 ; by id; run; Ksharp

Reeza · ‎10-28-2013

No, for example you can run SQL code on SAS datasets that aren't on a SQL server so definitely not Pass-Thru. Pass Through will submit SQL code to your server, so the DBMS type is important. It can be more efficient because work is then done on the server not on your computer.

Online Status	Offline
Date Last Visited	‎10-07-2024 11:30 AM

Re: LIBNAME SQLSVR with Personal Login Manager server info

LIBNAME SQLSVR with Personal Login Manager server info

Re: Divide by 100%

Re: Divide by 100%

Divide by 100%

Re: subsring on a variable length field

Re: subsring on a variable length field

subsring on a variable length field

Testing Job Applicatants

Re: get rid of CRLF in data

Re: subsring on a variable length field

Re: Advanced do loop

Re: stoping a code for input

Re: stoping a code for input

Re: How to union two data sets in Data step

Testing Job Applicatants

Re: LIBNAME SQLSVR with Personal Login Manager server info

Re: Divide by 100%

Re: subsring on a variable length field

Re: Testing Job Applicatants

Re: get rid of CRLF in data

Re: How do i write a dynamic Do Loop

Re: Advanced do loop

Re: Project Log in Enterprise Guide

Re: counting variables

Re: stoping a code for input

Re: How to union two data sets in Data step

Re: ODBC fields formatting different