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.
Showing posts with label SAS Code. Show all posts
Showing posts with label SAS Code. Show all posts
Tuesday, August 20, 2013
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.

Subscribe to:
Posts (Atom)
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...
-
40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attent...
-
Did you know that you can connect to your Power BI Desktop Model from Sql Server Management Studio (SSMS)? If not, this blog post is fo...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
