About Shrutibhatnagar

ballardw · ‎04-02-2019

@Shrutibhatnagar wrote: 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; Except in the FROM clause a reference like ABC.PDQ means that ABC is a data set reference or alias and PDQ is the variable named PDQ in the data set ABC. So your statement 76 group by class1.product_id is attempting to reference a dataset named class1 that has not been defined. If you want to use the variable Product_id that comes from the data set class1.mismatches1 then only use group by product_id You can create an alias to data set by from library.dataset <as> abc the as is optional but I normally use it to keep the intent clearer. Then to reference a variable in the dataset library.dataset you use abc.varname. This is mostly import when two or more data sets are used in a single proc sql statement and especially when two or more sets have a same named variable to reference which data set you want to contribute the value.

Kurt_Bremser · ‎04-01-2019

If you are working with UE, it may also be that forcibly terminated sessions have clogged up the VM (it has a maximum internal space if 10 GB, and that limits the WORK location). To remedy that, you need to re-install UE. Please show us the sizes of yor datasets (number of obs, observation size)

Astounding · ‎03-30-2019

The second SQL generates a report only. It doesn't create a table. There is no table that contains new_column. To create a table begin with Create table ........ just like you did in the first sql.

Kurt_Bremser · ‎03-18-2019

Once again: you have to seem absolutely no clue about proc sql, so the complicated things you want to do here are WAY over your head and just a useless waste of time. Start out with the simple examples from the documentation, and come back once you have that worked out. We're not here to teach you thinngs you can easily learn by yourself by working through Programming 1. Just this: 77 left join smb.PRODUCT_ID 78 ,smb.Year The list of variables in a select has to come BEFORE the "from". This is absolutely basic SQL, and you need to grasp that before you advance to any complicated join.

VDD · ‎03-17-2019

It may be that you don't have real SAS dates or that you have incorrectly used the datdif function. data _null; mydate=DATDIF(19996,19779,'30/act'); put mydate; mydate=datdif('01JUN1996'd,'01SEP1977'd,30/act); put mydate; run; It is hard to tell with so much noise from the code. Make a simple test dataset and get the logic to work then add back into that code all the extra stuff.

VDD · ‎03-17-2019

if you do a test run by dumping all the extra columns and just select 2 or 3 columns for your second SQL process you might be-able to debug it. After you have the logic working add back into the code all the extra information https://communities.sas.com/t5/SAS-Studio/please-see-the-error/m-p/543764

Kurt_Bremser · ‎03-17-2019

There must be only one "from" in a SQL select. Look at the join examples in the SAS SQL documentation.

PGStats · ‎03-16-2019

You seem to need: proc sql; select AON AS Maximum_of_AON, product_id from class1.smb group by product_id having AON=max(AON); quit;

Kurt_Bremser · ‎03-16-2019

The best proof for uniqueness is a sort with nodupkey. If that does not delete any duplicates, you have unique keys.

Shrutibhatnagar · ‎03-12-2019

hey thanks for the help that works fine now 🙂

Shmuel · ‎03-10-2019

When you write out=smb your output is work.smb, that is in work library. To create the output in class1 library you should use @PGStats answer: out=class1.smb

RW9 · ‎03-07-2019

I strongly advise you, if you have to use Excel at all, to move that data into a .xlsx file. .xls is the very old binary file format MS used to use back in 2000 and before. It shouldn't be used nowadays. Technology has moved on a lot since then, and assuming your SAS version is 9.3 or later you can simplify your process if you xlsx to: libname tmp xlsx "c:/path/to/file/yourfile.xlsx"; proc copy in=tmp out=work; run; libname tmp clear; You can see the engine in action: https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

Shrutibhatnagar · ‎02-20-2019

what is the purpose of calculating interest this way when . Is it practically used ?

PaigeMiller · ‎02-19-2019

I didn't check your code, but you can use the COMPOUND function in SAS to do this, and then you will be sure the answer is correct. Or you can compare your results to what the COMPOUND function says. https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0ledxl0wyn9jyn12hi34nlpp7ve.htm&docsetVersion=9.4&locale=en By the way, it seems to me that in your code, the interest rate is 10% per month, is that really what you wanted?

Astounding · ‎02-16-2019

We were all beginners at some point. Good to see you posting your questions.

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: when do these errors come ?

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

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

Re: DATDIF function

Re: please tell what is wrong with the code

Re: please see the error

Re: how do i in proc sql ?

Re: joins in sql

Re: ERROR: Libref CLASS1 is not assigned.

Re: please tell what is wrong with my code

Re: hello i want to import multiple sheets to sas .

Re: tell the diff.

Re: Creation the formula of Compound interest through DO loop

Re: using a variable from a dataset to the other dataset .