About Rohit12

Rohit12 · ‎07-06-2018

%let x=a,b; %put &x; %macro new; %do i=1 %to 2; %let y=%scan(&x,&i,','); %put &y; %end; %mend; %new ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: b ERROR: Argument 2 to macro function %SCAN is not a number. ERROR: The macro NEW will stop executing. why I am getting this error .how can I solve this

Rohit12 · ‎04-30-2018

Hello I have a dataset called new which have three columns name age salary when I am exporting this dataset into CSV through proc export proc export data=new dbms=csv outfile="L\new\sample.csv" replace; run; when I am opening the CSV file it shows all the three columns in one column in CSV name,age,salary rohit,12,20000 sagar,15,50000 But what i want all the three columns in three columns in CSV not in one column How can I acheive that

Rohit12 · ‎03-05-2018

I cannot post the code of macro find as it is company specific macro

Rohit12 · ‎03-05-2018

data new; input x; datalines; t1 T2 T3 T4 T5 T6 ; RUN; I am having a macro called find .In this macro if I have pass T1 it gives me full table name for ex %find(t1) output will be a dataset called table_desc with one variable table_name have value cust_dept for input t I want to create a new macro called great %macro great proc sql noprint; select count(distinct x) into :total from new order by x; quit; proc sql noprint; select distinct x into :name1- :name&total.from new order by x; quit; data xyz; set new; %do i=1 to &total.; %find(&&name&i.); tabel=t1; run; %mend %great my final output of xyz tabel tabel_name t1 cust_dept t2 dept_accunt t3 accunt_customer t4 account_new could you please help me how can I acheive this

Rohit12 · ‎12-27-2017

actually i am not getting any error .But mu code is not running what i want if &var<&var_99 then &var=&var_99; below line resolves into if acctage<acctage_99 then acctage=acctage_99 there comes a note in the log variable acctage_99 is uninitiliazed which is corect what I want is this if acctage< 4567 then acctage=4567 thanks

Rohit12 · ‎12-27-2017

%let acctage_99=4567; %macro new(var); data new; set old; if &var<&var_99 then &var=&var_99; run; %mend; %new(Acctage) In the old dataset I am having a variable Acctage which I need to comapre with macro variable(acctage_99) and then assign the value of acctage_99 to variable acctage how can I acheive this through macro

Rohit12 · ‎12-11-2017

I need this thing through proc sql

Rohit12 · ‎12-11-2017

data new4; infile datalines missover ; input x y $ z $; datalines; 1 a b 1 a c 2 b c 2 b d 3 r t 3 r y ; run; I want my output to be A new column need to be generated ICD whose value will be x y ICD 1 a b, c 2 b c,d 3 r t,y I need this output through proc sql

Rohit12 · ‎09-01-2017

How can i remove this error and what is the solution

Rohit12 · ‎09-01-2017

Now I have tried this code but it is not woking %macro lzlib; LIBNAME LZZ OLEDB BULKLOAD=YES DBCOMMIT=0 CURSOR_TYPE=STATIC BL_KEEPIDENTITY=YES BL_KEEPNULLS=NO DIRECT_EXE=DELETE PROPERTIES=('Integrated Security'=SSPI 'Persist Security Info'=TRUE 'Initial Catalog'=Customer_account) PROMPT=NO REREAD_EXPOSURE=NO PROVIDER=SQLOLEDB DATASOURCE="dwh-i-sql" SCHEMA=DZS ROWSET_SIZE=32767 UPDATE_MULT_ROWS=YES PRESERVE_GUID=yes; proc sql; delete from LZZ.customer where START_DATO='2017-09-01 00:00:00.000'; QUIT; %mend; OLEDB: AUTOCOMMIT turned ON for connection id 4 771 1819876483 Main 0 OBJECT_E OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 4 772 1819876483 Main 0 OBJECT_E OLEDB: AUTOCOMMIT turned OFF for connection id 4 773 1819876483 Main 0 OBJECT_E NOTE: Libref LZZ was successfully assigned as follows: Engine: OLEDB Physical Name: SQLOLEDB OLEDB: AUTOCOMMIT turned ON for connection id 5 774 1819876483 Main 0 SQL (2) OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 5 775 1819876483 Main 0 SQL (2) OLEDB: AUTOCOMMIT turned OFF for connection id 5 776 1819876483 Main 0 SQL (2) OLEDB: AUTOCOMMIT turned ON for connection id 5 777 1819876483 Main 0 SQL (2) OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 5 778 1819876483 Main 0 SQL (2) 779 1819876483 Main 0 SQL (2) OLEDB_47: Prepared: on connection 5 780 1819876483 Main 0 SQL (2) SELECT * FROM "LZS"."customer" 781 1819876483 Main 0 SQL (2) 782 1819876483 Main 0 SQL (2) ERROR: Expression using equals (=) has components that are of different data types. OLEDB: AUTOCOMMIT turned ON for connection id 5 783 1819876483 Main 0 SQL (2) OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 5 784 1819876483 Main 0 SQL (2) OLEDB: AUTOCOMMIT turned OFF for connection id 5 785 1819876483 Main 0 SQL (2) SAS_SQL: The statement cannot be processed directly by the database because the DBIDIRECTEXEC option was not specified. This option replaces the DIRECT_EXE option for which support will be dropped in the future. 786 1819876483 Main 0 SQL (2) SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an error. 787 1819876483 Main 0 SQL (2) OLEDB: AUTOCOMMIT turned ON for connection id 6 788 1819876483 Main 0 SQL (2) OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 6 789 1819876483 Main 0 SQL (2) OLEDB: AUTOCOMMIT turned OFF for connection id 6 790 1819876483 Main 0 SQL (2) 791 1819876483 Main 0 SQL (2) OLEDB_48: Prepared: on connection 6 792 1819876483 Main 0 SQL (2) SELECT * FROM "LZS"."customer" 793 1819876483 Main 0 SQL (2) 794 1819876483 Main 0 SQL (2) ERROR: Expression using equals (=) has components that are of different data types. OLEDB: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* on connection 6 795 1819876483 Main 0 SQL (2) NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.18 seconds cpu time 0.01 seconds

Rohit12 · ‎09-01-2017

I am trying to delete the data from customer table where start_date is in datetime .It has values like Start_date 2017-09-01 00:00:00.000 2017-09-01 00:00:00.000 2017-09-01 00:00:00.000 2017-09-01 00:00:00.000 %macro lzlib; LIBNAME LZZ OLEDB BULKLOAD=YES DBCOMMIT=0 CURSOR_TYPE=STATIC BL_KEEPIDENTITY=YES BL_KEEPNULLS=NO DIRECT_EXE=DELETE PROPERTIES=('Integrated Security'=SSPI 'Persist Security Info'=TRUE 'Initial Catalog'=Customer_account) PROMPT=NO REREAD_EXPOSURE=NO PROVIDER=SQLOLEDB DATASOURCE="dwh-i-sql" SCHEMA=DZS ROWSET_SIZE=32767 UPDATE_MULT_ROWS=YES PRESERVE_GUID=yes; proc sql; delete from LZZ.customer where start_date=1819843200; QUIT; %mend; Below is the error that is coming ERROR: Open cursor error: ICommand::Execute failed. : The requested properties cannot be supported. Thanks!!

Rohit12 · ‎08-30-2017

All the constraints are fine .I am not able to undertsand what the error is

Rohit12 · ‎08-30-2017

I am trying to insert a data in SQL server table using SAS Below is the code that I have written %macro lzlib; LIBNAME LZZ OLEDB BULKLOAD=YES DBCOMMIT=0 CURSOR_TYPE=STATIC BL_KEEPIDENTITY=YES BL_KEEPNULLS=NO DIRECT_EXE=DELETE PROPERTIES=('Integrated Security'=SSPI 'Persist Security Info'=TRUE 'Initial Catalog'=Customer_account) PROMPT=NO REREAD_EXPOSURE=NO PROVIDER=SQLOLEDB DATASOURCE="dwh-i-sql" SCHEMA=DZS ROWSET_SIZE=32767 UPDATE_MULT_ROWS=YES PRESERVE_GUID=yes; PROC SQL; INSERT INTO LZZ.CUST_DIM SELECT DATO ,JOBNAME ,RUNDATE ,EXECUTION_STATUS ,COMPARE ,LcOMPARE_RESULT ,OUTPUT_FLAT_FILE_EXISTS ,FOLDER_LINK ,FILE_NAME ,ADD_INFO ,FILE_EXISTS ,HOST_FILE_DOWNLOAD ,FILE_READ ,HOST_FILE_READ ,COMPARE_PROCEDURE ,COMPARE_STATUS ,BASEDATASETOBS ,COMPAREDATASETOBS ,BASEDATASETVAR ,COMPAREDATASETVAR FROM FINAL; QUIT; %mend; This is the error that comes up ERROR: Execute error: IRowsetFastLoad::InsertRow failed. : Unspecified error ERROR: ROLLBACK issued due to errors for data set LZZ.CUST_DIM.DATA. Thanks!!

Rohit12 · ‎07-26-2017

hello Kurt sorry for putting wrong subject Actually one of the values 00000000000529æ having this character æ is not coming correct .The output for this value comes as . But in mainframe it is coming as 52.90 How can I get that .Please guide data want; input mark zd15.2; cards; 00000000134623C 00000000153746E 00000000000085G 00000000017120E 00000000000529æ ; run;

Rohit12 · ‎07-26-2017

Hello I have below data in a file and i want to read in a dataset this is how file looks 00000000134623C 00000000153746E 00000000000085G 00000000017120E Atually I am trying to read this file on SAS eg tool.Actaully thiS program was running on mainframe and they were reading this like this @1 mark S370FZD15.2 I am trying to read it as @1 mark 15.2 but it gives me error I want output to be 13642.33 15374.65 8.57 1712.05 Thanks!!

Online Status	Offline
Date Last Visited	‎07-26-2018 07:42 AM

%if statement not working in macro

exporting a CSV

Re: call a macro through datatep

call a macro through datatep

Re: macro problem

macro problem

Re: concatenate last observation variable value

concatenate last observation variable value

Re: deleting the data

Re: deleting the data

%if statement not working in macro

exporting a CSV

Re: call a macro through datatep

call a macro through datatep

Re: macro problem

macro problem

Re: concatenate last observation variable value

concatenate last observation variable value

Re: deleting the data

Re: deleting the data

deleting the data

Re: insert data into sql table

insert data into sql table

Re: Zoned Decimal informat

Zoned Decimal informat