About praveenkotte

praveenkotte · ‎02-27-2017

it was one of the interview question that i was asked for..

praveenkotte · ‎02-27-2017

I've dataset name called sales I want sort data without using proc and first.var and last.var; data tab; input country; cards; 1 3 2 5 6 1 5 4 ; run; could you please help me out....

praveenkotte · ‎10-17-2016

it is one of the interview question that i was asked in one company.

praveenkotte · ‎10-17-2016

I want to create new data set for each obseravtion from sashelp.class using dynamic macros code? hot coding: data ds ds1 ds2 ds3----- ds19; set sashelp.class; if _n_=1 then output ds; else if _N_=2 then output ds1; and so on else output ds19; run ; i want to perform above task to be throught macros

praveenkotte · ‎07-28-2016

I have data like this. Data ds; Infile datalines; Input idno name&$30. Team $ strtwght endwght ; Datalines; 1331 Jason Schock paul Long blue 187 172 1067 Kanoko john rav Nagasaka green 135 122 1251 Richard roy granny Rose blue 181 166 1192 Charlene tin Armstrong yellow 152 139 1352 Bette Schock green 156 137 1262 Yao Chen Garg blue 196 180 1124 Adrienne Fink green 156 142 ; i nedd to get middle names of name variable the ouput should be like this; middlenames only Jason Schock paul Long ---------->Schock paul(middle name) Run;

praveenkotte · ‎07-27-2016

i sorted sashelp.class based on sex variable.i want to get last 3 record each by group wise? Ronald M 15 67 133 Judy F 14 64.3 90 Name Sex Age Height Weight Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Jane F 12 59.8 84.5 Janet F 15 62.5 112.5 Joyce F 11 51.3 50.5 Judy F 14 64.3 90 Louise F 12 56.3 77 Mary F 15 66.5 112 Alfred M 14 69 112.5 Henry M 14 63.5 102.5 James M 12 57.3 83 Jeffrey M 13 62.5 84 John M 12 59 99.5 Philip M 16 72 150 Robert M 12 64.8 128 Ronald M 15 67 133 Thomas M 11 57.5 85 William M 15 66.5 112

praveenkotte · ‎07-27-2016

get only last 3rd record from last record based on by group variable sex from sashelp.class dataset?

praveenkotte · ‎07-20-2016

i've tried these two codes. but instead of using libname statement, i should pull out the data using proc import or else proc sql. proc sql; connect to excel(path="C:\Users\siddiq\Desktop\Book1.xls"); create table tab as select * from connection to excel ( select * from [sheet1$] ); disconnect from excel; quit; proc import datafile="C:\Users\siddiq\Desktop\book1.xls" out=dd dbms=excel replace; run;

praveenkotte · ‎07-20-2016

I need to extract this data from excel file. the thing is, in the below variables the date variable consists of both numeric and charater data type. while iam reading into sas ,i am getting only few records. i should get all records into sas data set. could you please help me ? the below attchement consists of sample of my data. thanks in advance Date particulars chequeNO/OrderNo 23/06/06 received 234554 11/8/2006 received 798242 12/8/2006 received 985795 20/08/06 received 298489 26/08/06 received 988323 28/08/06 received 248927 31/08/06 received 598332 5/9/2006 received 284729 3/9/2006 received 287492 15/9/2006 received 279872 1/9/2006 received 258202 2/9/2006 received 928590 1/11/2006 received 209842 5/12/2006 received 595972 5/12/2006 received 902892 20/12/06 received 298297

praveenkotte · ‎07-19-2016

hey thanks. Now i gor correct output. data tables (drop = i j); array table{10} table1-table10; do i = 1 to 10; do j = 1 to 10; table{j} = i * j; end; output; end; run;

praveenkotte · ‎07-18-2016

thanq for ur reply.BUT ur code is not giving required result;

praveenkotte · ‎07-16-2016

i want to create mathematical tabels from 1 to 10 ? the ouput should be like this one_table two_table three_table ---------- ten_table 1 2 3 10 2 4 6 20 3 6 9 30 4 8 12 40 5 10 15 50 6 12 18 60 7 14 21 70 8 16 24 80 9 18 27 90 10 20 30 100

praveenkotte · ‎07-16-2016

i want create mathematical tabels from 1 to 10 ? the ouput should be like this one_table two_table three_table ---------- ten_table 1 2 3 10 2 4 6 20 3 6 9 30 4 8 12 40 5 10 15 50 6 12 18 60 7 14 21 70 8 16 24 80 9 18 27 90 10 20 30 100

Online Status	Offline
Date Last Visited	‎02-27-2017 06:50 AM

Re: how to sort data without using proc step and first.var and last.v...

how to sort data without using proc step and first.var and last.var?

Re: subsetting each row into new dataset using macros?

subsetting each row into new dataset using macros?

extracting middle names from a variable?

Re: get only last 3rd record from last record based on by group variab...

get only last 3rd record from last record based on by group variable ...

Re: importing data when variable has different data types in excel sh...

importing data when variable has different data types in excel sheets...

Re: i want to create mathematical tabels from 1 to 10 ?

Re: how to sort data without using proc step and first.var and last.v...

Re: extracting middle names from a variable?

Re: how to sort data without using proc step and first.var and last.v...

how to sort data without using proc step and first.var and last.var?

Re: subsetting each row into new dataset using macros?

subsetting each row into new dataset using macros?

extracting middle names from a variable?

Re: get only last 3rd record from last record based on by group variab...

get only last 3rd record from last record based on by group variable ...

Re: importing data when variable has different data types in excel sh...

importing data when variable has different data types in excel sheets...

Re: i want to create mathematical tabels from 1 to 10 ?

Re: i want to create mathematical tabels from 1 to 10 ?

i want to create mathematical tabels from 1 to 10 ?

i want create mathematical tabels from 1 to 10 using sas?