About shellp55

shellp55 · ‎07-11-2018

I wasn't sure about what you were advising but I found that all I needed to do was to copy the filename, libname and let statement for the database to above the %include line and it runs as it should. Thanks.

shellp55 · ‎07-11-2018

The other program imports data from two locations and merges them, exports to a database and is saved to a specific library. So I assume I would use %include to indicate the program I want to run, but I want to know how to identify the location of M_regrp and Y_regrp files, the library name to save the dataset to and the database to export the table to. Those are the settings being passed to the called report.

shellp55 · ‎07-11-2018

Not sure I know what you're asking but each hospital with have a different location for the file location of M_regrp and Y_regrp as well as different locations for the library name and the export_file. So I want to pass those to the report via the other report that calls the program.

shellp55 · ‎07-11-2018

The report in question (regrp) is actually used for many hospitals and I have them all in the code and just comment out the sites I don't want at the time I run it. So rather than have multiple copies of regrp to call for each site from this other program, I thought it would be easier to call it from another program that I have to run that uses the resulting dataset from the regrp program.

shellp55 · ‎07-11-2018

Hello I am using SAS 9.4. I have a program called "regroup" that indicates the location of two sets of text documents plus an export file name as %let export_file: Libname mylib 'C:\SAS Datasets'; filename M_regrp('C:\text data\monthly\.*txt'; filename Y_regrp('C:\text data\yearly\*.txt'; %let export_file="C:\sas_data.mdb"; I wish to call the regroup from another program and pass the 4 settings above from the other program. How do I do that? Thanks.

shellp55 · ‎01-15-2018

Thank you so much! "Taming" is a great description and I will certainly tuck this code away for another day. Thanks for taking the time to respond.

shellp55 · ‎01-15-2018

Great, thanks Reeza!!

shellp55 · ‎01-15-2018

I'm trying to use the if statement with this and I am getting an error of "statement is not valid or it is used out of proper order.

shellp55 · ‎01-15-2018

Interesting, thanks. I was building off of a previous response on this forum to rename fields for a single site which involved a macro. Glad to know it can be so much simpler, thanks.

shellp55 · ‎01-15-2018

I am not sure what you are suggesting Reeza. The data comes from the main DAD data file per site. At the very least can you advise how to successfully use the in statement and save the variables i.e. with or without quotation marks? With or without commas? etc. Thanks.

shellp55 · ‎01-15-2018

Reeza, I have many hospitals' data and it is in different formats and some fields are named differently. I actually have many of the same report per site which is labour intensive when I have to update so I would like one report where I enter the site in a variable and the report produces only for that site, I change the variable and run again. In this instance, the field of CCI status is different for some sites versus others so I wanted to use the same rename macro as always BUT have an if statement as to what field to rename depending on the site. If it is sites a, b and c then the source field for the status&i = pxattr&i else the source is pxstat&i. Thanks.

shellp55 · ‎01-15-2018

Thanks for the speedy reply but the same error message is showing up "required operator not found in expression: &inst_no. in (&incl_list).

shellp55 · ‎01-15-2018

Hello I am using SAS 9.3. I have a report where the sources for the same report may differ so I need to rename some fields. So if the variable field of inst_no includes those in the incl_list then rename using one field otherwise use another field. Below is wrong but I've been working on this forever so hopefully someone can help. Thanks. %let inst_no=5555; %let incl_list=3333, 4444, 5555, 6666; %macro renm1; %if &inst_no. in (&incl_list) %then %do I = 0 %to 20; status&i=pxattr&i; else %do i = 0 %to 20; status&i=pxstat&i; %end; %mend; Data have; set mydata; rename %renm1; run;

shellp55 · ‎10-04-2017

Thanks Reeza but it will take awhile to de-identify my data. I think you are correct that it is the blank values because I changed my test data so that there is no data in _proc1 and _date1 and it erroneously flagged the case as matching my criteria. i'm trying to use if not missing(px1) to include an 'else if missing(_proc1(i)) then leave but I get an error that I do not have a matching do/select statement.

shellp55 · ‎10-04-2017

Thanks Reeza! I've tried the code in various spots but it still shows as zero cases and I know there are some matching the criteria. I've used: do I = 1 to dim(_proc1); find_index=whichc(_proc1(i) of _proc2(*)); if missing(_proc1(i)) then leave; else if find_index>0 then do; if _date1(i)=_date2(find_index) then flag=1; end; end;

Online Status	Offline
Date Last Visited	‎11-26-2023 11:40 PM

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Exporting SAS dataset to MS-Access

Re: Memo Field in First Row of Excel Export?

Memo Field in First Row of Excel Export?

Re: Creating Export Name from Variables?

Re: Creating Export Name from Variables?

Re: Exporting Data to Acess - Error

Re: Exporting Data to Acess - Error

Re: Rename Macro Do Loop Where Value is 1 Less than Current Occurence

Re: ODS Excel tagattr not working for data types/formats

Re: Calling SAS code from another SAS program including passing variab...

Re: Calling SAS code from another SAS program including passing variab...

Re: Calling SAS code from another SAS program including passing variab...

Re: Calling SAS code from another SAS program including passing variab...

Calling SAS code from another SAS program including passing variables?

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Re: Macro using IF, THEN and ELSE, variable with in operator and do lo...

Macro using IF, THEN and ELSE, variable with in operator and do loop

Re: Comparing Arrays in same dataset?

Re: Comparing Arrays in same dataset?