Showing posts with label SAS Code. Show all posts
Showing posts with label SAS Code. Show all posts

Tuesday, August 20, 2013

ERROR 22-322: Syntax Error is SAS code

I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. Today I was running a SAS program and got the following error.

ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, FORMAT, INFORMAT, LABEL, LABEL, LENGTH,

To resolve this as the error suggested there was a syntax error in my code where I was not using the proper syntax in the ATTRIB statement I was using

Name label 'Employee Name';

Here the label statement needs an '=' so when I change this to the following statement

Name label = 'Employee Name' ;

the sas code was executed successfully.

Tuesday, March 01, 2011

Processing of SSAS cube -- steps for beginners

I thought today I will cover the steps that can be followed to process a Sql Server Analysis Services Cube from Sql Server Management Studio.

The assumption is that you already have a cube that is built in SSAS and you would like to process this cube from sql server management studio

Step 1
Connect to the sql server analysis services instance from the sql server management studio as shown below.



Step 2
From the left hande side menu click on the plus beside Databases.

Step 3
Right click on the cube that you would like to process as shown below.













Step 4
The following dialog appears. Click on change settings if you need to and click on OK. Depending on the amount of data the processing takes a few minutes upto a few hours.



Power BI Kids competition 2026

 Celebrating the next generation of data rockstars! 🚀✨ I am incredibly proud to share that we have officially wrapped up our 8-week #PowerB...