About MaryA_Marion

MaryA_Marion · ‎09-30-2019

I added format statements as well as informat statements on my latest try. Please see log below. Thank you. MM 73 data ny; 74 informat A $30. B comma8. C comma8. D comma8. E comma8. 75 F comma8. G comma8. H comma8. I comma8. 76 J comma8. K comma8.; 77 infile '/folders/myshortcuts/611/data/Week 77 ! 03/HWdata/nypopulation.mm.csv' DSD; 78 input A B C D E F G H I J K; 79 format A $30. B comma8. C comma8. D comma8. E comma8. 80 F comma8. G comma8. H comma8. I comma8. 81 J comma8. K comma8.; 82 run; NOTE: The infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv' is: Filename=/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=30Sep2019:14:54:11, File Size (bytes)=5312 NOTE: Invalid data for B in line 1 3-3. NOTE: Invalid data for C in line 1 5-5. NOTE: Invalid data for D in line 1 7-7. NOTE: Invalid data for E in line 1 9-9. NOTE: Invalid data for F in line 1 11-11. NOTE: Invalid data for G in line 1 13-13. NOTE: Invalid data for H in line 1 15-15. NOTE: Invalid data for I in line 1 17-17. NOTE: Invalid data for J in line 1 19-19. NOTE: Invalid data for K in line 1 21-21. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+---- 1 A,B,C,D,E,F,G,H,I,J,K 21 A=A B=. C=. D=. E=. F=. G=. H=. I=. J=. K=. _ERROR_=1 _N_=1 NOTE: 63 records were read from the infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv'. The minimum record length was 21. The maximum record length was 115. NOTE: The data set WORK.NY has 63 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds

MaryA_Marion · ‎09-30-2019

I am using SAS Studio. Code is not reading data with commas enclosed by "s. I tried two ways 1)format 2)informat. I am reading a csv file with long column headings which I changed to ABCDEFGHIJK. I will deal with the long variable names next but first how should I read this in? A=A B=. ....K=. Error message says I have invalid data for B--K. How to do? Please see details below. Thank you. Mary A. Marion Data (first three lines): A,B,C,D,E,F,G,H,I,J,K Albany County,"294,565","289,565","245,060","32,624",605,"8,090",84,"3,102","5,000","9,079" Allegany County,"49,927","49,487","48,444",361,139,358,2,183,440,454 ... data ny; infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv' DSD; input A B C D E F G H I J K; format A $30. B comma8. C comma8. D comma8. E comma8. F comma8. G comma8. H comma8. I comma8. J comma8. K comma8.; run; data ny; informat A $30. B comma8. C comma8. D comma8. E comma8. F comma8. G comma8. H comma8. I comma8. J comma8. K comma8.; infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv' DSD; input A B C D E F G H I J K; run;

MaryA_Marion · ‎09-29-2019

novinosrin, Thanks. Is there something special about lrecl=32767? I tried using lrecl=512 and got an error. MM

MaryA_Marion · ‎09-29-2019

The enclosed code is not inputting two alphanumeric variables which are in the enclosed txt file. How to read this data in? The software just hangs up and nothing happens? Thanks. Mary A. Marion %let dirdata=/folders/myshortcuts/611/data/Week 03/HWdata/; data names; infile "&dirdata.top-1000-baby-boy-names.mm.txt" /* termstr=CRLF */ truncover lrecl=512 pad ; *input name $ rank2 comma9. @@; input name: $30. rank2 $ @@; run; proc print; run; *963 obs, should be 1000 obs;

MaryA_Marion · ‎09-29-2019

Thank you very much. I knew I was close to the correct syntax. MM

MaryA_Marion · ‎09-29-2019

I want to print pairs of variables (24 pair of form temp&i tempc&i) using an inline macro. See code below. How to do? Also, my numeric day variable will not output using put statement? Thank you. MM GOAL: data _null_; set FtoC4; file print; put Day Date temp1 tempc1 temp2 tempc2 ... temp24 tempc24; run; and proc print data=FtoC4; var Day Date temp1 tempc1 temp2 tempc2 ... temp24 tempc24; run; Attempts: proc print data=FtoC4; var Day Date (temp1 temp1c) - (temp24 tempc24); title 'q1f'; run; options mrecall; %macro readin; %do i=1 %to 24; temp&i tempc&i; %end; %mend; %readin; proc print data=FtoC4; var Day Date %readin; title 'q1f'; run; data _null_; set FtoC4; format day 8.0 date mmddyy10.; file print; put day date; run;

MaryA_Marion · ‎05-18-2019

Where is this insert photo icon? Do I need to go interactive? Are you referring to a SAS U window?

MaryA_Marion · ‎05-18-2019

Tom, Thank you. I needed to learn to read what followed table of contents in the results window. I notice there is a contents noprint option to proc datasets. I did not seem to need it however. 5 stars! MM

MaryA_Marion · ‎05-18-2019

Only one proc datasets in code, mmeans2 is called multiple times. How to modify? %macro mmeans2(dsname,varlst,stat); proc datasets library=work; delete meansout; run; proc means data=&dsname noprint; var &varlst; output out=meansout n=n nmiss=nmiss mean=mean Std=Std min=min max=max range=range sum=sum var=var uss=uss css=css Stderr=Stderr cv=cv /* skewness=skewness kurtosis=kurtosis sumwgt=sumwgt */ t=t prt=prt; run; ...

MaryA_Marion · ‎05-18-2019

there is no proc contents code....Strange!

MaryA_Marion · ‎05-18-2019

SAS is actually creating directory information and library member information not toc. I read the output window incorrectly. I need to turn this off somehow. Thank you for your reply. I am paying more attention to the log now.

MaryA_Marion · ‎05-18-2019

TOC is actually not correct. It is directory information and library members that are outputting. I need to put that to the log one time, not the 8 times it is done at the start of the program. It is also done later on.

MaryA_Marion · ‎05-14-2019

I am running the following autoexec before calling a macro. I usually just have the output go to the default window so I am not specifying html or pdf in the code itself although it is listed in the preferences. AUTOEXEC.SAS %LET sasworklocation="/folders/myfolders/"; ODS LISTING GPATH=&sasworklocation; /* ODS STATEMENTS */ ods path reset; ods _ALL_ close; ods trace off; ods listing; ods noptitle; ods graphics on; *INITIALIZATION proc printto; run; I am following the autoexec with a call to a macro but I suspect that the macro itself initiates the table of content output. That is what is happening on the code I am working with. A display of unwanted table of content data appears in the results window. How can I stop that from happening when running SAS University? It greatly increases output size. I got it to stop once when I changed the preferences but it is back in again. The following statement added to the macro does not work. ODS html5 exclude toc The error message says: html5 destination is not active I need something similar to this ??? I don't want to output to pdf or rtf for simplicity. I just want to open sas studio /sas university, code, and get output to the screen. By the way, why am I not getting an output window as well? Thanks. MM

MaryA_Marion · ‎05-04-2017

thank you for your reply. will the autocorrelation between observations be the same as that between residuals? mary

MaryA_Marion · ‎04-23-2017

I have been asked to use proc autoreg to compute the durbin watson statistic for a logistic regression problem. How to do? Thank you. Mary proc autoreg data=silica; model y = exp(-(A B C)) / nlag=?;

Online Status	Offline
Date Last Visited	‎03-04-2022 04:38 AM

Re: Is it possible to invoke the Forecasting System from SAS on Demand...

Is it possible to invoke the Forecasting System from SAS on Demand?

Re: What is the difference between a forecast and prediction in SLR?

Re: What is the difference between a forecast and prediction in SLR?

What is the difference between a forecast and prediction in SLR?

Re: How to obtain macro code for dftest and logtest (not just info on ...

How to obtain macro code for dftest and logtest (not just info on the ...

Re: Inserting white space between a quoted string and the succeeding i...

Re: Inserting white space between a quoted string and the succeeding ...

Inserting white space between a quoted string and the succeeding iden...

Re: Inserting white space between a quoted string and the succeeding ...

Re: Using sgplot to plot summarized data produces an extra line?

Re: How can I obtain a list of all of my questions asked on SAS Suppor...

Re: how to plot multiple regression lines using sg series & gplot lege...

Re: how to plot multiple regression lines using sg series & gplot lege...

How to: Download a directory of sas files (SAS Studio & SAS on demand)

Re: import of a tab delimited file in SAS Studio is not working?

Re: Can you use PROC GENMOD for a generalized linear mixed model?

Re: Press Statistic

Re: How to import data containing commas that are enclosed in parenthe...

How to import data containing commas that are enclosed in parentheses?

Re: how to input variable length records?

how to input variable length records?

Re: inline macros

inline macros

Re: Questions regarding macros automatically outputting table of conte...

Re: Questions regarding macros automatically outputting table of conte...

Re: Questions regarding macros automatically outputting table of conte...

Re: Questions regarding macros automatically outputting table of conte...

Re: Questions regarding macros automatically outputting table of conte...

Re: Questions regarding macros automatically outputting table of conte...

Questions regarding macros automatically outputting table of content d...

Re: proc autoreg and a logistic regression equation

proc autoreg and a logistic regression equation