cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
abidi
‎09-13-2021
  • 10 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Studio Create Table with Left Join Issue

by Fluorite | Level 6 in SAS Visual Analytics
‎09-13-2021 07:24 AM
‎09-13-2021 07:24 AM
This is the complete code. Sorry for the inconvenience.   proc sql; Select * from sq.observations as obs Left Join         sq.engagement as eng ON obs.ID = eng.CUST_OBJ_ID Left Join        sq.actionplan as actplan ON obs.ID = actplan.CUST_OBJ_ID; quit;   ... View more

Re: SAS Studio Create Table with Left Join Issue

by Fluorite | Level 6 in SAS Visual Analytics
‎09-13-2021 06:58 AM
‎09-13-2021 06:58 AM
Yes, indeed, I am using for instance table a, table b, and table c. I have joined these tables and the code of joining the table is attached.  ... View more

SAS Studio Create Table with Left Join Issue

by Fluorite | Level 6 in SAS Visual Analytics
‎09-13-2021 06:01 AM
‎09-13-2021 06:01 AM
Dear All,   I am using SAS Studio and SAS VA. I have 3 tables and left joined successfully and want to retrieve all the records with all fields. The query result comes up with the desired output but when I encapsulate query inside the create table statement, it retrieves only 542 fields out of 721 fields. Please find below the code for your reference:   %rskmgt; proc sql; Create table OBS_ENG_AP_COMPLT AS Select *        from table a left join                table b        ON a.id = b.id left join table c        ON a.id = c.id quit; %rskmgt_load_lasr_tbls_no_perms(intblnm=OBS_ENG_AP_COMPLT,inlib=WORK);   ... View more

Re: Problem in Partitioning of Data

by Fluorite | Level 6 in SAS Studio
‎09-17-2019 11:28 AM
‎09-17-2019 11:28 AM
Try to understand my problem, I'm neither using any programming SAS code nor any scipt. I have just created a project, upload the required excel file from the local source, set the partition settings by clicking Advanced button, and succinctly saved the project, then set the target variable then uncheck the checkbox of the target variable and in the pipeline, just right click on the Data node and run and after few seconds it gave me the following error message, pl. see screenshot: Log file already been shared with you.   ... View more

Problem in Partitioning of Data

by Fluorite | Level 6 in SAS Studio
‎09-17-2019 01:35 AM
‎09-17-2019 01:35 AM
Hi, All,   I am having a problem with partitioning of data. Please find below the error received for your reference and perusal, also attached is the log file. I am using Model Studio and when I create the project and set the target variable and then run the Data node, the following error occurs and it does not allow me to move ahead. Please look into it.   Kind regards, Abidi.   NOTE: Fileref MACFILE has been deassigned. ERROR: Variable No_btmHint_hint_count not found. ERROR: Variable btmHint_hint_count not found. ERROR: Variable btmHint_scaf_count not found. ERROR: Variable correct_1st_attmpt_help_avg not found. ERROR: Variable first_action_attempt_count not found. ERROR: Variable hint_tot_no_of_poss_hint_avg not found. ERROR: Variable opport_original_main_prob_avg not found. ERROR: Variable opport_original_scaf_count not found. 12 The SAS System Tuesday, September 17, 2019 01:22:00 AM   ERROR: Variable opportunity_avg not found. ERROR: Variable original_main_scaf_avg not found. ERROR: Variable tot_assignt_count not found. ... View more

Re: Data Partitioning Log File Showing Error

by Fluorite | Level 6 in SAS Data Science
‎09-16-2019 02:43 AM
‎09-16-2019 02:43 AM
Dear SASKiwi, I have only this screenshot and the log files which I have shared with you. Waiting for your valuable suggestion. [cid:4e57f321-6342-4e20-b128-1a52b397503a] ... View more

Data Partitioning Log File Showing Error

by Fluorite | Level 6 in SAS Data Science
‎09-15-2019 03:31 AM
‎09-15-2019 03:31 AM
Below is the error I received. Further please have a look at the attached file herewith.   NOTE: Fileref MACFILE has been deassigned. ERROR: Variable No_btmHint_hint_count not found. ERROR: Variable btmHint_hint_count not found. ERROR: Variable btmHint_scaf_count not found. ERROR: Variable correct_1st_attmpt_help_avg not found. ERROR: Variable first_action_attempt_count not found. ERROR: Variable hint_tot_no_of_poss_hint_avg not found. ERROR: Variable opport_original_main_prob_avg not found. ERROR: Variable opport_original_scaf_count not found. 12 The SAS System Sunday, September 15, 2019 03:02:00 AM ERROR: Variable opportunity_avg not found. ERROR: Variable original_main_scaf_avg not found. ERROR: Variable tot_assignt_count not found.   Kind regards, Abidi. ... View more

Re: Three new Variable Clustering features in SAS Model Studio 8.3

by Fluorite | Level 6 in SAS Communities Library
‎07-21-2019 08:53 AM
‎07-21-2019 08:53 AM
Excellent explanations and these new additions will remarkable and make life easy for data scientists.     ... View more

Re: Best transformation – a new feature in SAS Model Studio 8.3

by Fluorite | Level 6 in SAS Communities Library
‎07-20-2019 10:44 AM
‎07-20-2019 10:44 AM
Excellent explanation, awesome. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-13-2021 11:21 AM
Likes given to
View All
Quick links