venkatnaveen Tracker

Re: data step error

venkatnaveen — Tue, 31 Jan 2017 09:57:52 GMT

Thanks a lot.

Superb..!

Re: data step error

venkatnaveen — Tue, 31 Jan 2017 05:11:49 GMT

Yes the task given and I solkved that way.I am unable to get the o/p

data step error

venkatnaveen — Tue, 31 Jan 2017 05:07:41 GMT

Question: Please help in SAS... (this is the data from the d...

Please help in SAS...

(this is the data from the dat file) The info for golf.dat is the one below

Kapalua Plantation 18 73 7263 125.00

Pukalani 18 72 6945 55.00

Sandlewood 18 72 6469 35.00

Silversword 18 71 . 57.00

Waiehu Municipal 18 72 6330 25.00

Grand Waikapa 18 72 6122 200.00

Read the data contained in the golf.dat file using a DATALINES statement into a permanent SAS data set called question02. The data in each record are in order: golf course (name), number of holes (holes), par (par), total yardage (yardage), and greens fees (fees). Print the resulting SAS data set ensuring that the output is centered, your page size is no larger than 58 lines, and the linesize no longer than 80 characters. When you print the data set, do what you need to do, to make it look (exactly) like this:

That is: (1) double space your output, (2) label the variables as in the above output, (3) title the output as it appears above, (4) suppress the printing of the observation number, and (5) make sure that the yardage contains a comma (e.g., 7,263) and the fees are preceded by a dollar sign (e.g., $125.00).

The program I wrote

libname perm "C:\temp";

data perm.question02:

infile datalines dsd ;

informat total_yardage fees;

input golfcourse $ holes par total_yardage comma5. fees comma10.2;

datalines;

Kapalua Plantation 18 73 7263 125.00

Pukalani 18 72 6945 55.00

Sandlewood 18 72 6469 35.00

Silversword 18 71 . 57.00

Waiehu Municipal 18 72 6330 25.00

Grand Waikapa 18 72 6122 200.0

;

run;

Double - double spaces the printed output.

Noobs - suppresses the observation number in the output.

Program2

titile "Question#2";

proc print data =question02 double noobs;

var golfcourse par holes total_yardage fees ;

label par ='Par' holes='No. of holes' total_yardage='Yardage' fees='Greens_Fees';

format total_yardage comma5. fees comma10.2;

run;

I am getting error

Re: using _n_

venkatnaveen — Mon, 14 Nov 2016 03:53:29 GMT

Thanks sir

Re: using _n_

venkatnaveen — Sun, 13 Nov 2016 17:35:24 GMT

question isi have variable x
23
456
78889
23 is odd a new variable message to be creted as odd .Similarlly
456 is even message has to be created even

using _n_

venkatnaveen — Sun, 13 Nov 2016 17:10:20 GMT

I have:

data even_odd;

input x @@;

datalines;

257779 269998 11 20

;

run;

Modify the following data step to create a new variable named as message. The values of the

variable message must be:

‘The integer is odd’ if the variable x in the input statement has odd integer, ‘The integer is even’

if the variable x has even integer.

Should not use mod function

Power curves

venkatnaveen — Mon, 25 Jan 2016 21:32:41 GMT

Construct a power curve for a two-sided t-test with α= 0.01, σ= 8, and n= 10 (total 20 observations) by calculating the power when δ= 0,2,4,6,8,10,12,14 and 16.

proc power

venkatnaveen — Mon, 25 Jan 2016 21:31:37 GMT

Construct a power curve for a two-sided t-test with α= 0.01, σ= 8, and n= 10 (total 20 observations) by calculating the power when δ= 0,2,4,6,8,10,12,14 and 16.

Re: Use of Substr or Scan

venkatnaveen — Thu, 21 Jan 2016 12:19:18 GMT

Actually there is data inconsistency.

Re: Use of Substr or Scan

venkatnaveen — Thu, 21 Jan 2016 12:16:52 GMT

Thanks a lot.

Use of Substr or Scan

venkatnaveen — Wed, 20 Jan 2016 12:02:37 GMT

Hi I need some help. I have the variable like site with values

Site

CT-BENGALURU-J.P.NAGAR

CT-BENGALURU-ORION MALL

CT-BENGALURU-SOUL SPACE SPIRIT

CT-MUMBAI-GOREGAON-OBEROI MALL

CT-PUNE-ASCENT MALL

CT-PUNE-MSM PARANJAPE MALL-KARVE ROAD

I want output like

J.P.NAGAR

ORION MALL

SOUL SPACE SPIRIT

OBEROI MALL

ASCENT MALL

PARANJAPE MALL

How to do factor analysis

venkatnaveen — Mon, 21 Sep 2015 20:37:18 GMT

I was working on linear regression where I have approx 140 variables data set out of which 93 are categorical variable.

I am not able to get how we do factor analysis for these variables.

Im using proc Factor for numerical variables and categorical variables

For age I have age varlable i want to categorise 1-15 as 1

16-30 as 2,30-rest as 3.
But like this i cannot do for all 93 categorical variables?

How to approach to this problem?

Help needed for writing code for resolving issue

venkatnaveen — Mon, 27 Apr 2015 08:46:35 GMT

Hi I have credit card approve/decline tables with one table contains last 8months data, so i have an other table of this month who has appiled for credit card,so what is my requirement is i wanna check weather the customer has already have a card r not ,if he is having i wanna decline tht customer to approve new credit card,so what i want to do is i wanna check latest table (i.e this month table where customer applied for new credit card ,assume tht it contain 10 thousand custumer records) ,to last 8months table(assume tht it contain 1millon customer records),here i enclosing some sample table for example

/*assume tht its last 8months table which have 1million records*/

data table1;
input custid name$ salary pan$ aprvdate ;
informat aprv anydtdte.;
format aprv ddmmyy10.;
cards;
001 john 200000 AAAAAA 02/02/2014
002 raju 300000 BBBBBB 01/01/2013
002 raju 400002 BBBBBB 01/01/2014
003 david 600000 CCCCCC 04/04/2013
004 krishna 203030 DDDDDD 05/02/2015
005 mukesh 240000 EEEEEE 04/03/2014
003 david 782226 CCCCCC 08/05/2014
;
run;

/*assume that it contains current table whose wanna apply for new credit cards which contain 10thousand records*/

data table2;
input custid name$ salary pan$ aprv :anydtdte.;
format aprv ddmmyy10.;
cards;
002 raju 400000 BBBBBB 12/05/2015
005 mukesh 240000 EEEEEE 12/05/2015
003 david 782226 CCCCCC 01/7/2015
run;

Note :in table one the custmer raju and david had taken 2 cards ,they were already approved ,and check sal and date of approve ,for eg:raju taken cards on 01/01/2013 when his sal was 300000 again he applied for cards in 01/01/2014,again this card was approved and his sal aslo incresed,but in 12/05/2015 again he is applying for new credit cards,so i wanna check with previous table will this guy had already card/not,based on tht i wanna decline this card,and i wanna show my client reason why i m decline,i wanna result should be like this
002 raju 300000 BBBBBB 01/01/2015
002 raju 400002 BBBBBB 01/01/2015
002 raju 400000 BBBBBB 12/05/2015

so this i can show my client where he taken has taken card on 01/01/2013,again by mistakely we approved his card when he applied in 2014,so again this time he is applying for new card on 2015 ,so i gonna decline his application,even mukesh and david is already had card again he is applying in 2015 so i wanna decline him,
i wanna output like his

002 raju 300000 BBBBBB 01/01/2015
002 raju 400002 BBBBBB 01/01/2015
002 raju 400000 BBBBBB 12/05/2015
003 david 600000 CCCCCC 04/04/2013
003 david 782226 CCCCCC 08/05/2014
003 david 782226 CCCCCC 01/7/2015
005 mukesh 240000 EEEEEE 04/03/2014
005 mukesh 240000 EEEEEE 12/05/2015

so i wanna get output like this based on tht i can show my client these were the customer who had already got cards again they were applying,

Assume u have to compare 10thousand records with 1 milon records of previoud month,and pan number will be unique so based on tht we can catch up,

so plz write a code to resolve this kind of issue

Help needed to run sas code on server?

venkatnaveen — Sat, 11 Apr 2015 07:21:11 GMT

Good Morning.

I need a help.I have to run a piece of sas code on a remote server using C#.Net from my local PC.Is there any way to do this?

Re: help needed with import of text file using infile

venkatnaveen — Mon, 06 Apr 2015 03:29:39 GMT

Thanks Arthur.But,what is trmstr='lF' option and why individually writing of informat statement .cant we mention with a colon modifier :

help needed with import of text file using infile

venkatnaveen — Sun, 05 Apr 2015 19:31:58 GMT

I tried the below code

But i am not getting the. result.I need some help.Is there any other method.help me out please

DATA Sara2013;

INFORMAT Date YYMMDD10. Time $5. ;

FORMAT Date YYMMDD10. Time $5. ;

INFILE 'C:\nav\2013_Satisfaction_Survey_Sara (4).txt'

LRECL=32767 dsd dlm='' truncover firstobs=2;

INPUT @1 Date: YYMMDD10. @12 Time : $5.

@18 Interviewer :$4. @23 Age :$2. @26 Gender :$1. @28 Address: &$18. @48 FirstTime :$6. @52 ComeAgain :$5. WhyNot: $11. (Sat1-Sat8)(:$3.) Comments :$50.;

;

RUN;

Re: Unable to import tab file using infile statement?

venkatnaveen — Thu, 02 Apr 2015 12:13:28 GMT

Thanks to all.

I made the corrections as per ur suggestions and got correct answer.

Re: Unable to import tab file using infile statement?

venkatnaveen — Thu, 02 Apr 2015 11:43:40 GMT

Thanks.I have attached zip file too.

Re: Unable to import tab file using infile statement?

venkatnaveen — Thu, 02 Apr 2015 11:38:41 GMT

Thanks Data_null_,

But I am getting some missing records.I have modified code.

DATA Moss2013;

LENGTH Address $ 24 Comments $ 50 ;

INFORMAT Date YYMMDD10. Time $7. ;

FORMAT Date YYMMDD10. Time $7. ;

INFILE 'C:\nav\2013_Satisfaction_Survey_Moss.tab'

LRECL=32767 DLM='09'x truncover DSD firstobs=2;

INPUT Date: YYMMDD10. Time : $7.

Interviewer :$9. Age Gender :$3. Address: $24. FirstTime :$6. ComeAgain :$5. WhyNot: $11. Sat1 :$6. Sat2:$6. Sat3:6. Sat4:$6.

Sat5 :$6. Sat6 :$6. Sat7 :$6 Sat8 :$6. Comments :$50.;

;

RUN;

proc printto log='C:\nav\errors.log';

run;

proc printto;

run;

Here with I am attching the errors file too

Unable to import tab file using infile statement?

venkatnaveen — Thu, 02 Apr 2015 04:28:54 GMT

Hi I am unable to import tab file

Here is the code

DATA Moss2013;

LENGTH Address $ 24 ;

INFORMAT Date YYMMDD10. Time $7. ;

FORMAT Date YYMMDD10. Time $7. ;

INFILE 'C:\nav\2013_Satisfaction_Survey_Moss.txt'

LRECL=32767 DLM='09'x MISSOVER DSD firstobs=2;

INPUT Date: YYMMDD10. Time : $7.

Interviewer :$9. Age Gender :$3. Address: $24. FirstTime :$6. ComeAgain :$5. WhyNot $11. Sat1 :$6. Sat2:$6. Sat3:6. Sat4:$6.

Sat5 :$6. Sat6 :$6. Sat7 :$6; Sat8 :6. Comments :$19.;

;

RUN;

The data is like given below:

Date Time Interviewer Age   Gender      Address     FirstTime   ComeAgain   WhyNot      Sat1 Sat2 Sat3 Sat4 Sat5 Sat6 Sat7 Sat8 Comments
2013-10-09 12:15 Moss 65    M     Stanardsville, VA NO    YES        3     3     3     3      3     3     4     4     no parking
2013-10-12 12:38 Moss 28    F     Crozet, VA NO    YES        N/A   1     3     4     4      3     N/A   3
2013-10-07       Moss 49    F     Thurston, VA      YES   DK         4     3     3     4      3     N/A   N/A   3