nit123 Tracker

Proc SQL Query to create and store macro value in table

nit123 — Sun, 15 May 2016 23:55:04 GMT

Hi All,

I am trying to create a macro variable using Proc SQL and store it in a table. but I am getting the above warning

WARNING: INTO clause is ignored in the CREATE TABLE statement.

proc sql;
create table t as select count(*) as c into :car from sashelp.cars;
quit;

any help would be appreciated.

Thank you,

Nitesh

Re: convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 01:57:53 GMT

getting the above msg

Re: convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 01:44:56 GMT

@Ksharp .sasview files

Re: convert/import sas view tables to data sets

nit123 — Wed, 30 Dec 2015 18:47:04 GMT

it was a zipfile and i extracted it in a folder

Re: convert/import sas view tables to data sets

nit123 — Wed, 30 Dec 2015 17:41:59 GMT

188 libname new 'C:\Users\nitesh\Documents\My SAS Files\9.4';
NOTE: Libref NEW refers to the same physical library as SASUSER.
NOTE: Libref NEW was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nitesh\Documents\My SAS Files\9.4
189 filename trans 'C:\Users\nitesh\Downloads\ZIPPROCSQL';
190
191 proc cimport library=new infile=trans;
192 run;

ERROR: Invalid file, C:\Users\nitesh\Downloads\ZIPPROCSQL.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CIMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

193
194 libname sql 'C:\Users\nitesh\Documents\My SAS Files\9.4';
NOTE: Libref SQL refers to the same physical library as NEW.
NOTE: Libref SQL was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nitesh\Documents\My SAS Files\9.4

convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 02:36:24 GMT

hi all i have tried the code mentioned in the above doc

http://support.sas.com/documentation/cdl/en/sqlproc/69049/HTML/default/viewer.htm#n0jov4xsixn4dqn12dn5zfk4qstz.htm

libname new 'C:\Users\nitesh\Documents\My SAS Files\9.4';
filename trans 'C:\Users\nitesh\Downloads\ZIPPROCSQL';

proc cimport library=new infile=trans;
run;

libname sql 'C:\Users\nitesh\Documents\My SAS Files\9.4';

but i am getting error in proc stmt. is there any other way to do it.

thank you.

how to select target variables in predictive modelling

nit123 — Thu, 24 Sep 2015 14:10:10 GMT

hi all i am new to sas and can any one explain me how to select target variables in predictive modelling

case sensitivity

nit123 — Sat, 12 Sep 2015 15:57:53 GMT

are the variables and file names in SAS case sensitive?

data set;
    set sasdata .chemists;
    if jobcode = 'Chem2'
        then description = 'Senior Chemist';
    else description = 'Unknown';
run;

A value for the variable JOBCODE is listed below:

JOBCODE
chem2

output: ?

the following file downloaded from SAS->help->learn sas programming

proc print data=clinic.stress2;
run;

/* modified file name */

proc print data=clinic.Stress2;
run;

output is same for both print statements

Re: jobs

nit123 — Mon, 10 Aug 2015 12:00:59 GMT

thanks for suggestions

Re: jobs

nit123 — Sun, 09 Aug 2015 14:45:35 GMT

in USA, for SAS Analyst . it would be great to know which SAS tools are in great demand also

jobs

nit123 — Sat, 01 Aug 2015 22:03:33 GMT

how are the job opportunities for grads without prior work exp.??

Re: Churn rpm data set

nit123 — Thu, 23 Jul 2015 16:28:20 GMT

yes Ma'am it would be helpful for me. thank you.

Churn rpm data set

nit123 — Wed, 22 Jul 2015 22:36:05 GMT

hi all i am new to SAS and i am currently learning Rapid Predictive Modeling for Business Analysts (EM 7.1) through videos, but i cannot find data set. please help me out.

thanks,

Nitesh