About siddharthpeesary

siddharthpeesary · ‎02-01-2016

Thank you so much ...It worked 🙂

siddharthpeesary · ‎02-01-2016

yeah I also have character variables FIELDS= 100+ RECORDS=1000-2000

siddharthpeesary · ‎02-01-2016

Hi all, I have a dataset A B C D E 1 2 3 1 2 1 2 3 1 2 1 2 3 1 2 1 2 3 1 2 1 2 3 1 2 I have to run a code in such a way that it should give me the list of fields that are 100%matched in one output ex: A,D B,E are same There is any way I can do it. Thanks

siddharthpeesary · ‎12-15-2015

These the above error i am getting when i use it @Tom

siddharthpeesary · ‎12-15-2015

libname mydblib odbc datasrc=ALMDATA user=Siddharth password=ALM63Floor schema = dbo; actually i use the above code to pull data from mssql so we ca also use the ODBC code to puul from XLSX file then?

siddharthpeesary · ‎12-15-2015

Actually it is on windows. i dont know what i am doing wrong , actually it so simple statement libname workbk2 'C:\Users\speesary\Desktop\programs\sas programs\ddaoutput\oct_dda\DDA_exclusion.xlsx' ;

siddharthpeesary · ‎12-15-2015

It is giving the above out put so i think i have SAS/ACCESS Interface to PC Files

siddharthpeesary · ‎12-15-2015

ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement i have to change any settings ? in FILE -> IMPORT DATA

siddharthpeesary · ‎12-15-2015

there is any way I can use infile statement for XLSX file like ex: data imp; infile "PATH\DDA_exclusion.csv" FIRSTOBS=2 dsd truncover ; input CISNO: SVINTERNALACCNAME:$35. ; format CISNO z15.; run;

siddharthpeesary · ‎12-15-2015

can you please tell me the example code if possible

siddharthpeesary · ‎12-15-2015

Hi all, I am trying to import XLSX file in sas, But i have a FIle with attribute CISNO with values ~4.0161128E12(4016112842745) which i have to convert into z15. format while imorting it it is possible? if it is can anyone tell me the code. It will be very helpful Thanks

siddharthpeesary · ‎11-25-2015

Kiwi I have to check the existence of file inside the sas job

siddharthpeesary · ‎11-25-2015

Atually i want to write sas program required to create a file in database, then i want to use a time schedule from windows

siddharthpeesary · ‎11-25-2015

I will check it thanks

siddharthpeesary · ‎11-25-2015

I like to run sas job on PC(windows)

Online Status	Offline
Date Last Visited	‎02-03-2016 03:26 PM

Re: Automating the comparison on fileds in same dataset

Re: Automating the comparison on fileds in same dataset

Automating the comparison on fileds in same dataset

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: FIND numeric in chracter coloumn

Re: import multiple excel files into sas: with less steps

Re: Automating the comparison on fileds in same dataset

Re: Automating the comparison on fileds in same dataset

Automating the comparison on fileds in same dataset

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

Re: INFORMAT while importing XLSX in sas

INFORMAT while importing XLSX in sas

Re: Automatic scheduler for SAS job

Re: Automatic scheduler for SAS job

Re: Automatic scheduler for SAS job

Re: Automatic scheduler for SAS job