Suppose you want a list of car manufacturers from the CARS dataset. Easy! Call the %CHARLIST macro from a %PUT statement, like this: The CHARLIST macro generates a list of unique values of a selected variable from a selected dataset. So does PROC FREQ. But, if you don’t need statistics, the CHARLIST […]
The post Finding your Dream Car with a little macro magic appeared first on SAS Learning Post.
Quick Quiz! Where might you hear the following conversation? … Waitress: “What would you like to drink, honey?” Customer: “I’ll have a coke.” Waitress: “What kind?” Customer: “Diet Pepsi.” If you answered somewhere between Texas and Georgia, you woul…
To make accurate predictions, it is necessary that the sample data you use for model development is compatible with the target population. The distribution of each input used in the model should be similar in the sample and the target population. In yo…
In growing areas such as the Research Triangle Park, there is always the tough decision between developing land for business, or keeping it natural for parks and recreation. SAS is fortunate to have the great hiking trails at Umstead Park just across t…
You know the value of your SAS Certification; does the rest of the world? A recent MONEY and Payscale.com study named SAS Analytics skills as the most valuable skills to have in today’s job market and certification is the best way to demonstrate those skills. Recognition like this helps solidify […]
The post Share your SAS Certification experience and maximize value appeared first on SAS Learning Post.
Would you like to format your macro variables? Easy! Just use the %FORMAT function, like this: What?! You never heard of the %FORMAT function? Of course not, cuz it doesn’t exist! No problem. Just create it, like this: %macro format(value,format); %if %datatyp(&value)=CHAR %then %sysfunc(putc(&value,&format)); %else %left(%qsysfunc(putn(&value,&format))); %mend format; The %FORMAT […]
The post How to format a macro variable appeared first on SAS Learning Post.
Ok, so my recent issue was integrating CIS with Microsoft OLAP cubes. The normal way to do this is to set up MS OLAP (SSAS) with a website and use XML/A to connect. I started down that path and decided to try a different tack based some StackOverflow articles. Here is my approach that worked great:
The trick here is to use a Linked Server in the middle of the connection. For this, you need a SQL Server
instance.
Steps
• Put it into Packaged Query and do Design by Exampl
What I was doing:Using a SQL Server table to feed a PROC FORMAT using CNTLIN.Error message seen:ERROR: Cannot mix missing and nonmissing values in the same rangeCause:START column was defined as character and END column was defined as a numeric (decimal)