praveensawh's articles:

Items(11) /2 Next >> Last >|

PROC TABULTE question - hide missing class columns and compute nested percentages 1 6 (4/8/2013 3:23:55 PM) comp.soft-sys.sas Hi, I have 2 questions. My dataset is the output of a summary sql query (using count and group by).= It has a count of events, a few categorical variables (agency, year, event= _type) and a few flags (... Praveen

Importing excel files in 64-bit with SAS 9.3 7 101 (9/2/2011 5:54:56 PM) comp.soft-sys.sas Hi, We recently upgraded to a 64-bit environment. We soon found out that SAS 9.2 cannot import excel files in a 64-bit environment. So we upgraded to SAS 9.3 64-bit hoping to remedy the situation, but it sti... Praveen

proc tabulate and cross tab percentages 1 29 (6/3/2011 7:00:30 PM) comp.soft-sys.sas Hi, I am trying to get proc tabulate to show nested percentages, where each block is 100%. My code is: ODS LISTING CLOSE; ODS HTML; PROC TABULATE DATA=summary NOSEPS; KEYLABEL ALL = 'Total' N = 'n' COLP... Praveen

executing a piece of code stored in a macro variable 2 26 (4/28/2011 1:04:13 AM) comp.soft-sys.sas Hi there, I would like to execute a piece of code stored in a macro variable. For example, I have the following stored in &code: %DO %WHILE (&dloop1 <= 9); %PUT &dloop1; %LET dloop1 = %EVAL(&dloop1 + 1); %END... Praveen

SUB character and blank rows on CSV import 2 19 (2/8/2010 10:20:29 PM) comp.soft-sys.sas I am importing CSVs with SUB (Unix EOF) characters at the end of each file (in its own row). I clean it before importing by doing something like: if c = '1a'x then c = ''; put c; in a null data step... Praveen

Joining regular IDs to ID lists - Takes forever! 1 24 (2/3/2010 11:30:23 PM) comp.soft-sys.sas Our database contains IDs in 2 formats. An ID appears in a table either as: 1) a normal id 2) in a comma separate list of ids (string) I am using the FIND function in the JOIN condition when joining tables. ... Praveen

How to reference the value of a variable inside a REGEX? 2 155 (1/8/2010 10:14:26 PM) comp.soft-sys.sas I want to join 2 tables on the condition that variable X from Table 1 appears in a comma separated list character variable in Table 2. What is the best way to approach this? I was trying to use REGEX in ... Praveen

FIRST.variable in SQL? 2 19 (9/19/2009 8:53:08 PM) comp.soft-sys.sas Hi guys, I searched the archives for an answer but did not have any luck. I would like to know what is the best way to achieve SAS's FIRST and LAST feature in SQL? ... Praveen

Integrity checking 4 23 (8/31/2009 9:30:37 PM) comp.soft-sys.sas Say I have a data set and I want to test if the number of rows in this dataset is 0. I want to use %IF and %PUT statements so I can %PUT ERROR: message etc. I don't much about this side of SAS (programming o... Praveen

id lists 1 25 (8/28/2009 6:03:53 PM) comp.soft-sys.sas I am working with a dataset that has id lists. So for instance one table has the following 3 ids - tablepk_id adult_id child_id. The tablepk_id is the unique id for that table. The other 2 ids are actually c... Praveen

praveensawh's replies:

Items(10) /1

Re: Side by Side SAS Installations #3 1 17 (8/26/2009 5:29:36 PM) comp.soft-sys.sas Thanks Nat. Yes, I just found the following docs as well. Guess I should have searched first. Sorry for the extra email! Kevin M. http://support.sas.com/rnd/migration/papers/peaceful.html http://support.sa... KevinMyers (191)

id lists 1 25 (8/28/2009 6:03:53 PM) comp.soft-sys.sas I am working with a dataset that has id lists. So for instance one table has the following 3 ids - tablepk_id adult_id child_id. The tablepk_id is the unique id for that table. The other 2 ids are actually c... praveensawh (29)

Integrity checking 4 23 (8/31/2009 9:30:37 PM) comp.soft-sys.sas Say I have a data set and I want to test if the number of rows in this dataset is 0. I want to use %IF and %PUT statements so I can %PUT ERROR: message etc. I don't much about this side of SAS (programming o... praveensawh (29)

Re: Joining regular IDs to ID lists - Takes forever! 1 20 (2/5/2010 10:26:33 PM) comp.soft-sys.sas I wouldn't disagree about the efficiency of the INDEX() function relative to your application of the FIND() function, but I'd say that the "Take's forever" feature of your program may have more to do with datab... HERMANS1 (2698)

SUB character and blank rows on CSV import 2 19 (2/8/2010 10:20:29 PM) comp.soft-sys.sas I am importing CSVs with SUB (Unix EOF) characters at the end of each file (in its own row). I clean it before importing by doing something like: if c = '1a'x then c = ''; put c; in a null data step... praveensawh (29)

Macro "retuning" values 8 195 (9/8/2010 8:32:10 PM) comp.soft-sys.sas Hi, I have a meta table where I keep info about our database. An example of this meta information is whether or not a variable is a primary key. Since we often want to find the primary key of a table, I ... Praveen

executing a piece of code stored in a macro variable 2 26 (4/28/2011 1:04:13 AM) comp.soft-sys.sas Hi there, I would like to execute a piece of code stored in a macro variable. For example, I have the following stored in &code: %DO %WHILE (&dloop1 <= 9); %PUT &dloop1; %LET dloop1 = %EVAL(&dloop1 + 1); %END... praveensawh (29)

proc tabulate and cross tab percentages 1 29 (6/3/2011 7:00:30 PM) comp.soft-sys.sas Hi, I am trying to get proc tabulate to show nested percentages, where each block is 100%. My code is: ODS LISTING CLOSE; ODS HTML; PROC TABULATE DATA=summary NOSEPS; KEYLABEL ALL = 'Total' N = 'n' COLP... praveensawh (29)

Importing excel files in 64-bit with SAS 9.3 7 101 (9/2/2011 5:54:56 PM) comp.soft-sys.sas Hi, We recently upgraded to a 64-bit environment. We soon found out that SAS 9.2 cannot import excel files in a 64-bit environment. So we upgraded to SAS 9.3 64-bit hoping to remedy the situation, but it sti... praveensawh (29)

PROC TABULTE question - hide missing class columns and compute nested percentages 1 6 (4/8/2013 3:23:55 PM) comp.soft-sys.sas Hi, I have 2 questions. My dataset is the output of a summary sql query (using count and group by).= It has a count of events, a few categorical variables (agency, year, event= _type) and a few flags (... praveensawh (29)