About ChrisBrooks

ChrisBrooks · ‎03-23-2018

Only keep variables that you absolutely MUST have in your data set

ChrisBrooks · ‎03-22-2018

Essentially an inline query is a SELECT statement in the FROM clause of another SELECT statement whereas a subquery is a SELECT statement within another SQL data manipulation statement, usually a WHERE clause.

ChrisBrooks · ‎03-14-2018

In that case I think this s join with a Like should be OK data tableA; length sponsor $5; infile datalines; input sponsor; datalines; Cola Pepsi Fanta ; run; data tableB; length id 8 collaborator $18; infile datalines dlm=","; input id collaborator;; datalines; 1,sponsored by Cola 2,Charity foundation 3,law firm LLC 4,Organge Fanta 5,Home Depot 6,Pepsi-Gametime 7,pepsi|cranberry ; run; proc sql; create table tableC as select * from tableB left join tableA on upcase(tableB.collaborator) like "%"||upcase(trim(tableA.sponsor))||"%" order by id; quit;

ChrisBrooks · ‎03-14-2018

You can do this with a Proc SQL left join like so data tableA; length sponsor $5; infile datalines; input sponsor; datalines; Cola Pepsi Fanta ; run; data tableB; length id 8 collaborator $18; infile datalines dlm=","; input id collaborator;; datalines; 1,sponsored by Cola 2,Charity foundation 3,law firm LLC 4,Organge Fanta 5,Home Depot 6,Pepsi-Gametime ; run; proc sql; create table tableC as select * from tableB left join tableA on tableB.collaborator contains tableA.sponsor order by id; quit;

ChrisBrooks · ‎03-13-2018

It could be an LDAP issue http://support.sas.com/kb/58/135.html

ChrisBrooks · ‎03-06-2018

Your libname statement is incorrect - when working in University Edition you need to assign a Library as in this link https://support.sas.com/software/products/university-edition/faq/SAS_libname.htm e.g. libname newlib '/folders/myfolders/'; Don't forget that you're running inside a Linux virtual machine so you should always use forward slashes even when your host machine OS is Windows

ChrisBrooks · ‎03-06-2018

I'm with @RW9 on. this one - in 30 years as a professional software developer I've never felt the need to write a recursive macro. The job itself is hard enough without all those complications....

ChrisBrooks · ‎03-06-2018

You're trying to mix data step code with SQL i.e. SELECT DISTINCT OLD_NO FROM REFERRAL is SQL and the rest is data step. They're two completely different (albeit SAS supported) languages.

ChrisBrooks · ‎03-05-2018

Just for the record as well there is no Proc Merge - you can use a MERGE statement or an SQL JOIN. In practice the decision about which to choose often seems to boil down to personal preference more than anything else.

ChrisBrooks · ‎03-05-2018

You can only read SAS data files with the SET statement - the .dat extension is not tied to any particular application so you'll need to find out what format it is in before attempting to read it into SAS.

ChrisBrooks · ‎03-04-2018

OK try this then data expenses; infile "&dirdata/expensesArray.csv" dlm="," DSD firstobs=2 termstr=CRLF; length ResortName $26 Resort $8; input ResortName Resort OffSeason1-OffSeason6; run;

ChrisBrooks · ‎03-04-2018

Try adding an extra dot in your infile statement after the macro variable like so %let dirdata=C:/Users/jc3992/Downloads; * From week 4: ; data expenses; infile "&dirdata..expensesArray.csv" dlm="," DSD firstobs=2 termstr=CRLF; length ResortName $26 Resort $8; input ResortName Resort OffSeason1-OffSeason6; run; The first dot will be consumed by the macro processor which is why it's not formulating your pathname/filename correctly

ChrisBrooks · ‎03-03-2018

Almost certainly connected to this issue https://communities.sas.com/t5/SAS-Analytics-U/SAS-Studio-having-problems-finding-shared-folder/m-p/317328#M4965

ChrisBrooks · ‎03-03-2018

I'm not a SAS VA guru by any means but you should be able to enter some custom code which will do the job for you. I wrote an article not long ago on Custom Sorting with Proc SQL which you can use to derive any order you choose. You can find it here -> https://communities.sas.com/t5/SAS-Communities-Library/Custom-Sorting-with-Proc-SQL/ta-p/373460

ChrisBrooks · ‎03-02-2018

It sounds like you're having the same problem as was reported here -> https://communities.sas.com/t5/SAS-Analytics-U/SAS-Studio-having-problems-finding-shared-folder/m-p/441910#M7274 i.e. there appears to be a bug in the latest version of VirtualBox. A solution is offered at the link.

Online Status	Offline
Date Last Visited	‎10-08-2024 11:59 PM