About Shrutibhatnagar

Shrutibhatnagar · ‎04-02-2019

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname class1 '/folders/myfolders/mysas'; NOTE: Libref CLASS1 refers to the same physical library as CLASS3. NOTE: Libref CLASS1 was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/mysas 74 proc import datafile='/folders/myfolders/mysas/smb.csv' 75 dbms=csv out=class1.smb replace; 76 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 99999 rows created in CLASS1.SMB from /folders/myfolders/mysas/smb.csv. 1353

Shrutibhatnagar · ‎04-02-2019

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sql; 74 select product_id ,count(product_id) 75 from class1.mismatches1 76 group by class1.product_id 77 having count(product_id) >1 ; ERROR: Unresolved reference to table/correlation name class1. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 78 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.03 seconds 79 80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 92

Shrutibhatnagar · ‎04-02-2019

says no source no syntax check

Shrutibhatnagar · ‎04-02-2019

Hello, I have tried with both of them ,yes i have used class1 ref in libname before.

Shrutibhatnagar · ‎04-02-2019

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sql; 74 select product_id ,count(product_id) 75 from class1.mismatches1 76 group by class1.product_id 77 having count(product_id) >1 ; ERROR: Unresolved reference to table/correlation name class1. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 78 quit;

Shrutibhatnagar · ‎03-31-2019

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sql outobs=20; 74 select * ,new_column 75 from class1.smb 76 left join work.mismatches2 77 on smb.product_id=mismatches2.product_id; ERROR: Insufficient space in file WORK.'SASTMP-000000068'n.UTILITY. ERROR: File WORK.'SASTMP-000000068'n.UTILITY is damaged. I/O processing did not complete. NOTE: Error was encountered during utility-file processing. You may be able to execute the SQL statement successfully if you allocate more space to the WORK library. ERROR: There is not enough WORK disk space to store the results of an internal sorting phase. ERROR: An error has occurred. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 78 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 25.87 seconds cpu time 14.17 seconds 79 80 81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 93 i tried to increase the size of my vm to its maxmum limit also then also these errors get generated , is my code even getting executed ? or its just some problem with my vm ?

Shrutibhatnagar · ‎03-30-2019

the second proc sql contains the mismatches table which gets executed that means the table contains the new_column . where am i wrong ?

Shrutibhatnagar · ‎03-29-2019

proc sql; create table work.mismatches1 as select distinct h.product_id,churn_month from class1.smb as h left join churners as b on h.product_id=b.product_id; quit; proc sql outobs=200 ; select product_id , case when churn_month is not null then '1' else '0' end as new_column from work.mismatches1; quit; proc sql outobs=200; select * ,mismatches1.new_column from class1.smb left join mismatches1 on smb.product_id=mismatches1.product_id; quit; ERROR: Column new_column could not be found in the table/view identified with the correlation name MISMATCHES1.

Shrutibhatnagar · ‎03-18-2019

yes sure 🙂 but the error now says this :- 76 from work.test 77 left join smb.PRODUCT_ID 78 ,smb.Year _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, (, AS, ON. ERROR 200-322: The symbol is not recognized and will be ignored. 79 ,smb.AON 80 ,smb.CELL_CALL_CNT_M1 81 ,smb.CELL_CALL_CNT_M2 82 ,smb.CELL_CALL_CNT_M3 494 on class1.product_id=test.product_id; __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored.

Shrutibhatnagar · ‎03-17-2019

now i get new errors i referred the same 78 ,smb.Year _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, (, AS, ON. ERROR 200-322: The symbol is not recognized and will be ignored. 79 ,smb.AON 80 ,smb.CELL_CALL_CNT_M1 81 ,smb.CELL_CALL_CNT_M2 82 ,smb.CELL_CALL_CNT_M3 83 ,smb.CELL_CALL_CNT_M4 84 ,smb.CELL_CALL_CNT_M5 85 ,smb.CELL_CALL_CNT_M6 86 ,smb.CELL_CALL_SEC_M1 87 ,smb.CELL_CALL_SEC_M2 88 ,smb.CELL_CALL_SEC_M3 89 ,smb.CELL_CALL_SEC_M4 90 ,smb.CELL_CALL_SEC_M5 91 ,smb.CELL_CALL_SEC_M6 92 ,smb.CELL_CALL_avg_dur_M1 93 ,smb.CELL_CALL_avg_dur_M2 94 ,smb.CELL_CALL_avg_dur_M3 95 ,smb.CELL_CALL_avg_dur_M4 96 ,smb.CELL_CALL_avg_dur_M5 97 ,smb.CELL_CALL_avg_dur_M6 98 ,smb.CELL_USAGE_CHARGE_AMT_M1 99 ,smb.CELL_USAGE_CHARGE_AMT_M2 100 ,smb.CELL_USAGE_CHARGE_AMT_M3 101 ,smb.CELL_USAGE_CHARGE_AMT_M4 102 ,smb.CELL_USAGE_CHARGE_AMT_M5 103 ,smb.CELL_USAGE_CHARGE_AMT_M6 492 ,smb.Avg_DEC_3M_USAGE_CHARGE_AMT as t2 493 494 495 on t1.product_id=t2.product_id; __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 496 497 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.20 seconds cpu time 0.19 seconds 498 499 500 501 502 503 504 505 506 507 508 509 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 521

Shrutibhatnagar · ‎03-17-2019

i want to know how do i refer this table ,as we refer through libname when we give a path but this is created in proc statement i wrote . How to refer the test table in proc sql to be joined with smb table ?

Shrutibhatnagar · ‎03-17-2019

the error given is 92 493 from class1.smb 494 495 left join test.product_id 496 on smb.product_id=test.product_id; ERROR: Libref TEST is not assigned. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 497 498 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): code after correction - from class1.smb left join test.product_id on smb.product_id=test.product_id; quit;

Shrutibhatnagar · ‎03-17-2019

not executing even . its been running from past 20 min .

Shrutibhatnagar · ‎03-17-2019

Still does not execute .executing from past 20 min .

Shrutibhatnagar · ‎03-17-2019

table 1 smb table 2 test:- proc sql; create table test as select year, product_ID, max(AON) as MAX_AON from class1.smb group by 1; quit; i want to do left join of the smb and test table so i do this - proc sql ; select distinct (smb.PRODUCT_ID) ,smb.Year ,smb.AON ,smb.CELL_CALL_CNT_M1 ,smb.CELL_CALL_CNT_M2 ,smb.CELL_CALL_CNT_M3 ,smb.CELL_CALL_CNT_M4 ,smb.CELL_CALL_CNT_M5 ,smb.CELL_CALL_CNT_M6 ,smb.CELL_CALL_SEC_M1 ,smb.CELL_CALL_SEC_M2 ,smb.CELL_CALL_SEC_M3 ,smb.CELL_CALL_SEC_M4 ,smb.CELL_CALL_SEC_M5 ,smb.CELL_CALL_SEC_M6 ,smb.CELL_CALL_avg_dur_M1 ,smb.CELL_CALL_avg_dur_M2 ,smb.CELL_CALL_avg_dur_M3 ,smb.CELL_CALL_avg_dur_M4 ,smb.CELL_CALL_avg_dur_M5 ,smb.CELL_CALL_avg_dur_M6 ,smb.CELL_USAGE_CHARGE_AMT_M1 ,smb.CELL_USAGE_CHARGE_AMT_M2 ,smb.CELL_USAGE_CHARGE_AMT_M3 ,smb.CELL_USAGE_CHARGE_AMT_M4 ,smb.CELL_USAGE_CHARGE_AMT_M5 ,smb.CELL_USAGE_CHARGE_AMT_M6 from class1.smb left join test on smb.product_id=test.product_id; quit; and this doesn't execute please help ....

Online Status	Offline
Date Last Visited	‎04-03-2019 03:02 AM

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

ERROR: Unresolved reference to table/correlation name class1.

when do these errors come ?

Re: i am getting the error in the last proc statement

i am getting the error in the last proc statement

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: i am getting the error in the last proc statement

Re: when do these errors come ?

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: joins in sql

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

Re: ERROR: Unresolved reference to table/correlation name class1.

ERROR: Unresolved reference to table/correlation name class1.

when do these errors come ?

Re: i am getting the error in the last proc statement

i am getting the error in the last proc statement

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

Re: how to refer a table created in proc sql ?

how to refer a table created in proc sql ?