manojinpec Tracker

Re: Load .WPD file to SAS as SAS7BDAT

manojinpec — Wed, 06 Sep 2017 10:44:40 GMT

Hi,

Could you please let me know what specific problems you have encountered when you create a SAS7BDAT file from WPS.

Regards,

manoj Bansal

Reading Version 8 sas datasets in version 9

manojinpec — Mon, 30 Dec 2013 08:09:50 GMT

Hi,

When i am trying to read dataset created in version 8 in version 9.3 i am getting following error:-

ERROR: Invalid header on file abc.data

Please advice.

Different Between SAS 8.2 and SAS 9.3

manojinpec — Thu, 07 Nov 2013 04:51:27 GMT

Hi,

Is there any document which would highlight the difference in SAS 8.2 and 9.3 which can be used for preparing presentation to senior management.

Re: Count with left

manojinpec — Wed, 12 Jun 2013 06:29:14 GMT

what is the error your getting? I think you cannot use %left function . What you can do %let cnt=%trim(&cnt) before the second query.

Re: SAS Installation Issue

manojinpec — Wed, 12 Jun 2013 06:23:30 GMT

There would be some option for client if you scroll down.

Re: branch wise excel file using macro

manojinpec — Fri, 07 Jun 2013 11:30:33 GMT

I see you are in gurgaon. You can reach me @9560771148 and i would be happy to explain further.

I have created a macro variable abc which uses the dataset test having the information of brnach_code etc.

Now i have created a macro variable n which contains total number of distinct brnach code.

Now the do loop runs the code for n number of times for each brnanch code.

Re: A Lock is not available..

manojinpec — Fri, 07 Jun 2013 11:09:55 GMT

If this is running on unix you need to kill the process by assigning command kill and process id.

Re: branch wise excel file using macro

manojinpec — Fri, 07 Jun 2013 10:07:18 GMT

%macro abc;

data test;

branch_code=100;

cust_name='a';

revenue=25000;

output;

branch_code=200;

cust_name='b';

revenue=2500;

output;

branch_code=200;

cust_name='c';

revenue=25000;

output;

branch_code=300;

cust_name='d';

revenue=5000;

output;

run;

proc sql;

select count(distinct(branch_code)) into :n from test;quit;

%let n= %trim(&n);

proc sql;

select distinct(branch_code) into :branch_code1-:branch_code&n from test;

quit;

%do i=1 %to &n;

data branch_&&branch_code&i. ;

set test;

if branch_code="&&branch_code&i." ;

run;

%end;

%mend;

%abc

Since dataset name cannot start with number i have prefixed with brnach

Re: Issue with data set variable's data type

manojinpec — Fri, 08 Mar 2013 10:16:10 GMT

Try concatenating it with 00:00:00 and give the variable format at datetime . I don't have any oracle backend otherwise would have tried and then sent the code

Re: Issue with data set variable's data type

manojinpec — Fri, 08 Mar 2013 09:57:30 GMT

Hi Rohit,

The SAS is passing numeric date value.However oravle interpret it as number of seconds after 01jan1960. Try passing datetime variable for 01APR2012 00:00:00.

Re: Introducing ourselves

manojinpec — Fri, 01 Feb 2013 06:48:25 GMT

Hi i am Manoj Bansal and I am SAS Professional

Re: MONNAME3.

manojinpec — Fri, 01 Feb 2013 06:37:52 GMT

Please note that 01jan1960 is 0. So 31 would be 01 feb 1960. that is why it is giving feb. 60 would give mar only. as 60 would be march date.

Re: SAS E-MINER

manojinpec — Fri, 01 Feb 2013 05:40:18 GMT

Hi Sanket,

Please forward me to er.manoj@gmail.com if you get any docs.

Re: MONNAME3.

manojinpec — Fri, 01 Feb 2013 05:39:41 GMT

Hi,

Format is applied on the date value.SAS Consider this numbers as date and output the month for the data. It consider it as dates of Jan1960.

Thanks,

Manoj Bansal

Re: proc sort

manojinpec — Mon, 28 Jan 2013 04:23:09 GMT

Do you want soem real example?

Re: question on micro variable

manojinpec — Tue, 15 Jan 2013 11:05:43 GMT

Hi Ashwini,

you cannot use the variable in same data step

Re: Querying SAS Data from Outside SAS

manojinpec — Thu, 10 Jan 2013 10:14:45 GMT

you can also buy license for sas connection to that paricular database

Re: Help connecting to Teradata through a libname statement.

manojinpec — Thu, 03 Jan 2013 09:52:24 GMT

Can you please post teradata string?

Re: SAS deployment Manager

manojinpec — Wed, 02 Jan 2013 06:53:17 GMT

what is environment where you are installing ?

Re: EXCEL LOOKUP function equivalent in SAS

manojinpec — Tue, 20 Nov 2012 10:05:51 GMT

yes you can do that.http://www.nesug.org/proceedings/nesug08/cc/cc19.pdf