learner_sas Tracker

NYU ED Algorithm using SAS

learner_sas — Wed, 14 Dec 2016 14:28:51 GMT

Hello Everybody,

I am trying to replicate NYU ED Algorithm using SAS. On searching online, I found some links

http://talkdisease.blogspot.com/2015/08/how-you-can-apply-ed-algorithm.html

http://wagner.nyu.edu/faculty/billings/nyued-background

But not SAS codes. I am wondering if any of you have links or documents using SAS. There is github link using SQL but wanted to see anybody has SAS code also.

Re: update blank columns from existing columns

learner_sas — Sat, 03 Sep 2016 11:31:02 GMT

Thank you @Ksharp. It worked for me.

Re: update blank columns from existing columns

learner_sas — Fri, 02 Sep 2016 23:41:37 GMT

@ballardw thank you. Will make sure from next time. Below is the input file. I want to update any missing dignosis between DX1-DX10 using DX11-DX13.

data WORK.TXTFILE;
infile datalines dsd truncover;
input ID:BEST6. DX1:$7. DX2:$7. DX3:$6. DX4:$6. DX5:$5. DX6:$6. DX7:$6. DX8:$5. DX9:$5. DX10:$5. F12:$1. F13:$1. DX11:$5. DX12:$5. DX13:$5.;
datalines4;
147140,O700,O76,Z3A39,Z370,,,,,,,,,D500,D62,D589
141275,I639,I674,F0150,I5042,E854,I10,F17210,I739,I680,K0530,,,Z7982,Z8673,Z9114
120744,O1092,O365930,Z3A40,O99333,O76,O9089,L03311,Z370,O0933,Z23,,,,,
151870,J9621,N170,J9622,R6521,I4901,I4892,I482,I480,B182,B9689,,,D500,D62,D589
161280,Z3831,P0724,P5222,P780,P369,P220,P779,P610,P912,K2971,,,Q443,P8339,P284
129797,Z3801,P220,P0701,P0724,P3639,G039,P271,K4020,,,,,P748,P742,P744
117110,O80,Z370,Z3A39,,,,,,,,,,,,
147647,O480,D649,O99824,O9902,Z370,Z8751,Z3A40,,,,,,Z7982,Z8673,Z9114
120334,O6981X0,O721,O9832,O480,O481,Z87410,O99214,E6601,Z3A41,,,,Z370,,
;;;;
run;

update blank columns from existing columns

learner_sas — Fri, 02 Sep 2016 20:26:22 GMT

Hello Everybody

I have a table with DX codes from 1 to 13. I received codes dx1-dx10 from one source and DX11-13 from another sources. Now I want to create a final file which has columns upto DX10 with update. since some of the ids do not have DX codes upto 10 I want to update values from DX11-DX13 into DX1-10 when there is no dx code and I have values in DX11-DX13.

Attached documents has current and expected table structure.

Thank you for your help.

copy formula of jmp dataset while import file into sas

learner_sas — Wed, 22 Jun 2016 14:44:59 GMT

Hello group,

I am easily able to import JMP files into SAS dataset with following code

proc import out=ASDH.NO_SAH
datafile='name\NO SAH.jmp'
dbms=JMP replace;
run;

But I am wondering if we can get formula associated with each column into SAS when importing JMP files.

No proper TOC when two SAS Pdf combined in one Combined report

learner_sas — Fri, 25 Mar 2016 12:57:26 GMT

Hello Everybody,

I am using Below SAS code to combine my PDF files . I am using EG 7.1

/* Method 1 */

/* Turn off the Output window */
ods listing close;

/* Open two ODS PDF instances, one creating COMBINED_1.PDF, and the other creating A.PDF */
ods pdf file="combined_1.pdf";
ods pdf(a) file="a.pdf";

proc report nowd data=sashelp.class(obs=10);
   title "In COMBINED.pdf and A.pdf";
run;

/* Close A.PDF, but COMBINED.PDF remains open */
ods pdf(a) close;

ods pdf(b) file="b.pdf";

proc report nowd data=sashelp.vtable(obs=20);
   title "In COMBINED.pdf and B.pdf";
   column libname memname nobs nvar crdate;
run;

ods pdf(b) close;

ods pdf(c) file="c.pdf" ;

proc report nowd data=sashelp.class;
   title "In COMBINED.pdf and C.pdf";
run;

ods pdf(c) close;
ods pdf close;

which is from

http://support.sas.com/kb/35/375.html

I am able to append the pdf files with the no problem but TOC(Table of contents) looks different then what it was for individual PDF. I am wondering what am I missing here.

Re: ods pdf 2 different reports in same page

learner_sas — Tue, 22 Mar 2016 18:27:50 GMT

Something to add here. I have warning in log which says .

"WARNING: Unsupported device 'SASEMF' for TAGSETS.SASREPORT13(EGSR) destination. Using default device 'PNG'." is that the reason.

ods pdf 2 different reports in same page

learner_sas — Tue, 22 Mar 2016 18:21:34 GMT

Hello Everybody,

I want to create one table and one graph in the same page of PDF output. I found SAS program

options nodate nonumber;

ods pdf file='LayoutGriddedTitles.pdf';

title 'This is TITLE1';
footnote 'This is FOOTNOTE1';

ods layout gridded;
ods region;
title 'This is the REGION TITLE';
footnote 'This is the REGION FOOTNOTE';
proc print data=sashelp.class(obs=10);
run;

goptions hsize=4in vsize=4in;
proc gchart data=sashelp.class; 
   vbar age / name='gtitle';
   title 'This is the PROCEDURE TITLE';
   footnote 'This is the PROCEDURE FOOTNOTE';
run; 
quit;

ods layout end;
ods pdf close;

from http://support.sas.com/documentation/cdl/en/odsug/67921/HTML/default/viewer.htm#p06ji2uhvayhq5n1eik2z2rf2ga8a.htm

. My result output in SAS EG result window looks fine but output file "LayoutGridedTitles.pdf" has two pages. Should not I get 1 page output rather than 2 here. I am wondering what did I miss here.

Re: updating excel sheets from tables in SAS

learner_sas — Tue, 30 Jun 2015 14:11:29 GMT

Hello and

Here is the update on my problem. I think I am very close to the answer:

I found out that I do not have write access to SAS default temporary folder therefore I directed my temp folder to my own folder in desktop.

I did not know that we have to give default folder name for clip file so I give C:\temp as destination folder for clip.

Finally I am able to copy and paste table ( I used SASHELP.CARS) but will little problem. I am not able to write any variables after Horsepower variable in SASHELP.CARS. I thought that was LRECl issue and changed value to 32767 but still I am missing last 4 variable in my output. One thing I notice in my Clip.txt file is I am getting more than one tab between two copied column.

I am wondering if you know what would be the issue.

Thank you,

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 20:32:19 GMT

It opens an Excel sheet with your code.

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 20:23:00 GMT

Thank you @reeza I appreciate your input. Now I think I know what the problem is . When I see command line like pop up there was another pop up I missed before since it is literally for less than 1/10 secs. It says "The X command is active. Enter EXIT at the prompt in the X command window to reactivate this SAS session."

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 20:01:20 GMT

No I do not see Excel

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 19:56:58 GMT

Yes . When I ran the program I see Command-like screen for a while and it closes itself after removing last three line as you suggested.

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 19:55:39 GMT

I have my name first middle and last name. I just thought I should not give my name.

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 19:38:44 GMT

No luck again,

it is showing the exact same location. I tried .xlsx and .xls both and it did not work. I also ran by deleting bottom three rows. It still closes my Excel application.

Dim objExcel

Dim Newbook

Dim NewSheet

Dim inSheetCount

Set objExcel = CreateObject("Excel.Application")

Set Newbook = objExcel.Workbooks.Add()

objExcel.Visible = True

inSheetCount = Newbook.Application.Worksheets.Count

set NewSheet = Newbook.Sheets.Add( ,objExcel.WorkSheets(inSheetCount))

objExcel.DisplayAlerts = False

i = inSheetCount

Do Until i = 0

Newbook.Worksheets(i).Delete

i = i - 1

Loop

Newbook.Sheets(1).Name="one"

Newbook.Sheets("one").Select

Newbook.Sheets("one").Range("A1").Activate

Newbook.Sheets("one").Paste

NewSheet.SaveAs("C:\Users\myname\Desktop\sastest.xls")

objExcel.Workbooks.Close

objExcel.DisplayAlerts = True

objExcel.Quit

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 19:24:51 GMT

I can see command-like popup on my screen. I have Excel 2010, SAS 9.3 and Windows 7 on my computer. It is getting mysterious. Any thoughts ?

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 19:21:37 GMT

unfortunately not. Below is detail of folder you suggested. I am totally lost .

Re: updating excel sheets from tables in SAS

learner_sas — Fri, 26 Jun 2015 18:46:20 GMT

Hello Finally I ran code of poor/rich. Here is what I did. reference macro was used from http://www.sascommunity.org/mwiki/images/f/f4/1793-2014.sas

1) I ran program from EG I got "undermined I/O faliure.

2) I tried from Base SAS and got no error. searched log there is no "error" word in whole log. But I can not see my file in the my computer. I have SAS on my PC not on server. Below is the code and log I submitted. Clearly it says whole program is fine but I can not see the output file

My code best on poor/rich macro:

%exportxl( data=sashelp.cars ,

outfile=C:\Users\myname\Desktop\test.xlsx,

type=N,

usenames=Y,

sheet = test);

My log:

DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

NOTE: There were 1 observations read from the data set SASHELP.CARS.

NOTE: The data set WORK.T_E_M_P has 1 observations and 15 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

NOTE: There were 1 observations read from the data set WORK.T_E_M_P.

NOTE: The data set WORK.T_E_M_P has 1 observations and 15 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

NOTE: The file CODE2INC is:

Filename=C:\Users\myname\AppData\Local\Temp\SAS Temporary

Files\_TD5640_ISC83676_\#LN00032,

RECFM=V,LRECL=256,File Size (bytes)=0,

Last Modified=26Jun2015:14:37:39,

Create Time=26Jun2015:14:37:39

NOTE: 30 records were written to the file CODE2INC.

The minimum record length was 15.

The maximum record length was 55.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

NOTE: There were 428 observations read from the data set SASHELP.CARS.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

NOTE: The file DUMMY1 is:

Filename=C:\Users\myname\AppData\Local\Temp\SAS Temporary

Files\_TD5640_ISC83676_\PasteIt.vbs,

RECFM=V,LRECL=512,File Size (bytes)=0,

Last Modified=26Jun2015:14:37:39,

Create Time=26Jun2015:14:37:39

NOTE: 23 records were written to the file DUMMY1.

The minimum record length was 5.

The maximum record length was 70.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: DATA statement used (Total process time):

real time 0.28 seconds

cpu time 0.04 seconds

Everything looks right still I am not able to see my written file. Am I missing anything?

Thank you for your time.

Re: updating excel sheets from tables in SAS

learner_sas — Tue, 23 Jun 2015 19:13:16 GMT

Reeza, I am starting with Poor/Rich Macro. I will update on on my result. I am refraining from DDE since it gave me problem on my test run;

Re: updating excel sheets from tables in SAS

learner_sas — Tue, 23 Jun 2015 18:51:06 GMT

Yes, I am looking for all the options in the table till we move into total SAS based solutions.