About samirt

samirt · ‎01-19-2016

Hi All, I have missing values in one of the macro variable. While performing arithmetic operation the result shows missing value. Is there any way to handle the missing macro value. For Example in Subtract macro value there is one missing value. I want the Subtract to show Subtract= . - 10 - 20 i.e. -10 %let a=.; %let b=10; %let c=20; data _null_; %let Add=%sysevalf(&a+&b+&c); %let Subtract=%sysevalf(&a-&b-&c); %let Div=%sysevalf(&a/&b); run; %put &Add is . %put &Subtract is . %put &Div is .

samirt · ‎01-18-2016

Hi, I have a dataset in which a column consist more than on value. I would like to split the column as per the number of values(As shown in the expected output). A B Agriculture 417,859 Power 0059 Real Estate 0038,622 Roads 3243 Telecom 0041 Expected Output A B Agriculture 417 Agriculture 859 Power 0059 Real Estate 0038 Real Estate 622 Roads 3243 Telecom 0041 Thanks in Advance

samirt · ‎08-31-2015

I submitted the following code Proc sql; Connect to odbc(datasrc=tribal user=** password=****); Create table work.account as Select * from connection to odbc (Select * From tribal.uu); Disconnect from odbc; Quit; ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Connection to the odbc DBMS does not exist

samirt · ‎08-31-2015

Thanks for the reply I am connecting ot SQL server using pass through facility Can you provide me the code for this so that it will be error free Thanks in advance

samirt · ‎08-31-2015

proc transpose data=tr out=trans_tr; by Name Name_of_unit; var answer; id new_optionid; run; proc print data=trans_tr; run;

samirt · ‎08-31-2015

This will provide you the expected result proc sort data=company; by Year Group_name; run; data new(keep=Year Group_Name Group_var_1 Group_var_2 First_Year Last_Year First_Group_Name First_Group_name last_Group_name); set company; by Year Group_name; if last.Group_name; run;

samirt · ‎08-27-2015

Thanks for the reply Actually as EXCEPT operator perform vertically on the table. I was in dilemma is there any way of using SET statement in data step

samirt · ‎08-27-2015

Hello everyone, I am having a table name employee_organization which consist of all employee name of the organization and employee_sales employee name of sales department Employee_id Dept 1453253 Accounts 7866341 Sales 2333642 HR 4566333 Accounts 2223355 Operation Employee_id Dept 7866341 Sales I want to get the output of all employees which are not from Sales department. It is possible by using PROC SQL SAS Except operator. I would like to know how it is possible to achieve aforementioned task using DATA Step Thanks in advance

samirt · ‎08-21-2015

Thanks for the reply When i submit proc setinit i got the following:- ---SAS/ACCESS Interface to PC Files ---SAS/ACCESS Interface to ODBC ---SAS/ACCESS Interface to MySQL So i have question whether i am able to use PROC SQL pass through or not

samirt · ‎08-20-2015

I want to know for using pass through facility of SQL in SAS is there need to install some service. This question arised because of the following ERROR in the log ERROR: The SQLSERVE engine cannot be found. ERROR: A Connection to the sqlserver DBMS is not currently supported, or is not installed at your site.

samirt · ‎05-14-2015

Code:- proc sql; create table sample1 as select stock,date, avg(size) as total_average_size from stock group by date; quit; proc sql; create table sample2 as select stock,date, category,avg(size) as cat1_avg_size from stock where category=1 group by date, category; quit; proc sql; create table final as select a.*, b.cat1_avg_size from sample1 a, sample2 b where a.stock=b.stock; quit;

samirt · ‎05-13-2015

Addition to the above code .This code will resolve your problem for missing dummy variables. data dataset1; IF FIND('role','ceo','i')>0 THEN DO; ceo_DUMMY=1; INDEPENDENT_DUMMY=0; END; ELSE IF(FIND(role','ceo','i')=0) THEN DO; ceo_DUMMY=0; INDEPENDENT_DUMMY=1; END; run;

samirt · ‎05-13-2015

Suppose dataset name is dataset1 data dataset1; set dataset1; if find(role,'CEO','i') > 0 then CEO_dummy=1; else Independent_dummy=0; run; This will solve the problem.

samirt · ‎03-02-2015

Thanks for the reply I am having a table named sample in sql which is having a field name Date. From which i wanted to extract month number using sas language. The following is the code which i am using libname top odbc datasrc=xx user=xxx password=xxx; proc sql; alter table top.sample add mon num ; update top.sample set mon=month(date); quit; SAS is throwing a ERROR:- The header/variable is not supported by ODBC function ERROR:- View sample cannot be altered

samirt · ‎02-27-2015

Hi all, In my case the table which i am using is on SQL Server. Using libname statement i access that table. Whenever i make any modification to that table, SAS throws an Error:- the ODBC table has been output. This table already exists,there in name conflicts with existing objects. This table will not be replaced. This engine doesn't support REPLACE Option How to resolve it. Thanks in advance

Online Status	Offline
Date Last Visited	‎02-11-2018 03:01 AM

Handling missing values in macro while performing arithmetic operation...

Splitting of column values based on number of values.

Re: SQL pass through facility

Re: SQL pass through facility

Re: trasform/rotate datasets using arrays

Re: Collapsing longitudinal data at the individual level to group leve...

Re: Alternative of EXCEPT operator in Data Step

Alternative of EXCEPT operator in Data Step

Re: SQL pass through facility

SQL pass through facility

Re: trasform/rotate datasets using arrays

Handling missing values in macro while performing arithmetic operation...

Splitting of column values based on number of values.

Re: SQL pass through facility

Re: SQL pass through facility

Re: trasform/rotate datasets using arrays

Re: Collapsing longitudinal data at the individual level to group leve...

Re: Alternative of EXCEPT operator in Data Step

Alternative of EXCEPT operator in Data Step

Re: SQL pass through facility

SQL pass through facility

Re: calculating averages of a variable depending on another variable a...

Re: creating dummy variables based on string part

Re: creating dummy variables based on string part

Re: How to update the table in sas which is from SQL Server?

How to update the table in sas which is from SQL Server?