AnandSahu Tracker

Re: can i open sas7bdat file in sas eg 6.1

AnandSahu — Tue, 07 Apr 2015 09:00:06 GMT

Reeza,

yes, my EG is connected to server and the .sas7bdat file is in my desktop.

In this case, how can I access these files??

can i open sas7bdat file in sas eg 6.1

AnandSahu — Tue, 07 Apr 2015 07:32:56 GMT

hi,

can we open a sas7bdat file in SAS EG 6.1.

regards

anand

Re: Connecting SAS/ACCESS to SQL Server

AnandSahu — Fri, 07 Nov 2014 03:59:22 GMT

I used LIBNAME SQL ODBC DSN=sqlsrv user=sasjlb pw=pwd schema=dbo;

after above statements.

Re: Connecting SAS/ACCESS to SQL Server

AnandSahu — Thu, 06 Nov 2014 12:41:15 GMT

Hi Haikuo,

I did it.

Thank you so much your inputs really help a lot.

But I faced a problem while running Prompted Connection as per the document after establishment the ODBC DSN connection.:smileyconfused:

%put %superq(sysdbmsg);

above statement threw an error, I couldn't note the error, which caused problems as It gives an "ODBC:" statement with WSID and I am not aware of it.

LIBNAME SQL ODBC prompt;

NOTE: Libref SQL was successfully assigned as follows:

Engine: ODBC

Physical Name: sqlsrv

7 %put %superq(sysdbmsg);

ODBC: DSN=sqlsrv;UID=jebjur;PWD=jebjur1;WSID=d17117

So typed LIBNAME statement manually as its mentioned in the document i.e. WSID=d17117,

LIBNAME SQL ODBC noprompt= "dsn=sqlsrv; uid=himdw; pwd=******; wsid=d17117";

Initially the SQL library created but there were no datasets but after some it started showing tables in the same library. I really couldn't figure out what was the reason. So could you please share views on it.

Regards

Anand Sahu

Re: Connecting SAS/ACCESS to SQL Server

AnandSahu — Wed, 05 Nov 2014 19:02:18 GMT

One more thing....why do we Authenticate SQL Server and what is NT Authentication.

I know..these questions sound like stupid question but its first time I am going to make a connection tomorrow.

Re: Connecting SAS/ACCESS to SQL Server

AnandSahu — Wed, 05 Nov 2014 18:51:51 GMT

thank you Hikuo...

I just need to know one more thing that how can I examine whether a system has SAS/ACCESS as I would be making connecting remotely on client's system. They use window SAS.

Re: Connecting SAS/ACCESS to SQL Server

AnandSahu — Wed, 05 Nov 2014 13:56:13 GMT

Hi Xia keshan,

I just want to know the usage and approach of selecting either UserDSN, SystemDSN or FileDSN. Its clearly mentioned on the attached document that we need to put a server name.

Connecting SAS/ACCESS to SQL Server

AnandSahu — Wed, 05 Nov 2014 12:55:29 GMT

Hi All,

I have to establish a connection to SQL Server using SAS/ACCESS with ODBC but I don't know which DSN should be use to start the process, UserDSN, SystemDSN or FileDSN.

what is the difference between accessing SQL Server using ODBC OR ODE BD.

I am referring the attached document.

Regards

Anand Sahu

ERROR IN Query

AnandSahu — Thu, 30 Oct 2014 10:55:55 GMT

Hi All,

Could anybody please help me to solve these errors. This query was running properly without an error but don't why it has started giving errors.

The log and query is attached.

Regards

Anand

Re: How to import data when filename changes?

AnandSahu — Thu, 23 Oct 2014 16:06:55 GMT

what if I get an error "The submitted line exceeds maximum line length - 32768 bytes.".

how can I remove this error to eliminate this error in the process of reading a data.

Re: errors in a sql query

AnandSahu — Mon, 20 Oct 2014 12:00:09 GMT

ok. thanks Jaap for the help.

I will follow the user's guide.

Re: errors in a sql query

AnandSahu — Mon, 20 Oct 2014 04:31:16 GMT

Hi Jaap,

I am getting the above mentioned error in Create Query mode of SAS Visual Analytic and it uses the SAS LASR Analytic Server so could you please guide me how can I start the script in DMS Mode using the server SAS LASR Analytic. I has been working fine since last 2 months and I didn't make any changes.

-anand

Re: errors in a sql query

AnandSahu — Sat, 18 Oct 2014 12:53:42 GMT

Hi Jaap,

Any idea how, how can I eliminate this error????

regards

Anand

Re: errors in a sql query

AnandSahu — Sat, 18 Oct 2014 12:41:32 GMT

here is the log:

NOTE: SAS Initialization used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: The autoexec file, /opt/sas/config/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.

ERROR: The submitted line exceeds maximum line length - 32768 bytes.

1 ;*';*";*/;quit;run;

NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.

NOTE: PROCEDURE PRINTTO used (Total process time):

real time 0.04 seconds

cpu time 0.05 seconds

NOTE: Libref MSSQLLIB was successfully assigned as follows:

Engine: ODBC

Physical Name: mssqldynamics

NOTE: Libref LASRLIB was successfully assigned as follows:

Engine: SASIOLA

Physical Name: SAS LASR Analytic Server engine on local host, port 10031

NOTE: The "<>" operator is interpreted as "not equals".

NOTE: SQL view WORK.TEMP_LASR_VIEW_5834 has been defined.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.04 seconds

cpu time 0.05 seconds

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

2 The SAS System 13:08 Friday, October 17, 2014

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: The data set LASRLIB.ISALESOVERALL_BF has 0 observations and 36 variables.

WARNING: Data set LASRLIB.ISALESOVERALL_BF was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 6.85 seconds

cpu time 0.92 seconds

INFO: Registering A5KIUB9E.BF00068J to /Shared Data/SAS Visual Analytics/Public/Visual Analytics Public LASR library.

NOTE: PROCEDURE METALIB used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: Line generated by the invoked macro "REGISTERTABLE".

2 omr ( library="&LIBRARY." &REPOSARG. );

___

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: Line generated by the invoked macro "REGISTERTABLE".

2 select ("&SELECTOBJ.");

______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

3 ;*';*";*/;quit;run;

4 QUIT; RUN;

errors in a sql query

AnandSahu — Sat, 18 Oct 2014 11:58:47 GMT

Hi All,

I am getting errors mentioned below while running an SQL query so can anybody please come up with the solution. I can not provide the code as its about 700 lines.

NOTE: A GROUP BY clause has been discarded because neither the SELECT clause nor the optional HAVING clause of the associated

table-expression referenced a summary function.

NOTE: The query requires remerging summary statistics back with the original data.

regards

Anand

Re: Macro Quoting Function and total by Grouped variable

AnandSahu — Thu, 11 Sep 2014 20:42:31 GMT

Please see the result which achieved by code:

USA Road Bike Trek 5000 $2,200

USA Road Bike Cannondale 2000 $2,100

USA Mountain Bike Trek 6000 $1,200

USA Mountain Bike Cannondale 4000 $2,700

USA Hybrid Trek 4500 $650

France Road Bike Trek 3400 $2,500

France Road Bike Cannondale 900 $3,700

France Mountain Bike Trek 5600 $1,300

France Mountain Bike Cannondale 800 $1,899

France Hybrid Trek 1100 $540

United Kingdom Road Bike Trek 2444 $2,100

United Kingdom Road Bike Cannondale 1200 $2,123

United Kingdom Hybrid Trek 800 $490

United Kingdom Hybrid Cannondale 500 $880

United Kingdom Mountain Bike Trek 1211 $1,121

Italy Hybrid Trek 700 $690

Italy Road Bike Trek 4500 $2,890

Italy Mountain Bike Trek 3400 $1,877

proc print data = bicycles;

var Country Model Units TotalSAles;

by Model;

sumby Model;

run;

The SAS System 00:49 Monday, January 12, 2009 33

-------------------------------------------- Model=Hybrid --------------------------------------------

Obs Country Model Units TotalSales

1 USA Hybrid 4500 $2,925

2 France Hybrid 1100 $594

3 United Kingdom Hybrid 800 $392

4 United Kingdom Hybrid 500 $440

5 Italy Hybrid 700 $483

----- ----- ----------

Model 7600 $4,834

---------------------------------------- Model=Mountain Bike -----------------------------------------

Obs Country Model Units TotalSales

6 USA Mountain Bike 6000 $7,200

7 USA Mountain Bike 4000 $10,800

8 France Mountain Bike 5600 $7,280

9 France Mountain Bike 800 $1,519

10 United Kingdom Mountain Bike 1211 $1,358

11 Italy Mountain Bike 3400 $6,382

----- ----- ----------

Model 21011 $34,539

------------------------------------------ Model=Road Bike -------------------------------------------

Obs Country Model Units TotalSales

12 USA Road Bike 5000 $11,000

13 USA Road Bike 2000 $4,200

14 France Road Bike 3400 $8,500

15 France Road Bike 900 $3,330

16 United Kingdom Road Bike 2444 $5,132

17 United Kingdom Road Bike 1200 $2,548

18 Italy Road Bike 4500 $13,005

----- ----- ----------

Model 19444 $47,715

===== ==========

48055 $87,088

Re: Macro Quoting Function and total by Grouped variable

AnandSahu — Thu, 11 Sep 2014 20:06:35 GMT

Hi Tom,

Can't we write a code in data step to achieve the result as same as get in using print procedure.

Regards

Anand

Re: Any one knows why Permanent Label in this code doesn't work?

AnandSahu — Thu, 28 Aug 2014 19:50:14 GMT

and you can use split() options as well....

Re: Converting a number into date

AnandSahu — Thu, 28 Aug 2014 12:53:27 GMT

This is just a number. Actually it was asked in an interview to me. I told them by using format, a can be converted by this number but they marked my answer as incorrect. So that is why I am approaching this community whether in actual a number can be converted in to date without using a format or informat statement.

Converting a number into date

AnandSahu — Thu, 28 Aug 2014 09:50:01 GMT

Hi All,

Can we convert a number into a sas date for example I have a number i.e. 375 want to calculate a date on this given day without using format.

Regards

Anand