Good morning, I have a very important question regarding the resolution in SAS Visual Analytics, I have a lot of graphs inside my dashboard but when I open the same graphs in LabView or Excel I see a much more detailed graph. I think SAS VA cannot handle the same resolution. Does this have something to do with resolution actually? Can I adjust it to make my graph more detailed in SAS VA or is this something SAS has made by default? I would like to hear from you.
... View more
With below code I tend to make a new column based on the values of an other column. When I click run and check the 'column_x' I see just the letter 'F' for criteria 'N' instead of the word `Fixed` and for the else I see just the letter 'N' instead of 'Not fixed'.
data want;
set have;
if index(criteria,'N') then colum_x= "Fixed";
else column_x= "Not fixed";
run;
It seems like its just taking the first letters inside the parenthesis. Why is that and how can I fix it?
... View more
Thank you Tom. Short addition. What if Im looking for If contains 'blue'? for example there might be some values 'blueblack' or 'whiteblue'. I just need everything that contains blue to be marked with an ' * '. Hows that done?
... View more
I have a dataset called `my_dataset`. Now I want to create a new column (marked) that puts a * sign for every value in column color if that value is blue. What is the best way to do it?
This is my reproducible dataset.
data my_dataset;
input customer $ ref color $20.;
datalines;
C1 101 red
C2 102 blue
C3 103 blue
C4 104 red
C5 105 yellow
C6 106 blue
;
run;
This is my expected outcome:
customer -- ref -- color -- marked C1 -- 101 -- red -- C2 -- 102 -- blue -- * C3 -- 103 -- blue -- * C4 -- 104 -- red -- C5 -- 105 -- yellow -- C6 -- 106 -- blue -- *
... View more
I want to know for every vehicle how much a problem occurs. So this means a problem can occurs more than once for every vehicle.
INPUT VehicleType - Problem AA-Z - Motor
AA-Z - Motor
AA-Z - Pedal
BB-C - Screen
BB-C - Screen
DD-F - Motor
GG-H - Motor
GG-H- Motor
GG-H - Motor
Expected Output VehicleType - Problem - CountProblem AA-Z - Motor - 2
BB-C -Screen - 2
DD-F - Motor - 1 GG-H - Motor- 3
... View more
Hi all, I have 5 Excel files, each of the file contains 5 sheets, each sheet contains around 50 rows. So this means 1 file has in total 50 x 5 = 250 rows. Is there a speedy trick I can use to combine all these 5 files (including sheets) into 1 SAS file with in total 250 x 5 rows = 12.500 rows? Please note I'm using SAS EG 7.15. Appreciate your help all.
... View more
I want to check what tables/objects are linked to my LASR table because it constantly prompts an error as soon as I open up the dashboard. I would like to delete the LASR table actually but i'm afraid there might be something linked to it...Is there a specific way to check this?
... View more
I have a line chart in my dashboards which contains 4 lines. However, 3 of the 4 lines are broken lines and 1 is 1 normal line. Why are my 3 lines broken?
... View more
