SAS Studio topics

Unable to Rename - Proc Transpose; SAS on Demand

alphangadan — Mon, 12 Jul 2021 12:04:06 GMT

Dear Reeza or any other senior members,

I have been trying to solve this on my own but I am stuck.

I have been using SAS Studio UE since 2015 and I have no issue running this proc transpose and rename statement. But since I migrate to SAS on Demand, and running the same code, I received this error.

WARNING: The variable _1 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _2 in the DROP, KEEP, or RENAME list has never been referenced.

My codes;

Proc means data=msia.mewretdat mean t probt;
 class momr;
 var mewret;
run;

/* Calculate Buy-Sell Portfolio Returns */
Proc sort data=msia.mewretdat; by date momr; run;
proc transpose data=msia.mewretdat out=msia.mewretdat1 (rename=(_1=Sell _2=BUY));
 by date;
 id momr;
 var mewret;

data msia.mewretdat2;
set msia.mewretdat1;
BUY_SELL=BuY-Sell;
Run;

Proc means data=msia.mewretdat2 n mean t probt;
 var Sell Buy Buy_Sell;
Run;

Appreciate the guidance.

Best regards,

Alpha

Help with Shewhart Control Chart

annaabimbola — Thu, 08 Jul 2021 23:13:42 GMT

I'm want to create an XSchart

this is the code I used but the chart was split into 5 instead of 1. The dates in my data are 09/01/2020, 10/01/2020, 11/01/2020, and so on. Do I need to include something that will make just 1 chart?

title "Length of Stay";
symbol v=dot;

proc shewhart data=work.nowsbaseline_sorted;
	xschart neonatald*measureperiodid;
run;

Restrict certain file types from Folder Shortcut explorer

samir_par — Tue, 06 Jul 2021 18:12:51 GMT

Hi,

From Folder shortcut file explorer, by default you can see all files located under the actual folder. Now if a user try to open .RTF files, SAS studio actually download that file onto user's local machine, which we want to avoid.

So, Is there any way/setup such that we can restrict some files from the explorer view? Like I want to restrict .RTF files from the view so that user can not download/open .RTF file.

Thanks!

if/then problem creating a variable

gejoachim99 — Tue, 29 Jun 2021 18:00:41 GMT

I'm using ODA, trying to create a variable with this code -

libname adeno '/home/u58566978/adeno';
data work.adeno1;
set adeno.finch_gjred;
run;

data work.adeno1;
set adeno.finch_gjred;
if beertotl=2 and beerfrq2=0 and beerfrqx2=0 and beernum2=98 then wrong=0;
if beertotl=3 and beerfrq3=0 and beerfrqx3=0 and beernum3=98 then wrong=0;
if beertotl=4 and beerfrq4=0 and beerfrqx4=0 and beernum4=98 then wrong=0;
if beertotl=5 and beerfrq5=0 and beerfrqx5=0 and beernum5=98 then wrong=0;
if beertotl=6 and beerfrq6=0 and beerfrqx6=0 and beernum6=98 then wrong=0;
if beertotl=7 and beerfrq7=0 and beerfrqx7=0 and beernum7=98 then wrong=0;
if beertotl=8 and beerfrq8=0 and beerfrqx8=0 and beernum8=98 then wrong=0;
if beertotl=9 and beerfrq9=0 and beerfrqx9=0 and beernum9=98 then wrong=0;
if beertotl=10 and beerfrq10=0 and beerfrqx10=0 and beernum10=98 then wrong=0;
if beertotl=11 and beerfrq11=0 and beerfrqx11=0 and beernum11=98 then wrong=0;
if beertotl=12 and beerfrq12=0 and beerfrqx12=0 and beernum12=98 then wrong=0;
else wrong=1;
run;

proc freq data=work.adeno1;
tables wrong;
run;

....but when I do that, this is the table I get. When I exclude the 'else wrong=1' line, I get this, which is what I want, but I need to have a "1=832" line instead of those people being considered missing. Is this an ordering problem in my code? Any help is much appreciated.

ERROR: Variable MIGRATION not found.

RazaTheLegend — Sun, 27 Jun 2021 12:32:32 GMT

I run the following code

proc contents data=data.alverdens_lande out=al;
run;

proc means data=al;
var Migration;
run;

The first part comes out fine, tells me all about the variable of which there 6 and 2 categorical variables.

But then when i try to run mean of one of the numerical variables it cant find it.

Might be an easy fix?

New Variable

sassypixie — Sun, 27 Jun 2021 03:37:38 GMT

Apologies in advance, I am very new to SAS and am having trouble with an assignment.

I'm getting error 161-185 no matching DO/SELECT statement. The assignment is described below:

Within the datastep create the following new variables:
(a) A new variable called agecat that divides age into 5 categories:45-49;50-54;55-59;60-
64;65-69. Give values 1-5 for the categories.
(b) A new variable called income40 equal to 0 if income is less than $40,000 and equal to
1 if income is $40,000 or more.
(c) A new variable called collgrad equal to 0 if the participant did not graduate from college
and equal to 1 if the participant graduated from college (see study forms for income and
education categories)
(d) A new variable that is the lowest of the two serum potassium values

This is my SAS code right now (still haven't gotten to parts C and D):

libname t '/home/u58860515/';
data tdata; set t.tomhs (keep=age sex income educ hdlbl potassbl potass12);
if age = 45-49 then agecat = 1; else
if age = 50-54 then agecat = 2; else
if age = 55-59 then agecat = 3; else
if age = 60-64 then agecat = 4; else
if age = 65-69 then agecat = 5; end;
if income < 40000 then income40 = 0; else
if income > 40000 then income40 = 1; end;
run;

Emailing from SAS Studio - New files only accessible after signing off and back on

GlennGail — Thu, 24 Jun 2021 19:45:51 GMT

I have just begun an effort to migrate existing z/OS based programs from the mainframe to Linux. I am using SAS Studio to run the programs. So far everything has worked smoothly and I am very pleased with SAS Studio. One mystery has me scratching my head... When I create/update .CSV files in my SAS program that are written on the server my email step cannot find the file unless I log off SAS Studio and log back in. Then it finds the file. A minor annoyance, but I am sure there is a solution. I am new to SAS Studio, but I am not new to the SAS Programming language.

Git in SAS Studio

lid9zkr — Thu, 17 Jun 2021 16:45:49 GMT

Hello All.

In the paper from the SAS global forum, it shows how to insert a SSH key into sas studio. It shows the location as being on the C drive which is where mine is. The problem is that sas studio is on an unix server and it doesn't appear that I can access my C drive. Does anyone know how I can access the c drive in studio or do I need to copy the SSH unto an unix folder?

Thanks,

Debra Hudson

PROC EXPORT * MS-Excel \ SHEET TAB NAME "&" - Wanted: ICD9 & HCC

Greg_Azevedo_KP — Mon, 14 Jun 2021 15:35:55 GMT

I’m new to using SAS a little --- doing a fairly simple data base export to MS-Excel.

It works but am unable to get the MS-Excel Tab Name as needed.

MS-Excel Tab Name --- SAS PROC EXPORT \ SHEET Definition

MS-Excel Tab Name – Wanted: ICD9 & HCC

I’ve tried and it seems to fails to execute. Is there a way ? Using SHEET to set the Tab Name.

#-#-#-#-#-#-#-#-#-#-#-#-#

PROC EXPORT DATA=RPTTBL_EDG01

OUTFILE="\\xxxxx\EDG.YYYY.MM.DD.xlsx"

DBMS=EXCELCS REPLACE;

SHEET='ICD9 ^ HCC';

#-#-

How to put SAS on Demand for Academics in an icon on my screen?

plf515 — Fri, 11 Jun 2021 21:16:28 GMT

After using SAS professionally for decades, I've retired. But I'm giving some presentations with SAS at regionals. So, I downloaded SODA Studio.

What I am wondering is if I can put a link to this on my screen, rather than having to go through the link in the e-mail that SAS sent to me.

Thanks

Peter

Histogram does not reflect summary statistics.

karenktq — Tue, 08 Jun 2021 17:01:33 GMT

Based on the summary statistics using, the mode is 0. In that case, shouldn't the histogram reflect 0 as the highest frequency?

*summary stats;
proc means data= libref.data2 mean std var min max n median mode;
run;

*histogram;
proc univariate data= libref.data2;
histogram;
run;

How to access SAMPSRC library in SAS/IML from SAS onDemand for Academics?

rbettinger — Fri, 04 Jun 2021 17:17:30 GMT

I am teaching myself how to use lists in SAS/IML as available in SAS onDemand for Academics. The sample program on the SAS/IML 15.1 User Guide p. 169 contains the code

%include sampsrc(LstBST.sas); /* define modules */
proc iml;
load module = _all_; /* load modules */
x = {5 3 1 9 1 6 4}`;
bst = BSTCreate(x);
title "Diagram of Binary Search Tree";
call BSTPlot(bst);
quit;

which, when I run the code, produces the following error message:

WARNING: Physical file does not exist, /pbr/sfw/sas/940/SASFoundation/9.4/samples/accesssample/LstBST.sas.

ERROR: Cannot %INCLUDE member LstBST.sas in the aggregate SAMPSRC.

164

165 %include sampsrc( LstBST.sas ) ; /* define modules */

166

167 proc iml ;

NOTE: IML Ready

168 load module=_all_ ;

NOTE: Opening storage library WORK.IMLSTOR

168 ! /* load modules */

169

170 bst = BSTCreate( x ) ;

ERROR: Invocation of unresolved module BSTCREATE.

statement : ASSIGN at line 170 column 4

171 title "Diagram of Binary Search Tree" ;

172 call BSTPlot( bst ) ;

ERROR: Invocation of unresolved module BSTPLOT.

statement : CALL at line 172 column 4

173 quit ;

Has anyone else encountered this error? Is the SAMPSRC library not included in the SAS/IML product for SAS onDemand for Academics?
Thanks in advance,
Ross Bettinger

SAS ODA times out while uploading large XPT file

Ddormer — Thu, 03 Jun 2021 15:40:21 GMT

I am trying to upload the CDC's BRFSS2015.XPT file. The file is 917 MB so well within the %GB space allowed. However, after one hour, SAS ODA times out and the upload is cancelled. Can I extend the time out to more than one hour? If so, how?

How Do I Remove Course Files from SAS Studio Home Directory?

oconnom60 — Wed, 02 Jun 2021 14:27:07 GMT

I am using SAS OnDemand for Academics and have A LOT of course files loaded in my home directory, counting against my personal data usage. I am now over my quota in my home directory while my course directory is at 0%. I do not use or want these course files but I receive a message that says I am not authorized to delete them. Is there a way to delete them or move them to their rightful home in the course directory?

SAS Studio - folder shortcuts file is never updated

el_grom — Mon, 31 May 2021 08:38:10 GMT

Hi guys!

We're using SAS 9.4_M6 and more specifically SAS Studio. One of our user has a very annoying issue: In the web interface, he adds a shortcut to a folder. When he quits his session, the shortcut should remain but it does not. Next time he logs in, he finds the shortcut section blank like it is the first time he uses it.

For his colleagues, it's working fine, once they close the web page and reopen it, the shortcuts are still there.

We found out that the file - C:\users\<accountname>\AppData\Roaming\SAS\SASStudio\preferences\SWE.folderShortcuts.key - is never updated for this user. (it is for the others)

He has a full control on the file and a tracing doesn't show any "access denied" or else.

Do you have any experience with such behavior?

If it was not obvious, we're running it on Windows (2012)

Thanks!

SAS Studio 3.8 - Problems when trying to upload a file

mvcastro — Wed, 02 Jun 2021 06:53:30 GMT

We need to upload a file to SAS Studio but the file upload limit is set at 500 mb and the file is close to 3 Gb. We have the following error: "The size of the uploaded files cannot be greater than 500 MB. The size of the selected files is 2,8Gb.

How can I change that limit?
Is there any limitation on the maximum size?

Thanks

Library weirdness

genemroz — Sat, 29 May 2021 14:17:32 GMT

Using SAS Studio OnDemand for Academics, the following code generates a file (STATIONDATAEXISTING) under two LIBRARIES: SOCAL and FORMATS . Why would it create one in the FORMATS library? When I delete it from the FORMATS library the entry under the SOCAL library disappears too. Seems weird.

Thanks in advance for any guidance,

Gene

data socal.stationdataexisting;
input station $ lat long alt az elev;
datalines;
US000S 34.290983 -116.383718 .898 198.31 54.33
US000V 33.960142 -117.259044 .533 47.06 67.3
US001Q 33.960142 -117.259044 .533 129.44 68.32
US001R 34.290983 -116.383718 .898 90 45
US001E 33.640000 -117.60 .500 . .
;
run;
data socal.stationdataexisting;
set socal.stationdataexisting;
/*Define Center of Grid as location of US000S*/
xpos=(long-(-116.383718))*91.09;
ypos=(lat-(34.29083))*111.19;
zpos= alt;
run;

Sas programming in enterprise guide and creating dashboards in visual analytics

sas_it — Mon, 24 May 2021 13:10:16 GMT

I am the beginner in sas programming using enterprise guide and creating dashboard using visual analytics. I have learned sas programming in enterprise guiDe and learned visual analytics. If i am given the project for first time, whats the whole procedure from creating dataset in enterprise guide , uploading to server and using that dataset in visual analytics. Pls help i am totally new.

.sas7bdat file from server isn't showing up in SAS studio

gejoachim99 — Thu, 06 May 2021 15:52:35 GMT

I've been using SAS University Edition for about a year now to do work using a .sas7bdat file that I access from a server, then put in my folder on my computer so I can access it in SAS - SASUniversityEdition>myfolders. This has worked for a year now, but in the last few days, even though I do the same thing, and put the same dataset in the same folders, it does not show up in SAS Studio anymore in the "Server files and folders" section. Any ideas for what could be going wrong? Is there some update that I missed?

I also downloaded SAS on demand for academics to try and use that program instead, but then I can't figure out how to get my .sas7bdat file on there. So, an alternative question - how do I load my dataset on to this SAS program?

Help with either or both questions would be much appreciated. If you need some more information just let me know, at a loss here. Thanks.

How to make a frequency table with statistics values?

ellpap — Sat, 01 May 2021 22:40:08 GMT

Hi,

I am trying to make a table similar to this one below with the data I have attached. I cannot seem to figure out how to use proc freq to generate the frequencies, proc means ( or proc univariate ) to generate the statistics values and then combine them in this way into a table. If anyone could give me any pointers on how to start that would be awesome! thanks so much!

Also these are the assumptions:

Treatment:

1 = Active
0 = Placebo

Gender:
1 = Male
2 = Female

Race
1 = White
2 = Black
3 = Other

folder

elisehoo1 — Fri, 30 Apr 2021 11:32:09 GMT

Hi friends,

would like to know if there any configuration that i can made to add an folder under home , i wonder if i can put a folder there that link to a physical folder (project folder) .

Thanks

Running SAS Program to Add CCSR Categories to NIS Data

ededeStats — Fri, 30 Apr 2021 00:08:57 GMT

Dear SAS Community,

I have been struggling with my SAS Program to add Clinical Classifications Software Refined (CCSR) for ICD-10 CM diagnosis on to my National Inpatient Sample (NIS) core dataset. I have modified all the parts of the program as instructed in the DXCCSR user guide. Unfortunately I keep getting error messages.

Please find below a sample of my modifications to the program and a snap shot of the error messages.

* FILE LOCATIONS ;
FILENAMe INRAW1 '/folders/myfolders/HCUP/NIS2018/DXCCSR_v2021-2.csv' lRECL=3000; *<=== USER MUST MODIFY;
LIBNAME IN1 '/folders/myfolders/HCUP/NIS2018'; *<=== USER MUST MODIFY;
LIBNAME OUT1 '/folders/myfolders/HCUP/NIS2018/NIS'; *<=== USER MUST MODIFY;

* OPTIONAL FILES ;
* Build vertical file? 1=yes, 0=no; %LET VERT=1; *<=== USER MUST MODIFY;
* Build default DXCCSR file? 1=yes, 0=no; %LET DFLT=1; *<=== USER MUST MODIFY;
* Build horizontal file? 1=yes, 0=no; %LET HORZ=0; *<=== USER MUST MODIFY;

* FILE NAMES ;
* Input SAS file member name; %LET CORE=NIS_2018_CORE; *<=== USER MUST MODIFY;
* Output SAS file name, vertical; %LET VERTFILE=NIS_CORE_OUTPUT_VERT; *<=== USER MUST MODIFY;
* Output SAS file name, horizontal; %LET HORZFILE=OUTPUT_HORZ_FILE_NAME; *<=== USER MUST MODIFY;
* Output SAS file name, default DXCCSR; %LET DFLTFILE=OUTPUT_DFLT_FILE_NAME; *<=== USER MUST MODIFY;

* INPUT DATA CHARACTERISTICS ;
* Database types, IP/OP/IO; %LET DBTYPE=IP; *<=== USER MUST MODIFY;
* Data element to identify IP/OP records; %LET IOVAR=DBTYPE; *<=== USER MUST MODIFY;
* Data value to identify IP records; %LET IOVALI=IP; *<=== USER MUST MODIFY;
* Data value to identify OP records; %LET IOVALO=OP; *<=== USER MUST;
* Linking key on input SAS data; %LET RECID=KEY; *<=== USER MUST MODIFY;
* Prefix of diagnosis variables; %LET DXPREFIX=I10_DX; *<=== USER MUST MODIFY;
* Maximum number of DXs on any record; %LET NUMDX=40; *<=== USER MUST MODIFY;
* Record specific DX Count variable, if not available leave it blank;
%LET NDXVAR=I10_NDX; *<=== USER MUST MODIFY;

Error Messages

ERROR: The variable KEY in the DROP, KEEP, or RENAME list has never been referenced.

ERROR: The variable DBTYPE in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.NIS_2018_CORESKINNY may be incomplete. When this step was stopped there were 0 observations and 0

variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

ERROR: BY variable KEY is not on input data set WORK.NIS_2018_CORESKINNY.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.IP_IN may be incomplete. When this step was stopped there were 0 observations and 0 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).

711:160 711:74

NOTE: Variable KEY is uninitialized.

NOTE: Variable I10_NDX is uninitialized.

ERROR: BY variable KEY is not on input data set WORK.IP_IN.

WARNING: The variable KEY in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.IP_OUT_VT may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: The data set WORK.DXCCSR_FLAGS may be incomplete. When this step was stopped there were 0 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.03 seconds

cpu time 0.04 seconds

ERROR: The variable KEY in the DROP, KEEP, or RENAME list has never been referenced.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.IP_OUT_VT may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.IP_OUT_VT was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

ERROR: Variable KEY not found.

ERROR: BY variable KEY is not on input data set WORK.IP_OUT_VT.

ERROR: Variable KEY not found.

ERROR: Invalid value for the SORTEDBY option.

ERROR: The variable KEY in the DROP, KEEP, or RENAME list has never been referenced.

ERROR: BY variable KEY is not on input data set WORK.DXCCSR_FLAGS.

ERROR: BY variable KEY is not on input data set WORK.IP_DFLT_FILE.

ERROR: Variable KEY not found.

ERROR: Invalid value for the SORTEDBY option.

Please does anyone know what might be wrong? I am quite new to SAS.

Also, if anyone has any experience using the NIS dataset, please hit me up.

Many thanks!

Where is _DATAOUT documented

Tom — Wed, 28 Apr 2021 18:37:49 GMT

I saw an interesting article on this site that seems to saying you can have SAS/Studio download a file that your SAS code generates.

But I cannot find ANY documentation on this feature and how to use it.

Try this program in SAS/Studio

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=class.csv;

data _null_;
  file _dataout dsd ;
  set sashelp.class ;
  if _n_=1 then put 'name,age,sex';
  put name age sex;
run;

Data does not appear in in SAS Viya

adjie — Wed, 28 Apr 2021 09:51:20 GMT

Hi, i'm trying to perform oversampling on SAS Studio. Before performing the oversampling, I have create cas session to connect with the libraries, here is the code.

cas casauto host="example.host" port=5570;
proc cas;
	session casauto;
	session.sessionstatus result=s;
	put s;
run;

CASLIB _ALL_ assign;
options casdatalimit=50G;

After that, i performed the oversampling and it worked just fine without any errors.

As you can see the output table is already listed on the public library. But when I tried to look for the table from SAS VA or Environment Manager the table doesn't appear. This issue also happened before when I ran a query file, the output table is listed on the library in SAS Studio but I couldn't find the table when I tried to add the data to SAS VA.

Did I miss anything?

Upload files tap in Explorer is disabled - SAS Studio 5.2

SASUser07 — Mon, 26 Apr 2021 11:38:22 GMT

Hello,,

I am new to SAS Studio and I have been working in the Trial. I am trying to upload a csv file from my computer to SAS Studio but the Upload files tap in Explorer is disabled.

Can someone explain how to upload my files ?

Thanks.

Spline option grayed out in effect statement?

ayosas — Sun, 25 Apr 2021 17:45:18 GMT

proc logistic data=compas1;
 effect PRIORspl=spline(priors_count / degree=2);
 model two_year_recid (event='0') = PRIORspl/ rsq lackfit;
 id compas_id priors_count;
 output out=one predicted=splpred
 reschi=splres;
 effectplot fit (x=priors_count);
 title1 'Continuous BP with Spline';
run;

My code is as above. The spline option doesn't turn blue as it's supposed to

Import sas7bdat with PROC IMPORT?

emmad511 — Tue, 20 Apr 2021 20:19:46 GMT

Hello, I was wondering about how to import a sas7bdat file with proc import.

I've done some search for it but all I can find was using LIB with DATA.

Thanks in advance!

defining af new variable

Jannie_D — Thu, 15 Apr 2021 10:27:56 GMT

Hi. I am about to define a couple of new variables.I am working on a secure drive and can not copy paste my data or log.

I just does not work as intended. There are no errors or warnings in the log. But the data does not show up in the intended column.

So I want to create two new variables:

1: DRGambjan2014: which is the variable V_pris_genop if the date in d_hendto is jan and 2014

2:DRGambjun2014: which is the variable V_pris_genop if the date in d_hendto is jun and 2014

my code lookes like this

Data DRG1;

set DRG;

if year(d_hendto)=2014 and month(d_hendto)=jan then DRGambjan2014=v_pris_genop;

if year(d_hendto)=2014 and month(d_hendto)=jun then DRGambjun2014=v_pris_genop;

run;

it shows up as if data is missing, even where it is not.

why does it not work?

kind regards Jannie

kind regards

Delete Folder with files from SAS OnDemand for Academics

student12345678 — Fri, 09 Apr 2021 13:35:38 GMT

Hello,

I have a problem in SAS onDemand for Academics.

My data storage is full and I want to delete an old project (folder).

But I'm not able to delete the folder since it is not empty (it has multiple subfolders and files).

Do I need to delete every single file and folder in this folder one by one or is there an easier option to directly delete the folder with all files and subfolders in it?

Thanks a lot!!!

No files in libary

HamDerMathias — Wed, 07 Apr 2021 11:10:46 GMT

I am doing the SAS Programming 1: Essentials course. For some reason no files apear in the pg library when i make it. The files are on my computer and i can access them in SAS from the same location by "proc import". I create the library by libname pg "myfolder\EPG1V2\data"; and it goes through in the log with no errors. No data is in the library however. I hope you can help, it is super frustrating.

Import mutiple (8500) Excel Files from one folder to SAS OnDemand for Academics

student12345678 — Wed, 07 Apr 2021 11:02:44 GMT

Hello,

I'm struggling with importing multiple Excel Files into SAS onDemand for Academics.

I'm using the Robintrack dataset and havelaready unpacked it on my PC. Now I have 8597 Excel files in my PC folder, which are all named according to the respective stock.

Can someone help me to write an Macro to import all Excel files into one SAS table with an additional Variable which has the stockname in it?
To import one file is not a problem but I'm not able to import all files at once in a macro, too save them all in one SAS table and to give assigne them a new variable which has the corresponding stock name.

Thanks a lot!!!

SAS Studio Visual Programmer - Pass values to next task in process flow

csteiz — Fri, 02 Apr 2021 14:33:31 GMT

I've started learning how to write Custom Tasks. I Wrote a Task to create a library in the process flow. I'd like to pass the name of the library to the next connected Custom Task in my process flow. I am on SAS Studio v3.71 so I cannot yet use the DefaultValue option in DataSources.

The documentation on writing Custom Tasks does not clearly explain if Tasks in a process flow can be configured to pass tasks to downstream tasks

select all varchar variables in SAS Viya

gyambqt — Tue, 30 Mar 2021 00:48:14 GMT

Hello experts,

Is there a way to select all Varchar variables in CAS table using datastep in Viya?

initially I thought to use array: test[*] _varchar_ but it didn't work.

SAS Studio Enterprise Edition Email Issue

pchegoor1 — Sun, 21 Mar 2021 18:51:50 GMT

Hi,

Last week we installed SAS Office Analytics on a Linux ( RHEL 8.3) Test Server . This also includes the SAS Studio Mid-Tier(Enterprise Edition).. The Studio has been configured for PUBLIC Users.

I am able to login and use SAS Studio but the moment i try to email the Results ( using the SAS Studio email feature under Results tab) i get the below Error after I click on SEND . I believe the email settings are correct. But i am not sure how to go about fixing this Error .

From the SAS Studio Log : SASStudioMidTier3.81.log i do see this Error at the bottom of the log at the time i am trying to send email . The XXXXX is the user id i am using to log into SAS Studio

[tomcat-http--6] ERROR [unknown(XXXXX)] com.sas.ep.sascoder.web.ShareController - java.lang.NullPointerException

Any thoughts and suggestions? Thanks.

About proc arima:how can i get the picture like this

AmandaW — Tue, 16 Mar 2021 03:04:56 GMT

code:

data example2_1;
input freq@@;
cards;
1  2  3  4  5  6  7  8  9  10
11 12 13 14 15 16 17 18 19 20
;
proc arima data=example2_1;
identify var=freq NLAG=6;
run;

the outcome in SAS studio:

but i would like to have the picture like this:

is there any method?help me,please

Does not exist error creating output with Proc SGPie from SAS/Studio

JonathanWilliamson — Thu, 11 Mar 2021 18:02:05 GMT

Hi,

I'm trying to use proc sgpie within SAS/Studio (3.8 &SAS 9.04.01M6P110718). I'm sure it's probably a simple setup step I've missed to get graphics output.

Tried various examples and keep getting this same error. I'm sure it's probably a simple setup step I've missed to get graphics output.

Here's an example from https://blogs.sas.com/content/graphicallyspeaking/2018/11/26/the-sgpie-procedure/

proc format;
value $type
  'Sedan'='Sedan'
  other= 'Other';
run;

ods graphics / reset width=4in height=2.5in;
title 'Vehicle Distribution';
proc sgpie data=sashelp.cars;
    format type $type.;
    styleattrs datacolors=(gold maroon);
    pie type / startangle=270;
run;

Log output:

NOTE: ODS statements in the SAS Studio environment may disable some output features.
 71         
 72         proc format;
 73         value $type
 74           'Sedan'='Sedan'
 75           other= 'Other';
 NOTE: Format $TYPE has been output.
 76         run;
 
 NOTE: PROCEDURE FORMAT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 77         
 78         ods graphics / reset width=4in height=2.5in;
 79         title 'Vehicle Distribution';
 80         proc sgpie data=sashelp.cars;
 81             format type $type.;
 82             styleattrs datacolors=(gold maroon);
 83             pie type / startangle=270;
 84         run;
 
 NOTE: The SGPIE procedure is pre-production for this release.
 ERROR: Path "/var/tmp/saswork/SAS_work644500006EE0_sassvr01/#LN00218" does not exist.
 NOTE: PROCEDURE SGPIE used (Total process time):
       real time           0.14 seconds
       cpu time            0.04 seconds
       
 ERROR: The file /var/tmp/saswork/SAS_work644500006EE0_sassvr01/_7F7C41BB5B02C4A8FA9058EC606E942.svg does not 
        exist.
 ERROR: The file /var/tmp/saswork/GBR/SAS_work644500006EE0_sassvr01/_85F370F91D7F94ABB0E6874F94AF844.svg does not 
        exist.
 NOTE: There were 428 observations read from the data set SASHELP.CARS.

Any ideas ?

how to programatically create a folder in SAS Studio / SAS Viya

alexandravieira — Wed, 10 Mar 2021 09:00:03 GMT

I'm trying to write a program to create a folder in the sas studio folder structure. So far I've tried DCREATE and options DLCREATEDIR without success:

data _null;
newdir=dcreate('newsubfolder','/path/that/exists');
run;

this resulted in:

NOTE: The data set WORK._NULL has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

But no folder was created in '/path/that/exists'.

Then I tried:

options DLCREATEDIR;
libname newdir '/path/that/exists/newsubfolder';

this got me an error:

ERROR: Create of library NEWDIR failed.
ERROR: Error in the LIBNAME statement.

Is there a way I can do this?

I should say I do not have CAS available in my sas viya implementation, not sure if this is relevant but it has limited me in many ways before so maybe this is another one.

mean of 2 variables for rank groups

jundy19 — Tue, 09 Mar 2021 23:42:23 GMT

I have a dataset with 4 variables where var 1 is categorical. I'm trying to do the mean for var2 and var3 based on a proc rank i applied on a 3rd variable(Thus, i the want the mean var2 for 0,1,2,3 as well as the mean for var3 for each of them as well. How can I do that???

I tried doing proc means but it's giving me the mean for each variable in general not for each value of the ranks.

my code looks like this:

data myd1;

input var1 var2 var3 var4;

datalines;

1 200 300 55%

2 400 750 20%

3 400 400 90%

4 800 320 98%

5 500 200 80%

6 600 400 71%

7 900 900 22%

8 1000 9580 77%

9 100 3000 42%

10 760 1750 53%

;

proc rank data=myd1 groups=4 out=want;
var var4;
ranks groups;
run;

---------------------------

Thank you

Can I combine proc ranks with proc format then save it into a new dataset?

jude1 — Tue, 09 Mar 2021 18:52:33 GMT

I have a dataset that i need to find the quartiles for one variable then change the numbers of the quartiles into words (assign low to 0, mid-low to 1, etc...). I am not sure how to combine both and then save it to a new dataset.

here is my code:

data mydata;

input var1 income population percentage;

datalines;

1 500 60 100%

2 400 70 90%

3 400 100 80%

4 800 222 80%

5 500 100 75%

6 600 213 70%

7 900 900 60%

8 1000 909 50%

9 100 600 40%

10 760 235 20%

;

run;

proc rank data=mydata groups=4 out=want;
var percentage;
ranks quartiles;

run;

I tried adding the proc format to the variable quartiles but i failed.

Thank you.

Calculate quartiles and assign them to if then statement

jude1 — Tue, 09 Mar 2021 17:18:07 GMT

I'm trying to find the quartiles for a variable in my data set, then create a new variable that takes different values depending on the quartile.

4 if the percentage for var1 is greater than the third quartile
3 if the percentage for var1 is between the median & the third quartile
2 if the percentage for var1 is between the first quartile & the median
1 if the percentage for var1 is lower than the first quartile
. ( missing value) if the percentage is not given
Format the new_var to name the groups “high”, “med-high”, “med-low”, and “low”, respectively. Add a label to the variable as well.

my data looks like this:

data mydata;

input var1 income location percentage;

1 500 ny 100%

2 400 nj 90%

3 400 ma 80%

4 800 va 80%

5 500 ca 75%

6 600 ma 70%

7 900 wv 60%

8 1000 ny 50%

9 100 pa 40%

10 760 wy 20%

how do I know the name of the program running in SAS Studio / SAS Viya?

alexandravieira — Tue, 09 Mar 2021 11:53:39 GMT

Like &_CLIENTTASKLABEL in EG, that gave you the name of the .sas, is there such a thing for sas studio / sas viya?

[edited] I did %put _all_; and couldn't find any macro variable with the program name. I'm not looking for a solution based on a macro var necessarily, I'm looking for any sort of solution

Calculating duration for overlaps and non-overlaps using another method not macro

ak2011 — Tue, 09 Mar 2021 01:14:28 GMT

Hello all,

I would like to calculate durations (jobyrout-jobyrin) for overlap and non overlap years without using macro.

The macro didn’t work well with large datasets having long arrays; it worked for a sample (small) dataset, so, I am obliged to find another method that will achieve the same aim, even if the method is long, I would prefer that to macro.

I would appreciate if someone knows of any other method to achieve my aim. The dataset, my objectives and expected output are given below.

I really need help; I have no clue, please.

Thanks in advance for your help.

/**Data set*/

data full_tdata;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20 icode$ 23-27 lung$ 29-35;
datalines;
OSa13         3                  73                      78          6191         cacase
OSa30         1                  39                      46          7181         cacase
OSa30         3                  56                      64          6191         cacase
OSa73         1                  23                    31          7181         popcon
OSa73         2                  31                      42          5130         popcon
OSf26         2                  70                      70          6191         popcon
OSj17         3                  60                      75          6191         cacase
OSj17         4                  65                      70          6191         cacase

OSj17 3 60 75 6191 cacase
OSj17 4 65 70 6191 cacase
;

Objectives

1) No overlap at all ie. .ids osa13 (duration=78-73=5) and osa30 (duration=46-39=7 for icode7181 and 64-56=8 for icode 6191).

2) The END of the previous matches the START of the current ie. id osa73 ; duration=31-23=8 for icode 7181 and 42-31=11 for icode 5130.

3) The START and END are the same ie. osf26: duration is automatically assigned 0.5 (70 to 70, not 0 but 0.5).

4) The START AND END of current is between START and END of previous. Eg. osj 17 jobs 3 and 4.; duration will be from 60 to 75 (ie. 75-60=15).

Expected output:

id janitor_dur janitor_ever baker_dur baker_ever plumber_dur plumber_ever
osa13 5 1 0 0                   0                     0
osa30 8 1 7 1                   0                     0
osa73 0 0 8 1                  11                    1
osf26 0.5 1 0 0                   0 0
osj17 15 1 0 0                   0 0

Icode 6191=janitor: if janitor(6191) is present (janitor_ever=1, otherwise janitor_ever=0) ; janitor_dur is the duration (jobyrout-jobyrin); icode 7181=baker, 5130=plumber.

1) No overlap at all ie. .ids osa13 (duration=78-73=5) and osa30 (duration=46-39=7 for icode7181 and 64-56=8 for icode 6191).

2) The END of the previous matches the START of the current ie. id osa73 ; duration=31-23=8 for icode 7181 and 42-31=11 for icode 5130.

3) The START and END are the same ie. osf26: duration is automatically assigned 0.5 (70 to 70, not 0 but 0.5).

4) The START AND END of current is between START and END of previous. Eg. osj 17 jobs 3 and 4.; duration will be from 60 to 75 (ie. 75-60=15).

Thanks very much in advance for your assistance.

ak.

Merge 2 datasets and get 3 outputs

jude1 — Mon, 08 Mar 2021 19:47:02 GMT

I am trying to merge the 2 datasets by var1 and create 3 datasets outputs, one that has var1 in both, one that has var1 with no income, one that has var1 with no grad_year

the data looks like this:

data mydata;

input var1 income;

datalines;

1 400

2 500

3 500

7 600

8 900

9 1000

run;

data mydata2;

var1 grad_year

1 2018

2 2019

4 2020

5 2019

6 2017

11 2019

merging is not an issue for me. I think i should use the 'if then output' statement for this but i could not figure it out.

Thanks

Uexpected merged results from two macro datasets

ak2011 — Fri, 05 Mar 2021 23:45:07 GMT

Hello,

Thanks to all who provided solutions/comments to my question of merging two macro results. However, the problem has still not been solved, so I would appreciate if someone could help me.

I am reposting the same question. The unexpected merged results (17 observations) this time is given for your perusal.

In my previous posts,I mentioned that I wanted to merge 2 macro results datasets :Table 1 (janitor)
and Table 2 (Baker). Janitor dataset is called jan and baker is bake.
The merged file mjb produced unexpected results (Table 3-17 observations).
I have still not found the solution to
my problem inspite of reading extensively on the subject from SAS Forum answers, SAS online documentation and so on.
I would appreciate your help,please.

My code, data and results are found below. My expected output is placed after results.
Thanks in advance. [The log has no errors but too long so not shown].
ak.

/**MACRO*/

data full_tdata;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20  icode$ 23-27  lung$ 29-35;
datalines;
OSa13	3	73	      78	  6191	 cacase
OSa30	1	39	      46	  7181	 cacase
OSa30	3	56	      64	  6191	 cacase
OSa73	1	23	      31	  7181	 popcon
OSa73	2	31	      42	  5130	 popcon
OSa86	3	46	      60	  6198	 cacon
OSa86	4	60	      70	  5130	 cacon
OSa93	3	68	      72	  6121	 popcon
OSf26	1	54	      54	  6198	 popcon
OSf26	2	70	      70	  6191	 popcon
OSh77	1	63	      66	  6121	 cacon
OSh77	2	66	      70	  6121	 cacon
OSh77	3	70	      71	  6121	 cacon
OSi84	1	67	      75	  6191	 cacase
OSi84	2	75	      81	  6191	 cacase
OSj17	3	60	      75	  6191	 cacase
OSj17	4	65	      70	  6191	 cacase
;

proc print data=full_tdata;
title 'Table O: Original full_tdata file'; run;

data small_tdata; set full_tdata; drop lung;


*max 4 jobs per subject;


%macro duration(database=small_tdata, icode=6191, Job_title=janitor);


*Creating a dataset containing all the jobs with selected icode;

data &Job_title;
set &database;
if icode = &icode;
run;


*transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;


*YEARIN;

proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;
by ID;
var jobyrin;
run;

proc sort data = &Job_title._yearin;
by id;
run;

*YEAROUT;

proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;
by ID;
var jobyrout;
run;

proc sort data = &Job_title._yearout;
by id;
run;



data &Job_title._final;
merge &Job_title._yearin &Job_title._yearout;
by ID;

array YEARIN (3) YEARIN1 YEARIN2 YEARIN3;
array YEAROUT (3) YEAROUT1 YEAROUT2 YEAROUT3;

array YEARINv2 (3) YEARIN2 YEARIN3 YEARIN4 ;
array YEAROUTv2 (3) YEAROUT2 YEAROUT3 YEAROUT4;

array YEARIN_F (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;
array YEAROUT_F (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

Array duration (4) Dur1 Dur2 Dur3 Dur4;



do i = 1 to 3;

if yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i) = yearin(i); yearin(i) = .;yearout(i) = .;end;
else if  yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do; yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

end;

do i = 1 to 4;

if YEARIN_F(i) = . then  YEARIN_F(i) = 0;
if YEAROUT_F(i) = . then  YEAROUT_F(i) = 0;

duration(i) = YEAROUT_F(i) - YEARIN_F(i);
if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;
end;

&Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4;

&Job_title._ever = 1;

keep ID &Job_title._dur &Job_title._ever;
run;

%MEND duration;





/* 1st macro-janitor icode 6191*/

data jan; set small_tdata;
 
 
%duration(database=small_tdata, icode=6191, Job_title=janitor);
  

proc print; 
title 'Table 1: janitor records';
run;


/* 2nd macro-baker icode 7181*/

data bake; set small_tdata;
 
%duration(database=small_tdata,icode=7181, Job_title=baker);

proc print; 
title 'Table 2: baker records';
run;


/*Merging the janitor (Table 1) and baker(Table 2) files*/

proc sort data=jan; by id;

proc sort data=bake; by id;

data mjb; merge  jan bake; by id; run;


proc print data=mjb;
Title 'Table 3: Merged Table 1(janitor) and Table 2 (baker)-Unexpected merge
This is not what I want';
run;

Table O: Original full_tdata file


Obs	id	job	jobyrin	jobyrout	icode	lung
1	OSa13	3	73	78	6191	cacase
2	OSa30	1	39	46	7181	cacase
3	OSa30	3	56	64	6191	cacase
4	OSa73	1	23	31	7181	popcon
5	OSa73	2	31	42	5130	popcon
6	OSa86	3	46	60	6198	cacon
7	OSa86	4	60	70	5130	cacon
8	OSa93	3	68	72	6121	popcon
9	OSf26	1	54	54	6198	popcon
10	OSf26	2	70	70	6191	popcon
11	OSh77	1	63	66	6121	cacon
12	OSh77	2	66	70	6121	cacon
13	OSh77	3	70	71	6121	cacon
14	OSi84	1	67	75	6191	cacase
15	OSi84	2	75	81	6191	cacase
16	OSj17	3	60	75	6191	cacase
17	OSj17	4	65	70	6191	cacase

Table 1: janitor records


Obs	id	janitor_dur	janitor_ever
1	OSa13	5.0	1
2	OSa30	8.0	1
3	OSf26	0.5	1
4	OSi84	14.0	1
5	OSj17	15.0	1

Table 2: baker records


Obs	id	baker_dur	baker_ever
1	OSa30	7	1
2	OSa73	8	1

Table 3: Merged Table 1(janitor) and Table 2 (baker)-Unexpected mergeThis is not what I want


Obs	id	job	jobyrin	jobyrout
1	OSa13	3	73	78
2	OSa30	1	39	46
3	OSa30	3	56	64
4	OSa73	1	23	31
5	OSa73	2	31	42
6	OSa86	3	46	60
7	OSa86	4	60	70
8	OSa93	3	68	72
9	OSf26	1	54	54
10	OSf26	2	70	70
11	OSh77	1	63	66
12	OSh77	2	66	70
13	OSh77	3	70	71
14	OSi84	1	67	75
15	OSi84	2	75	81
16	OSj17	3	60	75
17	OSj17	4	65	70

Expected output:

id janitor_dur janitor_ever baker_dur baker_ever
osa13 5 1 0 0
osa30 8 1 7 1
osa73 0 0 8 1
osf26 0.5 1 0 0
osi84 14 1 0 0
osj17 15 1 0 0

Tables 1 and 2 are ok, Table 3 is not good: My aim is to merge Tables 1 and 2 to obtain the expected output above.

I would finally merge janitor and baker files (merged Tables 1&2) with table 0: original file.

Please help. Thanks.

ak.

Error message: One or more variables are missing or freq or weight is zero on every observation

Mohannad — Fri, 05 Mar 2021 05:07:47 GMT

Hi all, could you please correct my input, as I got this message, and no results

Code:

DATA MD1;
INPUT I R RL;
CARDS;
1 1 13
1 2 12
1 3 9
2 1 7
2 2 5
2 3 9
3 1 5
3 2 4
3 3 6
8 1 5
8 2 5
8 3 5
;
PROC ANOVA;
CLASS I R;
MODEL RL = I R;
MEANS I / LSD;
MEANS I /TUKEY;
MEANS I / DUNCAN;
RUN;

LOG

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 DATA MD1;

74 INPUT I R RL;

75 CARDS;

NOTE: Invalid data for I in line 76 1-6.

NOTE: Invalid data for R in line 77 1-6.

NOTE: Invalid data for RL in line 78 1-5.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

78 CHAR 1.3.9

ZONE 30303222222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 19399000000000000000000000000000000000000000000000000000000000000000000000000000

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

I=. R=. RL=. _ERROR_=1 _N_=1

NOTE: Invalid data for I in line 79 1-5.

NOTE: Invalid data for R in line 80 1-5.

NOTE: Invalid data for RL in line 81 1-5.

81 CHAR 2.3.9

ZONE 30303222222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 29399000000000000000000000000000000000000000000000000000000000000000000000000000

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

I=. R=. RL=. _ERROR_=1 _N_=2

NOTE: Invalid data for I in line 82 1-5.

NOTE: Invalid data for R in line 83 1-5.

NOTE: Invalid data for RL in line 84 1-5.

84 CHAR 3.3.6

ZONE 30303222222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 39396000000000000000000000000000000000000000000000000000000000000000000000000000

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

I=. R=. RL=. _ERROR_=1 _N_=3

NOTE: Invalid data for I in line 85 1-5.

NOTE: Invalid data for R in line 86 1-5.

NOTE: Invalid data for RL in line 87 1-5.

87 CHAR 8.3.5

ZONE 30303222222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 89395000000000000000000000000000000000000000000000000000000000000000000000000000

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

I=. R=. RL=. _ERROR_=1 _N_=4

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.MD1 has 4 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

88 ;

89 PROC ANOVA;

90 CLASS I R;

91 MODEL RL = I R;

92 MEANS I / LSD;

93 MEANS I /TUKEY;

94 MEANS I / DUNCAN;

95 RUN;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

109

Merging two separate macro results

ak2011 — Fri, 05 Mar 2021 04:38:31 GMT

Hello,
In my previous post,I mentioned that I wanted to merge 2 macro results datasets :Table 1 (janitor)
and Table 2 (Baker). Janitor dataset is called jan and baker is bake.
The merged file mjb produced unexpected results (Table 3,not shown-Is the small_tdata set from which
the macro was developed(17 observations)
I have still not found the solution to
my problem inspite of reading extensively on the subject from SAS Forum answers, SAS online documentation
and so on.
I would appreciate your help,please.

My code, data and results are found below. My expected output is placed after results.
Thanks in advance. [The log has no errors but too long so not shown].
ak.

/**MACRO*/

data full_tdata;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20  icode$ 23-27  lung$ 29-35;
datalines;
OSa13	3	73	      78	  6191	 cacase
OSa30	1	39	      46	  7181	 cacase
OSa30	3	56	      64	  6191	 cacase
OSa73	1	23	      31	  7181	 popcon
OSa73	2	31	      42	  5130	 popcon
OSa86	3	46	      60	  6198	 cacon
OSa86	4	60	      70	  5130	 cacon
OSa93	3	68	      72	  6121	 popcon
OSf26	1	54	      54	  6198	 popcon
OSf26	2	70	      70	  6191	 popcon
OSh77	1	63	      66	  6121	 cacon
OSh77	2	66	      70	  6121	 cacon
OSh77	3	70	      71	  6121	 cacon
OSi84	1	67	      75	  6191	 cacase
OSi84	2	75	      81	  6191	 cacase
OSj17	3	60	      75	  6191	 cacase
OSj17	4	65	      70	  6191	 cacase
;

proc print data=full_tdata;
title 'Table O: Original full_tdata file'; run;

data small_tdata; set full_tdata; drop lung;


*max 4 jobs per subject;


%macro duration(database=small_tdata, icode=6191, Job_title=janitor);


*Creating a dataset containing all the jobs with selected icode;

data &Job_title;
set &database;
if icode = &icode;
run;


*transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;


*YEARIN;

proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;
by ID;
var jobyrin;
run;

proc sort data = &Job_title._yearin;
by id;
run;

*YEAROUT;

proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;
by ID;
var jobyrout;
run;

proc sort data = &Job_title._yearout;
by id;
run;



data &Job_title._final;
merge &Job_title._yearin &Job_title._yearout;
by ID;

array YEARIN (3) YEARIN1 YEARIN2 YEARIN3;
array YEAROUT (3) YEAROUT1 YEAROUT2 YEAROUT3;

array YEARINv2 (3) YEARIN2 YEARIN3 YEARIN4 ;
array YEAROUTv2 (3) YEAROUT2 YEAROUT3 YEAROUT4;

array YEARIN_F (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;
array YEAROUT_F (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

Array duration (4) Dur1 Dur2 Dur3 Dur4;



do i = 1 to 3;

if yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) 
and yearoutv2(i) ge yearout(i) then do; yearinv2(i) = yearin(i); yearin(i) = .;yearout(i) = .;end;
else if  yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) 
and yearoutv2(i) lt yearout(i) 
then do; yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

end;

do i = 1 to 4;

if YEARIN_F(i) = . then  YEARIN_F(i) = 0;
if YEAROUT_F(i) = . then  YEAROUT_F(i) = 0;

duration(i) = YEAROUT_F(i) - YEARIN_F(i);
if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;
end;

&Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4;

&Job_title._ever = 1;

keep ID &Job_title._dur &Job_title._ever;
run;

%MEND duration;


/* 1st macro-janitor icode 6191*/

data jan; set small_tdata;
 
 
%duration(database=small_tdata, icode=6191, Job_title=janitor);
  

proc print; 
title 'Table 1: janitor records';
run;


/* 2nd macro-baker icode 7181*/

data bake; set small_tdata;
 
%duration(database=small_tdata,icode=7181, Job_title=baker);

proc print; 
title 'Table 2: baker records';
run;


/*Merging the janitor (Table 1) and baker(Table 2) files*/

proc sort data=jan; by id;

proc sort data=bake; by id;

data mjb; merge  jan bake; by id; run;


proc print data=mjb;
Title 'Table 3: Merged Table 1(janitor) and Table 2 (baker)-Unexpected merge';
run;

Table O: Original full_tdata file


Obs	id	job	jobyrin	jobyrout	icode	lung
1	OSa13	3	73	78	6191	cacase
2	OSa30	1	39	46	7181	cacase
3	OSa30	3	56	64	6191	cacase
4	OSa73	1	23	31	7181	popcon
5	OSa73	2	31	42	5130	popcon
6	OSa86	3	46	60	6198	cacon
7	OSa86	4	60	70	5130	cacon
8	OSa93	3	68	72	6121	popcon
9	OSf26	1	54	54	6198	popcon
10	OSf26	2	70	70	6191	popcon
11	OSh77	1	63	66	6121	cacon
12	OSh77	2	66	70	6121	cacon
13	OSh77	3	70	71	6121	cacon
14	OSi84	1	67	75	6191	cacase
15	OSi84	2	75	81	6191	cacase
16	OSj17	3	60	75	6191	cacase
17	OSj17	4	65	70	6191	cacase

Table 1: janitor records


Obs	id	janitor_dur	janitor_ever
1	OSa13	5.0	1
2	OSa30	8.0	1
3	OSf26	0.5	1
4	OSi84	14.0	1
5	OSj17	15.0	1

Table 2: baker records


1	OSa30	7
2	OSa73	8

Expected output:

id janitor_dur janitor_ever baker_dur baker_ever
osa13 5 1 0 0
osa30 8 1 7 1
osa73 0 0 8 1
osf26 0.5 1 0 0
osi84 14 1 0 0
osj17 15 1 0 0

Tables 1 and 2 are ok, but the problem is merging them to obtain the expected output above.

I would finally merge janitor and baker files with table 0: original file.

Please help. Thanks.

ak.

Merging two macro results

ak2011 — Thu, 04 Mar 2021 23:30:33 GMT

Hello,
I have two separate macro results (macro for janitor and macro for baker) and 
my aim is to merge the two datasets together, but they are not working.

Data set for janitor macro is jan and that for baker is bake.

Table 1 is janitor results and Table 2 is baker results (shown below).

proc print data=jan; doesn't work; same with proc print data=bake;
So to print janitor records, I just do proc print; and it works; same with baker.

Help is needed, please to merge dataset jan and dataset bake, and  to be merged 
finally with the original data Table o.

[I did not run the merge procedures as they would print the 17 records (small_t_data)

My data, code and results are found below:
Thanks in advance. [ No errors in log-too long so not shown]
ak.

[As usual, I have read the SAS community answers & SAS documentation on macros but still no solution
found]. I would appreciate your help, please.

/**MACRO*/

data full_tdata;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20  icode$ 23-27  lung$ 29-35;
datalines;
OSa13	3	73	      78	  6191	 cacase
OSa30	1	39	      46	  7181	 cacase
OSa30	3	56	      64	  6191	 cacase
OSa73	1	23	      31	  7181	 popcon
OSa73	2	31	      42	  5130	 popcon
OSa86	3	46	      60	  6198	 cacon
OSa86	4	60	      70	  5130	 cacon
OSa93	3	68	      72	  6121	 popcon
OSf26	1	54	      54	  6198	 popcon
OSf26	2	70	      70	  6191	 popcon
OSh77	1	63	      66	  6121	 cacon
OSh77	2	66	      70	  6121	 cacon
OSh77	3	70	      71	  6121	 cacon
OSi84	1	67	      75	  6191	 cacase
OSi84	2	75	      81	  6191	 cacase
OSj17	3	60	      75	  6191	 cacase
OSj17	4	65	      70	  6191	 cacase
;

proc print data=full_tdata;
title 'Table O: Original full_tdata file'; run;

data small_tdata; set full_tdata; drop lung;


*max 4 jobs per subject;


%macro duration(database=small_tdata, icode=6191, Job_title=janitor);


*Creating a dataset containing all the jobs with selected icode;

data &Job_title;
set &database;
if icode = &icode;
run;


*transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;


*YEARIN;

proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;
by ID;
var jobyrin;
run;

proc sort data = &Job_title._yearin;
by id;
run;

*YEAROUT;

proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;
by ID;
var jobyrout;
run;

proc sort data = &Job_title._yearout;
by id;
run;



data &Job_title._final;
merge &Job_title._yearin &Job_title._yearout;
by ID;

array YEARIN (3) YEARIN1 YEARIN2 YEARIN3;
array YEAROUT (3) YEAROUT1 YEAROUT2 YEAROUT3;

array YEARINv2 (3) YEARIN2 YEARIN3 YEARIN4 ;
array YEAROUTv2 (3) YEAROUT2 YEAROUT3 YEAROUT4;

array YEARIN_F (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;
array YEAROUT_F (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

Array duration (4) Dur1 Dur2 Dur3 Dur4;



do i = 1 to 3;

if yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i) = yearin(i); yearin(i) = .;yearout(i) = .;end;
else if  yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do; yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

end;

do i = 1 to 4;

if YEARIN_F(i) = . then  YEARIN_F(i) = 0;
if YEAROUT_F(i) = . then  YEAROUT_F(i) = 0;

duration(i) = YEAROUT_F(i) - YEARIN_F(i);
if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;
end;

&Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4;

&Job_title._ever = 1;

keep ID &Job_title._dur &Job_title._ever;
run;

%MEND duration;


/* 1st macro-janitor icode 6191*/

data jan; set small_tdata;
 
%duration(database=small_tdata, icode=6191, Job_title=janitor);

proc print; 
title 'Table 1: janitor records';
run;
proc sort data=jan; by id;


/* 2nd macro-baker icode 7181*/

data bake; set small_tdata;
 
%duration(database=small_tdata,icode=7181, Job_title=baker);

proc print; 
title 'Table 2: baker records';
run;

Table O: Original full_tdata file


Obs	id	job	jobyrin	jobyrout	icode	lung
1	OSa13	3	73	78	6191	cacase
2	OSa30	1	39	46	7181	cacase
3	OSa30	3	56	64	6191	cacase
4	OSa73	1	23	31	7181	popcon
5	OSa73	2	31	42	5130	popcon
6	OSa86	3	46	60	6198	cacon
7	OSa86	4	60	70	5130	cacon
8	OSa93	3	68	72	6121	popcon
9	OSf26	1	54	54	6198	popcon
10	OSf26	2	70	70	6191	popcon
11	OSh77	1	63	66	6121	cacon
12	OSh77	2	66	70	6121	cacon
13	OSh77	3	70	71	6121	cacon
14	OSi84	1	67	75	6191	cacase
15	OSi84	2	75	81	6191	cacase
16	OSj17	3	60	75	6191	cacase
17	OSj17	4	65	70	6191	cacase

Table 1: janitor records


Obs	id	janitor_dur	janitor_ever
1	OSa13	5.0	1
2	OSa30	8.0	1
3	OSf26	0.5	1
4	OSi84	14.0	1
5	OSj17	15.0	1

Table 2: baker records


Obs	id	baker_dur		baker_ever
1	OSa30	7		1
2	OSa73	8		1


Tables 1 and 2 results are what I am expecting but the problem is how to merge them.
Thanks in advance for your help.

ak.

getting error ERROR 22-322: Syntax error, expecting one of the following: !!, *, **, +, -, .., /, <

jinssbox — Thu, 04 Mar 2021 17:28:34 GMT

proc optmodel;
var XA1,XA2,XA3,XB1,XB2,XB3,XC1,XC2,XC3,XD1,XD2,XD3;
max Z = 500XA1 + 650XA2 + 400XA3 + 750XB1 + 800XB2 + 700XB3 + 300XC1 + 400XC2 + 500XC3 + 450XD1 + 600XD2 + 550XD3;
con
XA1+XB1+XC1+XD1=12,
XA2+XB2+XC2+XD2=17,
XA3+XB3+XC3+XD3=11,
XA1+XA2+XA3=10,
XB1+XB2+XB3=10,
XC1+XC2+XC3=10,
XA1>=0,XA2>=0,XA3>=0,XB1>=0,XB2>=0,XB3>=0,XC1>=0,XC2>=0,XC3>=0,XD1>=0,XD2>=0,XD3>=0;
solve;
print XA1 XA2 XA3 XB1 XB2 XB3 XC1 XC2 XC3 XD1 XD2 XD3;run;

Macro results not showing

ak2011 — Thu, 04 Mar 2021 17:01:14 GMT

Hello,

I posted this same macro question in my previous post and 2 people made comments on that. I have corrected the work based on their comments but the problem persists; I am unable to see the results of the macro and the log gives no error message.

Help needed, please.

My data, code and log are given below:

Thans for in advance for your help.

ak.


/***MACRO*/

data full_tdata;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20  icode$ 23-27  lung$ 29-35;
datalines;
OSa13	3	73	      78	  6191	 cacase
OSa30	1	39	      46	  7181	 cacase
OSa30	3	56	      64	  6191	 cacase
OSa73	1	23	      31	  7181	 popcon
OSa73	2	31	      42	  5130	 popcon
OSa86	3	46	      60	  6198	 cacon
OSa86	4	60	      70	  5130	 cacon
OSa93	3	68	      72	  6121	 popcon
OSf26	1	54	      54	  6198	 popcon
OSf26	2	70	      70	  6191	 popcon
OSh77	1	63	      66	  6121	 cacon
OSh77	2	66	      70	  6121	 cacon
OSh77	3	70	      71	  6121	 cacon
OSi84	1	67	      75	  6191	 cacase
OSi84	2	75	      81	  6191	 cacase
OSj17	3	60	      75	  6191	 cacase
OSj17	4	65	      70	  6191	 cacase
;

proc print data=full_tdata;

data small_tdata; set full_tdata; drop lung;

proc freq data=small_tdata;
tables job; run;  

proc print data=small_tdata;
run;
 
 
 /* MACRO TEST*/

*max 4 jobs per subject;


%macro duration(database=small_tdata, icode=icode, Job_title="baker");

*Creating a dataset containing all the jobs with selected icode;

data &Job_title;
set &database;
if icode = "&6191";
run;


*transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;


*YEARIN;

proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;
by ID;
var jobyrin;
run;

proc sort data = &Job_title._yearin;
by id;
run;

*YEAROUT;

proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;
by ID;
var jobyrout;
run;

proc sort data = &Job_title._yearout;
by id;
run;



data &Job_title._final;
merge &Job_title._yearin &Job_title._yearout;
by ID;

array YEARIN (3) YEARIN1 YEARIN2 YEARIN3;
array YEAROUT (3) YEAROUT1 YEAROUT2 YEAROUT3;

array YEARINv2 (3) YEARIN2 YEARIN3 YEARIN4 ;
array YEAROUTv2 (3) YEAROUT2 YEAROUT3 YEAROUT4;

array YEARIN_F (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;
array YEAROUT_F (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

Array duration (4) Dur1 Dur2 Dur3 Dur4;



do i = 1 to 3;

if yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i) = yearin(i); yearin(i) = .;yearout(i) = .;end;
else if  yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do; yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

end;

do i = 1 to 4;

if YEARIN_F(i) = . then  YEARIN_F(i) = 0;
if YEAROUT_F(i) = . then  YEAROUT_F(i) = 0;

duration(i) = YEAROUT_F(i) - YEARIN_F(i);
if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;
end;

&Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4;

&Job_title._ever = 1;

keep ID &Job_title._dur &Job_title._ever;
run;

/* Display the macro results*//*????? I am stuck here, please*/

%duration(database=small_tdata,icode=icode, Job_title=baker);

proc print data=&Job_title_final;
run;

%MEND duration;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

2 TITLE;

3 FOOTNOTE;

4 OPTIONS LOCALE=en_US DFLANG=LOCALE;

5 DATA _NULL_;

6 RUN;

7 OPTIONS VALIDVARNAME=V7;

8 OPTIONS VALIDMEMNAME=EXTEND;

9 FILENAME _HTMLOUT TEMP;

10 FILENAME _RTFOUT TEMP ENCODING='UTF-8';

11 FILENAME _PDFOUT TEMP;

12 FILENAME _GSFNAME TEMP;

13 FILENAME _DATAOUT TEMP;

14 %LET SYSCC=0;

15 %LET _CLIENTAPP='SAS Studio';

16 %LET _CLIENTAPPABREV=Studio;

17 %LET _CLIENTAPPVERSION=3.8;

18 %LET _CLIENTVERSION=3.8;

19 %LET _CLIENTMODE=basic;

20 %LET _SASSERVERNAME=%BQUOTE(localhost);

21 %LET _SASHOSTNAME=%BQUOTE(localhost);

22 %LET _SASPROGRAMFILEHOST=%BQUOTE(localhost);

23 %LET _CLIENTUSERID=%BQUOTE(sasdemo);

24 %LET _CLIENTUSERNAME=%BQUOTE(sasdemo);

25 %LET CLIENTMACHINE=%BQUOTE(10.0.2.2);

26 %LET _CLIENTMACHINE=%BQUOTE(10.0.2.2);

27 %let SASWORKLOCATION="%sysfunc(getoption(work))/";

28 FILENAME _CWD '.';

29 DATA _NULL_;

30 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));

31 RUN;

32 FILENAME _CWD;

34 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/folders/myfolders/multisitedata/Occup_Macro_ZM19.sas));

35 %LET _BASEURL = %BQUOTE(http://localhost:10080/SASStudio/);

36 %LET _EXECENV=SASStudio;

37 DATA _NULL_;

38 CALL SYMPUT("GRAPHINIT","");

39 CALL SYMPUT("GRAPHTERM","");

40 RC=TSLVL('SASXGOPT','N');

41 _ERROR_=0;

42 IF (RC^=' ') THEN DO;

43 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");

44 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");

45 END;

46 RUN;

47 DATA _NULL_;

48 RC=SYSPROD("PRODNUM002");

49 IF (RC^=1) THEN DO;

50 CALL SYMPUT("GRAPHINIT","");

51 CALL SYMPUT("GRAPHTERM","");

52 END;

53 RUN;

54 %LET _DATAOUT_MIME_TYPE=;

55 %LET _DATAOUT_NAME=;

56 %LET _DATAOUT_TABLE=;

57 %LET _DATAOUT_URL=;

58 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;

59 %LET _SASWS_ = %BQUOTE(/folders/myfolders);

60 %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.sasstudio/.images/717c6288-07d7-4390-9c85-69b0718d63f4);

61 ODS LISTING CLOSE;

62 ODS AUTONAVIGATE OFF;

63 ODS GRAPHICS ON;

64 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results: Occup_Macro_ZM19.sas')

64 ! STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'

64 ! CSS_PREFIX='.ods_717c6288-07d7-4390-9c85-69b0718d63f4' BODY_ID='div_717c6288-07d7-4390-9c85-69b0718d63f4' );

65 ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate;

66 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT;

67 &GRAPHINIT;

68 OPTIONS FIRSTOBS=1;

69 OPTIONS OBS=MAX;

70 OPTIONS DTRESET DATE NUMBER NOTES;

71 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;

74 /***MACRO*/

76 data full_tdata;

77 input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20 icode$ 23-27 lung$ 29-35;

78 datalines;

79 OSa13373 78 6191 cacase

80 OSa30139 46 7181 cacase

81 OSa30356 64 6191 cacase

82 OSa73123 31 7181 popcon

83 OSa73231 42 5130 popcon

84 OSa86346 60 6198 cacon

85 OSa86460 70 5130 cacon

86 OSa93368 72 6121 popcon

87 OSf26154 54 6198 popcon

88 OSf26270 70 6191 popcon

89 OSh77163 66 6121 cacon

90 OSh77266 70 6121 cacon

91 OSh77370 71 6121 cacon

92 OSi84167 75 6191 cacase

93 OSi84275 81 6191 cacase

94 OSj17360 75 6191 cacase

95 OSj17465 70 6191 cacase

96 ;

98 proc print data=full_tdata;

100 data small_tdata; set full_tdata; drop lung;

101

102 proc freq data=small_tdata;

103 tables job; run;

104

105 proc print data=small_tdata;

106 run;

107

108

109 /* MACRO TEST*/

110

111 *max 4 jobs per subject;

112

113

114 %macro duration(database=small_tdata, icode=icode, Job_title="baker");

115

116 *Creating a dataset containing all the jobs with selected icode;

117

118 data &Job_title;

119 set &database;

120 if icode = "&6191";

121 run;

122

123

124 *transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;

125

126

127 *YEARIN;

128

129 proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;

130 by ID;

131 var jobyrin;

132 run;

133

134 proc sort data = &Job_title._yearin;

135 by id;

136 run;

137

138 *YEAROUT;

139

140 proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;

141 by ID;

142 var jobyrout;

143 run;

144

145 proc sort data = &Job_title._yearout;

146 by id;

147 run;

148

149

150

151 data &Job_title._final;

152 merge &Job_title._yearin &Job_title._yearout;

153 by ID;

154

155 array YEARIN (3) YEARIN1 YEARIN2 YEARIN3;

156 array YEAROUT (3) YEAROUT1 YEAROUT2 YEAROUT3;

157

158 array YEARINv2 (3) YEARIN2 YEARIN3 YEARIN4 ;

159 array YEAROUTv2 (3) YEAROUT2 YEAROUT3 YEAROUT4;

160

161 array YEARIN_F (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;

162 array YEAROUT_F (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

163

164 Array duration (4) Dur1 Dur2 Dur3 Dur4;

165

166

167

168 do i = 1 to 3;

169

170 if yearin(i) ne . and yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i)

170 ! = yearin(i); yearin(i) = .;yearout(i) = .;end;

171 else if yearin(i) ne . and yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do;

171 ! yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

172

173 end;

174

175 do i = 1 to 4;

176

177 if YEARIN_F(i) = . then YEARIN_F(i) = 0;

178 if YEAROUT_F(i) = . then YEAROUT_F(i) = 0;

179

180 duration(i) = YEAROUT_F(i) - YEARIN_F(i);

181 if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;

182 end;

183

184 &Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4;

185

186 &Job_title._ever = 1;

187

188 keep ID &Job_title._dur &Job_title._ever;

189 run;

190

191 /* Display the macro results*//*????? I am stuck here, please*/

192

193 %duration(database=small_tdata,icode=icode, Job_title=baker);

194

195 proc print data=&Job_title_final;

196 run;

197

198 %MEND duration;

199

200

201 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

202 ODS HTML CLOSE;

203 &GRAPHTERM; ;*';*";*/;RUN;QUIT;

204 QUIT;RUN;

205 ODS HTML5 (ID=WEB) CLOSE;

206

207 ODS RTF (ID=WEB) CLOSE;

208 ODS PDF (ID=WEB) CLOSE;

209 FILENAME _GSFNAME;

210 DATA _NULL_;

211 RUN;

212 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;

213

Please I am expecting the macro to print out the results of all the necessary variables:

id yearin yearout yearin_f yearout_f job_title_dur job_title_ever.......

Thank you.

ak.

Ignoring missing values in Do Loop

ellpap — Thu, 04 Mar 2021 01:01:18 GMT

Hi,

I am having some issues with an array and do loop.

CODE:

data lettergrade;
set detailrounded;
array english_array[*] _numeric_;
do i = 1 to dim(english_array);
if english>=90 then englishgrade="A";
if english>=75 and english<=89 then englishgrade="B";
if english>=60 and english<=74 then englishgrade="C";
if english<=60 then englishgrade="D";
end;

Some of my values are missing and I did not want SAS to automatically assign a letter grade of "D". Is there anyway to exclude any missing data points so no letter grade shows up?
Let me know if that makes sense or if clarification is needed!

Displaying macro results

ak2011 — Wed, 03 Mar 2021 12:01:40 GMT

Hello,

I would appreciate if someone could check my macro code below to see how best I can display the results of the written macro. Thanks.

My main objectives:

For each id, to check if 1^st job overlaps with 2^nd job: if not do nothing. If yes, assign 1^st job start year to 2^nd job; and record 1^st job start and end years as missing, to avoid counting the same year as twice. Eg. for Osa73, jobyrout for job 1 is 31; same with jobyrin job 2.
Repeat procedure with newly created 2^nd job and 3^rd job.
Assign 0 to missing values and calculate duration of each remaining job; Jobs with same start and end yrs are coded as 0.5 year
Sum all durations to obtain final duration variable
Create ever held job as plumber ie. if icdode 6191=plumber(1=yes).

My code and log are found below:

I have tried many code to display/view the macros results but none of them worked.[I checked SAS forum and documentation too, but no solution found].

Help needed, please.

Thanks.

Ak.


data small_data;
input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20  icode$ 23-27  lung$ 29-35;
datalines;
OSa13	3	73	      78	  6191	 cacase
OSa30	1	39	      46	  7181	 cacase
OSa30	3	56	      64	  6191	 cacase
OSa73	1	23	      31	  7181	 popcon
OSa73	2	31	      42	  5130	 popcon
OSa86	3	46	      60	  6198	 cacon
OSa86	4	60	      70	  5130	 cacon
OSa93	3	68	      72	  6121	 popcon
OSf26	1	54	      54	  6198	 popcon
OSf26	2	70	      70	  6191	 popcon
OSh77	1	63	      66	  6121	 cacon
OSh77	2	66	      70	  6121	 cacon
OSh77	3	70	      71	  6121	 cacon
OSi84	1	67	      75	  6191	 cacase
OSi84	2	75	      81	  6191	 cacase
;
proc print data=small_data;

data jobd; set small_data; drop lung;

proc freq data=jobd;
tables job; run;


proc print data=jobd;
run;
 
 
 /* MACRO TEST*/

*max 4 jobs per subject in multi dataset so macro will consider a maximum of 4 potential jobs;


%macro duration(database=small_data,icode=6191, Job_title=plumber);

*Creating a dataset containing all the jobs with the selected CCDO 4-digit code;

data &Job_title;
set &database;
if icode = &6191;
run;


*transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;


*YEARIN;

proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;
by ID;
var jobyrin;
run;

proc sort data = &Job_title._yearin;
by id;
run;

*YEAROUT;

proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;
by ID;
var jobyrout;
run;

proc sort data = &Job_title._yearout;
by id;
run;



data &Job_title._final;
merge &Job_title._yearin &Job_title._yearout;
by ID;

array YEARIN (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;
array YEAROUT (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;
array YEARINv2 (4) YEARIN2 YEARIN3 YEARIN4 ;
array YEAROUTv2 (4) YEAROUT2 YEAROUT3 YEAROUT4;

array YEARIN_F (5) YEARIN1 YEARIN2 YEARIN3 YEARIN4 YEARIN5;
array YEAROUT_F (5) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4 YEAROUT5;
Array duration (5) Dur1 Dur2 Dur3 Dur4 Dur5;



do i = 1 to 4;

if yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i) = yearin(i); yearin(i) = .;yearout(i) = .;end;
else if  yearin(i) ne . and  yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do; yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

end;

do i = 1 to 5;

if YEARIN_F(i) = . then  YEARIN_F(i) = 0;
if YEAROUT_F(i) = . then  YEAROUT_F(i) = 0;

duration(i) = YEAROUT_F(i) - YEARIN_F(i);
if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;
end;

&Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4 + Dur5;

&Job_title._ever = 1;

keep ID &Job_title._dur &Job_title._ever;
run;

%MEND duration;

/* Display the macro results*//*????? I am stuck here*/

proc print data=Job_title._final; run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data small_data;

74 input id$ 1-6 job 7-8 jobyrin 9-11 jobyrout 18-20 icode$ 23-27 lung$ 29-35;

75 datalines;

NOTE: The data set WORK.SMALL_DATA has 15 observations and 6 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.02 seconds

91 ;

92 proc print data=small_data;

NOTE: There were 15 observations read from the data set WORK.SMALL_DATA.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.22 seconds

cpu time 0.23 seconds

94 data jobd; set small_data; drop lung;

NOTE: There were 15 observations read from the data set WORK.SMALL_DATA.

NOTE: The data set WORK.JOBD has 15 observations and 5 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

96 proc freq data=jobd;

97 tables job; run;

NOTE: There were 15 observations read from the data set WORK.JOBD.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.12 seconds

cpu time 0.11 seconds

100 proc print data=jobd;

101 run;

NOTE: There were 15 observations read from the data set WORK.JOBD.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.16 seconds

cpu time 0.16 seconds

102

103

104 /* MACRO TEST*/

105

106 *max 4 jobs per subject in multi dataset so macro will consider a maximum of 4 potential jobs;

107

108

109 %macro duration(database=small_data,icode=6191, Job_title=plumber);

110

111 *Creating a dataset containing all the jobs with the selected CCDO 4-digit code;

112

113 data &Job_title;

114 set &database;

115 if icode = &6191;

116 run;

117

118

119 *transposing dataset so that the YEARIN and YEAROUT of all jobs held by a subject are in the same row;

120

121

122 *YEARIN;

123

124 proc transpose data = &Job_title out = &Job_title._yearin prefix = YEARIN;

125 by ID;

126 var jobyrin;

127 run;

128

129 proc sort data = &Job_title._yearin;

130 by id;

131 run;

132

133 *YEAROUT;

134

135 proc transpose data = &Job_title out = &Job_title._yearout prefix = YEAROUT;

136 by ID;

137 var jobyrout;

138 run;

139

140 proc sort data = &Job_title._yearout;

141 by id;

142 run;

143

144

145

146 data &Job_title._final;

147 merge &Job_title._yearin &Job_title._yearout;

148 by ID;

149

150 array YEARIN (4) YEARIN1 YEARIN2 YEARIN3 YEARIN4;

151 array YEAROUT (4) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4;

152 array YEARINv2 (4) YEARIN2 YEARIN3 YEARIN4 ;

153 array YEAROUTv2 (4) YEAROUT2 YEAROUT3 YEAROUT4;

154

155 array YEARIN_F (5) YEARIN1 YEARIN2 YEARIN3 YEARIN4 YEARIN5;

156 array YEAROUT_F (5) YEAROUT1 YEAROUT2 YEAROUT3 YEAROUT4 YEAROUT5;

157 Array duration (5) Dur1 Dur2 Dur3 Dur4 Dur5;

158

159

160

161 do i = 1 to 4;

162

163 if yearin(i) ne . and yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) ge yearout(i) then do; yearinv2(i)

163 ! = yearin(i); yearin(i) = .;yearout(i) = .;end;

164 else if yearin(i) ne . and yearinv2(i) ne . and yearinv2(i) le yearout(i) and yearoutv2(i) lt yearout(i) then do;

164 ! yearinv2(i) = yearin(i);yearoutv2(i) = yearout(i); yearin(i) = .;yearout(i) = .;end;

165

166 end;

167

168 do i = 1 to 5;

169

170 if YEARIN_F(i) = . then YEARIN_F(i) = 0;

171 if YEAROUT_F(i) = . then YEAROUT_F(i) = 0;

172

173 duration(i) = YEAROUT_F(i) - YEARIN_F(i);

174 if YEARIN_F(i) ne 0 and YEAROUT_F(i) = YEARIN_F(i) then duration(i) = 0.5;

175 end;

176

177 &Job_title._dur = Dur1 + Dur2 + Dur3 + Dur4 + Dur5;

178

179 &Job_title._ever = 1;

180

181 keep ID &Job_title._dur &Job_title._ever;

182 run;

183

184 %MEND duration;

185

186 /* Display the macro results*//*????? I am stuck here*/

187

188 proc print data=Job_title._final; run;

ERROR: Libref 'Job_title' exceeds 8 characters.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

189

190

191

192 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

204

Thanks in advance for your help.

ak.

Schedule batch job in SAS Studio

Siuli — Tue, 23 Feb 2021 18:37:16 GMT

I am trying to check if I can run automated batch job in SAS Studio. For example, I have couple of codes which I want to run in different time and want to schedule so that when the time comes the specific code starts running. I referred to the site: How to run SAS Studio 5 program on a schedule? - SAS Support Communities but I saw user opened SAS Job Execution which I do not find in SAS Studio.

Please can somebody help.

Thanks,

Siuli Basu

Accounting for zero inflated data as response in glimmix

adrianacravo — Tue, 23 Feb 2021 16:08:44 GMT

Hello, everyone,

I've been using the proc glimmix approach for quite some time now to account for random effects while exploring my response of interest, but now I have a new variable, which is zero inflated, and I want to take it into account as a response. There are 76 samples with values different than zero and 238 with 0 as value (Bd_load). I also have the binomial option of the variable (Bd_presence), which replaces the values above 0 by 1, but does not change the ratio of 0/ non zero.

That's my model:

PROC GLIMMIX DATA=Bddata plots=all;
CLASS lake;
MODEL observed_spp = Bd_load julian_date altitude longitude human_impact / link=log s dist=negbin DDFM=SATTERTH; 
random lake;
RUN;

Where observed_spp is the number of species observed in each sample, julian_date/ altitude/ longitude/ human_impact are quantitative variables without any zero and Bd_load indicates my zero inflated vector. My question is: do I need to treat this variable in a special way so it can be correctly taken into account, or it can be considered like that, since it is an explanatory variable and not my response?
I tried to change the order and ran the following model

PROC GLIMMIX DATA=Bddata plots=all;
CLASS lake;
MODEL Bd_load = observed_spp julian_date altitude longitude human_impact / link=log s dist=negbin DDFM=SATTERTH; 
random lake;
RUN;

to see if the model was correctly structured for zero inflated data, but it did not converge using the variable as the response and negative binomial as distribution.
Does someone know what I could change to correctly consider my variable?
Many thanks in advance,

Adriana

No output after running successfully

Addis — Tue, 23 Feb 2021 02:50:39 GMT

I use Sas EG and my proc sql have no errors. When I run it the first time, it generated output , then I made a few changes to the code like adding fields , in select and group by and when I run it, there is no error in log , and yet there is no output tab altogether! I am new to SAS and beginning to learn how it works. Please help.

Thanks

SAS filetypes FDB, MDDB, DMDB

JohnSASNew — Fri, 19 Feb 2021 21:35:16 GMT

Hi All,
I am new in a SAS community and using SAS Studio.
I am wondering if you could pls send some examples of code that helps me to generate such files in my Data folder
.sas7bfdb - FDB
.sas7bmdb - MDDB
.sas7bdmd - DMDB
Maybe do you have some samples based on SASHELP library to look at them?
Thanks a lot for any help

invalid object specified

AronN — Thu, 18 Feb 2021 19:12:27 GMT

I am new to SAS so perhaps it is a simple error. I am using code and data that someone else wrote and worked on their system. Data is being read in, but I get the error "Invalid object specified to bridge protocol engine." It seems I may need to do a "hot fix" but none of the fixes seemed to address this issue. I am running Studio 3.81. Thanks

Here is the code, and I have attached five of the sixteen input files (maximum allowed).

options ls=132; * nocenter; * nodate nonumber 80 ps=9999;
/*OITP Summary 110320_AN-INS1BLACK*/
%macro transit(CallN,Man,Ins,Col);
data d&CallN; infile "c:\SAS_Data\OITP Summary 012621_&Man-&Ins&Col..csv" dlm=',' dsd truncover;
MANUF="&Man"; length Layer1 Layer2 $ 5; Layer1="&Ins"; Layer2="&Col"; if Layer2=' ' then Layer2='none';
* input (NO TYPE LAB COLOUR TEMP DRATE) ($) TIME_d (LAB_A MODEL CALIB RAMP TEMP_T FLOW_O FLOW_N) ($) WT1-WT5 OITP1-OITP5;
input (NO TYPE LAB COLOUR TEMP DRATE) ($) TIME_d (LAB_A MODEL CALIB RAMP FLOW_O) ($) WT1-WT5 OITP1-OITP5; chk=substr(NO,1,1);
if 'A'<=chk<='R' then do; chk2=substr(NO,6,1); chk3=substr(NO,7,1);
if '1'<=chk2<='5' then Chamber=chk2; else if '1'<=chk3<='5' then Chamber=chk3; end;
else if '1'<=chk<='6' then Chamber=chk; else delete; if WT1=. then delete;
keep MANUF Layer1 Layer2 TIME_d WT1-WT5 OITP1-OITP5 Chamber;
proc print uniform; var MANUF Layer1 Layer2 Chamber TIME_d WT1-WT5 OITP1-OITP5; title "&CallN Raw &Man-&Ins&Col Data";
data d&CallN; set d&CallN;
if TIME_d=0 then do Chamber='1','2','3','4','5'; output; end; else output;
data d&CallN; set d&CallN; keep MANUF Layer1 Layer2 TIME_d WT OITP Chamber rep;
rep=1; Wt=WT1; OITP=OITP1; output;
rep=2; Wt=WT2; OITP=OITP2; output;
rep=3; Wt=WT3; OITP=OITP3; output;
rep=4; Wt=WT4; OITP=OITP4; output;
rep=5; Wt=WT5; OITP=OITP5; output;
data d&CallN; set d&CallN; if wt>.;
proc print uniform; var MANUF Layer1 Layer2 Chamber TIME_d rep WT OITP; title "&CallN Transposed &Man-&Ins&Col Data";
%mend transit;

%transit(1,RB,J,);
%transit(2,RB,INS1,);
%transit(3,RB,INS2,);
%transit(4,RB,INS3,);
%transit(5,AN,J,);
%transit(6,AN,INS1,BLACK);
%transit(7,AN,INS1,PINK);
%transit(8,AN,INS2,BLACK);
%transit(9,AN,INS2,PINK);
%transit(10,BW,J,);
%transit(11,BW,INS1,);
%transit(12,BW,INS2,);
%transit(13,OK,INS1,);
%transit(14,OK,INS2,);
%transit(15,OK,INS3,);
%transit(16,OK,J,);
data all; set d1 d2 d3 d4 d5 d6 d7 d8 d9 d10 d11 d12 d13 d14 d15 d16; CHAM=0; CHAM=Chamber;
temp=(CHAM=1)*55 + (CHAM>1)*81;
wet =(CHAM=2)    + (CHAM=4);
GrHr =(CHAM>3)*20 + (CHAM<4)*69; time_m=TIME_d/30; Exp=time_m/2; drop TIME_d Exp;
* time=Exp*2; dose=round((GrHr=20)*Exp*23.2/8 + (GrHr=69)*Exp*80/8,.1);
proc corr; title 'Basic Relationships for OITP and Read or Generated Variables';
proc univariate normal plot; var OITP; ID Wt;
proc glm; class MANUF Layer1 Layer2 CHAM rep;
model OITP = MANUF Layer1 Layer2 CHAM rep TEMP WET GRHR TIME_m DOSE wt; title2 'Step 0. OITP Full Model';
proc glm; class MANUF Layer1 Layer2 CHAM    ;
model OITP = MANUF Layer1 Layer2 CHAM     TEMP WET GRHR TIME_m DOSE wt; title2 'Step 1. OITP: Drop REP';
proc glm; class MANUF Layer1 Layer2 CHAM    ;
model OITP = MANUF Layer1 Layer2 CHAM     TEMP WET GRHR TIME_m DOSE   ; title2 'Step 2. OITP: Drop REP, WT';
proc glm; class MANUF Layer1 Layer2         ;
model OITP = MANUF Layer1 Layer2          TEMP WET GRHR TIME_m DOSE   ; title2 'Step 3. OITP: Drop REP, WT, CHAM';
proc glm; class MANUF Layer1 Layer2         ;
model OITP = MANUF Layer1 Layer2               WET GRHR TIME_m DOSE   ; title2 'Step 4. OITP: Drop REP, WT, CHAM, TEMP';
proc glm; class MANUF Layer1 Layer2         ;
model OITP = MANUF Layer1 Layer2               WET      TIME_m DOSE   /noint solution; title2 'Step 5. OITP: Drop REP, WT, CHAM, TEMP, GRHR';

endsas;*======================================================================================================;

Looking for SAS Studio tutor for hire for college student in Biostatistics course

b_clay — Wed, 17 Feb 2021 16:30:19 GMT

Online format, probably a few one-hour sessions. Student is a public health major - not a programmer.

Disable SAS Studio Splash Screen

tedway — Mon, 15 Feb 2021 19:09:53 GMT

Is there a way to prevent SAS Studio from displaying the splash screen at launch or at least a way to make it so that it isn't on top of all other windows?

I tried adding -NOSPLASH to my SAS config file but that apparently refers to something else.

Just to restate the issue, whenever I launch SAS Studio the below window displays for several seconds and it covers up all other Windows (i.e. my browser, other applications, etc.) and can't be closed or moved.

Creating tertiles based on a control group

gejoachim99 — Sun, 14 Feb 2021 20:39:23 GMT

I want to create tertiles to organize my data into categories. However, I want the tertiles to be made based off of the control group. I tried this code, but then when I run the proc freq the table only shows data when casecont_path=1. How do I create tertiles using one group, then apply it to both the cases and the controls?

proc rank data=work.adenovar groups=3;
where casecont_path=1;
var jointyears;
ranks jointyears_tert;
run;

/*categorical joint years*/
data work.adeno1;
set work.data1;
if hash=2 then jointyears_cat=0;
if jointyears_tert=0 then jointyears_cat=1;
if jointyears_tert=1 then jointyears_cat=2;
if jointyears_tert=2 then jointyears_cat=3;
run;

proc freq data=work.adeno1;
tables jointyears_cat*casecont_path/norow nopercent;
run;

How do I sort means by descending order after PROC MEANS

mroungou — Sat, 13 Feb 2021 21:40:56 GMT

Hello, I have been trying to sort my means after computing them with the PROC MEANS function. I used the same code for the a slightly different problem. When I use the proc sort function, it tell me my variable does does exist. Any ideas?

Accept first value when merging datasets

amarikow57 — Sat, 13 Feb 2021 19:54:26 GMT

I am looking at subsets of data from a larger dataset to see which variables are contained in which event. The original data is structured similar to the following:

ID EVENT VAR1 VAR2 VAR3 VAR4 VAR5 ....

1 1 1 2 . . .

1 2 . . 4 0 .

1 3 . . 1 . 7

2 1 0 1 . . .

2 2 . . 3 1 .

3 1 1 1 . . .

3 2 . . 2 1 .

3 3 . . 0 . 6

etc.

After I subset by event using the WEHERE statement I plan to have something like:

Event 1

ID VAR1 VAR2 VAR3 VAR4 VAR5 ....

1 1 2 . . .

2 0 1 . . .

3 1 1 . . .

Event 2

ID VAR1 VAR2 VAR3 VAR4 VAR5 ....

1 . . 4 0 .

2 . . 3 1 .

3 . . 2 1 .

Event 3

ID VAR1 VAR2 VAR3 VAR4 VAR5 ....

1 . . 1 . 7

3 . . 0 . 6

I would then like to (1) delete any column within each subset that does not contain any information, then (2) merge the datasets to where I only have one row per ID, while (3) maintaining the information of the left most dataset if there is information for a variable in both datasets. So merging Event 3 to Event 2, I would want to keep the VAR3 observations from Event 2 and not Event 3. Is there a way to do this? (Note: actual dataset has about 100 variables) I suppose would it be better to right join Event 2 to Event 3 or left join Event 3 to Event 2?

how to configure a directory shortcut to an external directory on windows pc

MaryA_Marion — Wed, 10 Feb 2021 02:08:00 GMT

I need to know how to determine the path for an external directory. SAS Studio does not allow me to do it? Please see two snapshots. Thanks. Mary A. Marion

PROC TABULATE not reading in all data

amarikow57 — Wed, 10 Feb 2021 00:47:40 GMT

I am running into some issues getting PROC TABULATE to correctly count the frequency of my categorical variables. A snippet of the Log file and the output of both the PROC TABULATE (top table) and the PROC FREQ (bottom table of gender) are below. My code is as such:

title 'Table 1. Child Demographics';
*Does not like ATEAM_AUTISM_TYPE --> Assess outside of True/False positives;
PROC TABULATE data = CLEANED.Analytic_Data;
 options fmtsearch = (OUTPUT);
 keyword n / style = [just=R];
 keyword pctn / style = [just=L];
 class ATEAM_AUTISM_YES_NO CHILD_GENDER ATEAM_AUTISM_TYPE ASD_DTEAM_COMORBID_YESNO;  
 classlev CHILD_GENDER ATEAM_AUTISM_TYPE ASD_DTEAM_COMORBID_YESNO/ s = [just=R];
 table (CHILD_GENDER = 'Sex of Child' ATEAM_AUTISM_TYPE = 'Type of Autism' ASD_DTEAM_COMORBID_YESNO = 'Comorbidity Present'),
       (ALL = 'All Data ~nn (%)' ATEAM_AUTISM_YES_NO = 'A Team Autism Diagnosis')*(n ='' * [style = [just=R cellwidth = 75] f = 8.2]
	    											  	      pctn ='' * [style = [just=L cellwidth = 80] f = paren.]) / box = 'Child Variables';
 format ATEAM_AUTISM_YES_NO asd_perc. CHILD_GENDER sex. ATEAM_AUTISM_TYPE $asdtype. ASD_DTEAM_COMORBID_YESNO yesno.;
RUN; *Not stratifying properly;

PROC FREQ data = WORK.Data2019;
 table ATEAM_AUTISM_YES_NO*(CHILD_GENDER ATEAM_AUTISM_TYPE ASD_DTEAM_COMORBID_YESNO);
 options fmtsearch = (OUTPUT);
 format ATEAM_AUTISM_YES_NO asd. CHILD_GENDER sex. ATEAM_AUTISM_TYPE $asdtype. ASD_DTEAM_COMORBID_YESNO yesno.;
run;

For whatever reason, false positive isn't showing up at all. Furthermore, the numbers calculated for overall and true positive don't even match the frequency table. I am unsure where SAS got these values nor why PROC TABULATE would produce different results from PROC FREQ.

I used similar code formatting for continuous variables stratified for Autism diagnosis and got matching results to PROC MEANS. I am not sure why it works well with some and not others. Does anyone have any ideas what could be causing this issue? Thank you in advance.

Identify rows based on two conditions

amarikow57 — Mon, 08 Feb 2021 20:05:55 GMT

I have data of something like this:

ID EVENT SCORE

1 1 3

1 2 3

2 1 7

2 2 7

3 1 8

3 2 6

4 1 .

4 2 5

I care about scores not matching for an ID. That is IDs 3 and 4 would be of interest. Is there a way to view only those IDs keeping in mind that my actual dataset has many more IDs than this?

Thanks in advance.

Collapse ID while keeping the max value of the column

amarikow57 — Sun, 07 Feb 2021 23:30:13 GMT

Note: I am still learning a lot about SAS, so a somewhat detailed response would be incredibly helpful.

I have a fairly large dataset (109 columns) that I would like to merge with another dataset to complete the information. However, this dataset has multiple rows per ID while the one I'd like to merge it to only has one row per ID. I would like to get the long dataset down to one row per ID.

Because of how the long dataset was compiled there is a lot of "missing" information. That is, each ID has a row for different surveys that assessed different questions. See simplified example below:

ID SURVEY 1Q1 1Q2 1Q3 2Q1 2Q2 3Q1 3Q2 3Q3 3Q4 3Q5 4Q1 4Q2 4Q3 4Q4 5Q1 5Q2 5Q3

1 1 1 2 3 . . . . . . . . . . . . . .

1 2 . . . 8 0 . . . . . . . . . . . .

1 3 . . . . . 4 0 1 5 2 . . . . . . .

1 4 . . . . . . . . . . 1 4 2 1 . . .

1 5 . . . . . . . . . . . . . . 1 3 1

2 1 0 3 6 . . . . . . . . . . . . . .

2 2 . . . 7 1 . . . . . . . . . . . .

2 3 . . . . . 5 1 1 5 3 . . . . . . .

2 5 . . . . . . . . . . . . . . 0 2 0

3 1 1 3 3 . . . . . . . . . . . . . .

3 2 . . . 6 0 . . . . . . . . . . . .

3 3 . . . . . 3 1 0 5 1 . . . . . . .

3 4 . . . . . . . . . . 1 4 2 1 . . .

3 5 . . . . . . . . . . . . . . 0 3 1

4 1 1 1 5 . . . . . . . . . . . . . .

4 2 . . . 4 0 . . . . . . . . . . . .

4 3 . . . . . 6 0 1 5 2 . . . . . . .

5 1 0 3 4 . . . . . . . . . . . . . .

5 3 . . . . . 9 0 0 4 1 . . . . . . .

5 4 . . . . . . . . . . 1 4 2 0 . . .

5 5 . . . . . . . . . . . . . . 1 3 1

Essentially I want to collapse the IDs without losing valuable information. So my questions are as followed:

(1) Is there a SAS function that will allow me to keep one observation per ID where the max value is kept? I can get down to one ID with the following function:

DATA OUTPUT.uniqueID;
 update OUTPUT.allID(obs = 1) OUTPUT.allID;
 by AUTISM_ID;
RUN;

However, it seems to only keep the first value, when I'd rather it keep the max.

(2) If not possible, is there a way to repeat the value for the entire ID in an efficient manner? I have tried:

PROC SQL;
 create table OUTPUT.allID as 
 	select *, 
                max(AGE_DIAG_M) as AGE_DIAG_MONTHS,
 		max(AGE_DIAG_Y) as AGE_DIAG_YEARS,
 		max(CHILD_GENDER) as SEX,
 		max(A_TOTAL_ADI_W1) as TOTAL_A,
 		max(B_V_TOTAL_ADI_W1) as TOTAL_B_VERB,
 		max(B_NV_TOTAL_ADI_W1) as TOTAL_B_NONVERB,
 		max(C_TOTAL_ADI_W1) as TOTAL_C,
 		max(D_TOTAL_ADI_W1) as TOTAL_D
 from OUTPUT.age
 group by AUTISM_ID;
QUIT;

Although it works, it seems inefficient considering how many variables I have. Is there a way to create some sort of DO LOOP or MACRO function that will run through all the variables and do it for me?

I appreciate any feedback. Thanks in advance!

issues with code, some data is skipped over when printing

ellpap — Fri, 05 Feb 2021 03:16:14 GMT

hi,

I am writing code and it seems that when I try to print all the rows in my dataline, some of the rows are being skipped over for some reason.

Code:

libname saveit '/folders/myfolders';

data saveit.wtloss;

input ID:$4. firstname: $15. lastname: $15. team: $8. startwt: $3. endwt: $3. loss ;

loss=startwt-endwt;

datalines;

1023 David Shaw red 189 165

1049 Amelia Serrano yellow 145 124

1219 Alan Nance red 210 192

1246 Ravi Sinha yellow 194 177

1078 Ashley McKnight red 127 118

1221 Jim Brown yellow 220 .

1095 Susan Stewart blue 135 127

1157 Rosa Gomez green 155 141

1331 Jason Schock blue 187 172

1067 Kanoko Nagasaka green 135 122

1251 Richard Rose blue 181 166

1333 Li-Hwa Lee green 141 129

1192 Charlene Armstrong yellow 152 139

1352 Bette Long green 156 137

1262 Yao Chen blue 196 180

1087 Kim Sikorski red 148 135

1124 Adrienne Fink green 156 142

1197 Lynne Overby red 138 125

1133 John VanMeter blue 180 167

1036 Becky Redding green 135 123

1057 Margie Vanhoy yellow 146 132

1328 Hisashi Ito red 155 142

1243 Deanna Hicks blue 134 122

1177 Holly Choate red 141 130

1259 Raoul Sanchez green 189 172

1017 Jennifer Brooks blue 138 127

1099 Asha Garg yellow 148 132

1329 Larry Goss yellow 188 174

;

run ;

proc sort data=saveit.wtloss;

by ID;

proc print data=saveit.wtloss ;

run ;

END CODE

and then when it prints, I attached an image of what shows up.

It seems that after 14 rows, the data is cut off.

Thank you so much for the help!

SAS - Epic Systems (Medical EMR) Chronicles Access ?

Greg_Azevedo_KP — Mon, 01 Feb 2021 22:10:54 GMT

re: SAS - Epic Systems (Medical EMR) Chronicles Access ?

I am aware and use SAS Studio with PROC SQL to access the Epic Clarity Data Base.

I do some reporting within the Epic (Cache) Chronicles environment, accessing their INI and Items content.

Is there a way, method, tool to directly use SAS Enterprise or SAS Studio to connect and extract in some fashion

Epic data in Chronicles ? Had to ask, hoping my question is specific enough to answer.

SAS Studio University Edition Tutorials

DavidBrown — Fri, 29 Jan 2021 16:49:58 GMT

Hello

I've been trying to learn SAS for some time now, bouncing around between different SAS books and using their On Demand for Academics, and University Edition. The problem is that the books often assume that you are using the licensed version, so what is depicted in the books rarely actually works in the free versions. The SAS Documentation is so difficult to understand. It appears to be written for people who are experts in SAS. I find the most informative and understandable tutorials and information to come from "non-SAS" sources. Why do they make SAS so difficult to learn? I am about ready to throw in the towel and stick with R and Python.

Dave

F Test

Lilo — Wed, 27 Jan 2021 18:15:08 GMT

Hello,

I am trying to find the appropriate code to run a F test to test a hypothesis but so far no luck

Here's the data:

data reghwk4; 
input X Y;
datalines;
29.7 16.6 
68.4 49.1
120.7 121.7
217.2 219.6
313.5 375.5
419.1 570.8
535.9 648.2
641.5 755.6
;
run;

This is what I have tried so far:

proc ttest data= reghwk4 / h0=0 sides=1;
class X;
var Y;
run;

proc anova data=reghwk4;
class Y X;
model Y=X;
run;

proc reg data= reghwk4;
model y=x;
run;

I'd like to change the name of dataset of xpt files

Shim1222 — Wed, 20 Jan 2021 07:20:42 GMT

I'm using SAS studio. The environment is Windows 10. I would to change the dataset name of an xpt file. Anyone, could you give me the code to rename the dataset?

Thank you!

How can i quckly access the snippet by entering @snippet-abbreviation in SAS 94?

HAHA604 — Fri, 15 Jan 2021 14:15:34 GMT

In Create snippet, they said If I want to be able to quickly access the snippet by entering @snippet-abbreviation in the program editor, enter an abbreviation for the snippet. I can also add a description.

So I save the coding +@ snippet-name in my snippet, and I try to use @ or @ snippet-name and click Tabs or Enter, but they are not show me anything? Did I make some mistake in here, I want to know why and how to add @ snippet-name in my snippet.

thank you,

HAHA604

Problem when trying to declare an array

genemroz — Wed, 13 Jan 2021 00:33:55 GMT

Here's some simple code that exemplifies an issue I'm having:

data;
array grid (3,3) row1-row3 col1-col3;
run;

Here's the error message I receive:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data;

74 array grid (3,3) row1-row3 col1-col3;

ERROR: Too few variables defined for the dimension(s) specified for the array grid.

75 run;

What can possibly be wrong?

Thanks,

Gene

PC SAS Batch Mode vs SAS Studio Background Mode

jvigeant — Mon, 11 Jan 2021 19:43:09 GMT

Hi all -

Trying to gather some information here: our team is planning to move away from developing with desktop PC SAS to SAS Studio on a Linux flavored SAS Server.

One topic that has come up is that SAS Studio (3.6 is what we have) does not run in "true" batch mode. Information I have found is that "background submit" is just a change in nomenclature starting with SAS Studio 3.6.

What I'd like to know is whether there any underlying difference in how PC SAS processes the old traditional "right click and select 'Batch submit with SAS 9.x'" vs submitting a job in background on SAS Studio?

One notable addition: using the SAS %sysprocessmode variable, results from PC SAS shows SAS Batch Mode, while running a background submit in SAS Studio 3.6 resolves to "SAS Workspace Server"

Many thanks!

Setting a maximum value of a variable?

gejoachim99 — Sun, 10 Jan 2021 19:36:09 GMT

I have an age variable and I would like to run an analysis only on 0-35 years of that variable. I want to include people who have an input of 40, for example, but only on the data for 0-35 for that person. I want to include that in some code that I already have, in which I am calculating the duration of smoking over a lifetime. I basically just want to limit it to exposure that happened before age 35. I have variables, hashlage1-4, which represent the last age of different periods of smoking throughout a lifetime. I'm not sure how (or if) I should use this variable, or if there is another way to set a maximum. I hope this makes sense. Thanks.

/*duration*/
data work.adenovar;
set work.adeno1;
if hashtot >= 1 and hashtot < =4 and hashfage1 ^= 99 and hashlage1 ^= 99 then hashdur1 = (hashlage1-hashfage1)+1;
if hashtot >= 2 and hashtot <= 4 and hashfage2 ^= 99 and hashlage1 ^= 99 then hashdur2 = (hashlage2-hashfage2)+1;
if hashtot >= 3 and hashtot <= 4 and hashfage3 ^= 99 and hashlage1 ^= 99 then hashdur3 = (hashlage3-hashfage3)+1;
else if hashtot = 4 and hashfage4 ^= 99 and hashlage4 ^= 99 then hashdur4 = (hashlage4-hashfage4)+1;

/*total duration*/
hashdurtot = sum(of hashdur1-hashdur4);

Some macro functions are not parsed in SAS Studio

NickZhengCHN — Sun, 10 Jan 2021 15:08:29 GMT

Dears:

Some macro functions(e.g: %left() function) are not parsed in SAS Studio, but they are effective in SAS EG. And base SAS of both of them are 9.4_M6.

And I wonder if I missed any global Settings in SAS Studio env?

Please find my code in below.

proc product_status;run;

data test1;
    i=1;
run;

data test2;
    i=2;
run;

data test3;
    i=3;
run;

proc sql ;
    create table t_test as 
    select * from  dictionary.tables where libname='WORK'; 

    select count(*) into:num from t_test where prxmatch('/^test/io',strip(memname));
;quit;

%macro test();
    data all;
        set test1 - test%left(&num.);
    run;
%mend;

%test;

Logistic Regression for Twitter Data Scraping

gerry888 — Thu, 07 Jan 2021 21:50:16 GMT

HI there,

I am trying to do a logistic regression for data i have scraped from a twitter advanced search, but it comes up with error everytime i run it, i believe this is due to the the fact that my all my value types come up as Char (character) and it needs to be Num (numbers) but my variables are

Variables in Creation Order# Variable Type Len Format Informat12345678

Field1	Char	87	$87.	$87.
TwitterHandle	Char	77	$77.	$77.
Username	Char	41	$41.	$41.
DateofTweet	Char	104	$104.	$104.
InResponseTo	Char	10	$10.	$10.
Tweet	Char	12	$12.	$12.
Comments	Char	1	$1.	$1.
Retweets	Char	1	$1.	$1.

how should i go about changing this or am i not using an appropriate statistical technique for this type of data

Counting the occurrence of a variable across columns per observation

kirkends — Wed, 06 Jan 2021 21:04:11 GMT

I am new to SAS so forgive me if this is basic. I have a data set with 150,000+ rows, each with a unique ID, and 250 columns, all columns must be retained. However for this specific inquiry, I am only interested in 13 columns; each column is a variable with a valueof "0" "1" "7" or "9". I would like to make a new column that counts the number of times a "1" populates a column cell across the row/observation.

For example:

count of "1"

ID Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8................WANT

152 1 0 1 0 1 9 1 7 4

153 0 0 7 7 1 9 0 9 1

154 1 9 1 9 9 0 0 9 2

155 7 1 9 1 9 1 1 9 4

156 9 0 0 9 0 0 0 0 0

157 9 7 9 0 7 1 0 0 1

I have tried solutions from other forums with similar problems haven't found anything that has worked for me. I appreciate the help!!

put statement

anming — Wed, 30 Dec 2020 21:20:35 GMT

data perm_student;
input name$ age 2.;
cards; 
afred 14
alice 13
barbara 13
carol 14
;
run;

data student;
set perm_student;
put name $15. @5 age 2.;
run;

it looks that 'put' does not work. The student dataset is only a simple copy of perm_student. could you help what is wrong?

Problem in Creating Libname ECST142

sascoin — Tue, 29 Dec 2020 23:09:12 GMT

Hi Friends

I am using SAS Studio and having problem in creating Library for ECST142. Files are attached.

I have already gone through all the ECST142 related queries in this forum but still struggling. I have also completed step by step instruction by SAS manual but still in vain.

I believe the issue must be in "format" of ECST142 and I have tried dozens of combination for FILEPATH like.....

I lost the whole day banging my head in this stuff.........no clue. Please someone can help?

Thanks

homefolder=\ECST142\data;

C:\Users\RAO\Desktop\ECST142;


C:\Users\RAO\Desktop\ECST142\data;

Desktop\ECST142\data;

Not recognizing first level in categorical variable during logistic regression

gejoachim99 — Tue, 29 Dec 2020 18:18:34 GMT

I am doing logistic regression using all categorical variables. When I create a 2x2 table of the outcome (casehyst_path) and the exposure (jointyears_cat), each level of jointyears_cat (0, 1, 2 and 3) all show up. But when I run the logistic regression, it ignores 0, and uses 1 as the reference, even though I specified ref=first. Here is my code, and I've attached screenshots of my results. Any help is appreciated! Thanks.

data work.adeno1;
set work.adenovar;
if jointyears = 0 or hash = 2 then jointyears_cat = "0";
if 0 LT jointyears LE 2 then jointyears_cat = "1";
if 2 LT jointyears LE 5 then jointyears_cat = "2";
else if jointyears GT 5 then jointyears_cat = "3";

data work.adenovar;
set work.adeno1;
if 20 LE refage LE 34 then refagecat = "0";
if 35 LE refage LE 39 then refagecat = "1";
if 40 LE refage LE 44 then refagecat = "2";
if 45 LE refage LE 49 then refagecat = "3";
if 50 LE refage LE 54 then refagecat = "4";
else if 55 LE refage LE 59 then refagecat = "5";

if 36 LE hashlage1 LE 60 then before35 = "0";
else if 3 LE hashlage1 LE 35 then before35 = "1";
if 36 LE hashlage2 LE 60 then before35 = "0";
else if 3 LE hashlage2 LE 35 then before35 = "1";
if 36 LE hashlage3 LE 60 then before35 = "0";
else if 3 LE hashlage3 LE 35 then before35 = "1";
if 36 LE hashlage4 LE 60 then before35 = "0";
else if 3 LE hashlage4 LE 35 then before35 = "1";

proc freq data = work.adenovar;
where before35 = "1";
tables jointyears_cat*casehyst_path / norow nopercent;
run;

title "hysterectomy controls age";
proc logistic data = adenovar descending;
where before35 = "1";
class jointyears_cat refagecat / param = ref ref = first;
model casehyst_path = jointyears_cat refagecat;
run;

How to set default value in SAS Custom Task for SAS Server Path

djrisks — Mon, 28 Dec 2020 20:09:08 GMT

Hi,

I'm using the SASServerPath to read in a file. By default I would like the value to be blank, or something that I can control.

Currently when I use this:

%let file = ${fileSelector.fullPath};

I am getting this value below in the GUI by default. However, I know if someone else uses the task, the value would be different. How can I control it please? I would like to be able to select a SAS dataset, or keep the value blank.

C:\Users\kharris\program.sas7bdat

This is the code I am using.

<Option name="fileSelector" inputType="sasserverpath" defaultFileName="pq1"
pathType="file" defaultExtension="sas7bdat">An example of a SAS Server Path control.
This example allows the user to select a SAS program file.</Option>

Many thanks,

Kriss Harris

converting pdf file to sas table in sas studio

kate-1mr — Fri, 25 Dec 2020 19:28:36 GMT

Hello everybody 🙂!

Please help me to solve my problem. I want to convert pdf to sas table.

How i can do this? Can I convert pdf to sas table direcly in my sas stydio?

Thanks a lot!!

SAS Custom Task - Obtain fullPath

djrisks — Wed, 23 Dec 2020 19:37:11 GMT

Hello,

I am using the SAS Server Path to read in a SAS dataset, and I would only like to obtain the full path of the dataset location.

In the return value from the SAS Server Path, it shows me the path, name and fullPath.

That is, when I use this code: %let file = $fileSelector.

This code is shown:

%let file = {path=C:\Output,
name=pq1.sas7bdat,
fullPath=C:\Output\pq1.sas7bdat};

I only would like to obtain the full path result, without having to subsequently use SUBSTR functions to obtain the value in fullPath. Do you know how I can achieve this please?

Below is some of the code that I used in my custom task:

Many thanks,

Kriss Harris

limiting logistic regression to one group

gejoachim99 — Tue, 22 Dec 2020 18:04:52 GMT

I'm working with a dataset that has two control groups for reasons that I won't get into. I'm trying to do logistic regression on each of those separately - so, cases vs control group 1, then cases vs control group 2. What command do I use within my proc logistic to limit it to one group? Thanks!

free practice question

anming — Sun, 20 Dec 2020 23:15:20 GMT

this is a useful website providing some exercises: examtopics.com

length or format of a character variable in a data step

anming — Sun, 13 Dec 2020 23:13:31 GMT

for a character variable, what is the difference between a length statement and a format statement, such as,

Length course $8;

Format course $8.;

proc export file type

anming — Sat, 12 Dec 2020 19:56:11 GMT

when we use proc export to export a as table to a certain file do we have to specify the file type?

such as;

proc export data=score.score_data (where=(gender='f'))
outfile='/folders/myfolders/Femalelist2.csv'
dbms=csv
replace;

if we remove .csv from the output file, the file can still open in excel or notepad.

this is similar to a dlm file,

proc export data=score.score_data
outfile="/folders/myfolders/sd.dat"
dbms=dlm
replace;
delimiter='&';
run;

you can remove .dat and open the output sd file with notepad.

proc export data=score.score_data
outfile='/folders/myfolders/sd_excel.xls'
dbms=XLSX replace;
sheet='data';
run;

for xlsx, it does not matter if you add .xls. the output is an excel file.

My SAS studio stopped working

kate-1mr — Fri, 11 Dec 2020 22:43:53 GMT

Hi!

Sorry if my problem is minor, but i can't solve it. I am a new user of SAS studio and Programming. Today I worked in my SAS studio and I thought I made a mistake - I try to open the Excel file as a text viewer. After that, my SAS studio stopped working and Google gave an error: RESULT_CODE_HUG.

I tried to follow the instructions to remove the error - I deleted cookies, restarted Google and computer, but unfortunately my SAS studio did not work.

Please tell me how I can solve my problem.

Thank you.

How do I transfer my snippets from SAS Studio in SAS University Edition to SAS OnDemand for Acad.?

tonybesas — Fri, 11 Dec 2020 12:04:30 GMT

Dear all

I have a useful collection of snippets under the 'My Snippets' menu in SAS Studio for SAS University Edition that I compiled over time. Since SAS University Edition will be discontinued next year, I'm beginning to use SAS onDemand for Academics, and I'd like to be able to access my existing snippets in SAS onDemand.

Would you know of a way to transfer those snippets from the SAS Studio in SAS University Edition to the SAS Studio in SAS onDemand?

Thank you ahead

Tony

Uninitialized variable

gejoachim99 — Mon, 07 Dec 2020 22:01:31 GMT

I am using an existing dataset to create a bunch of new variables, all to make one final variable. I have that final variable in a continuous form (jointyears), and I want to make it categorical (jointyears_cat). I've used if/then statements to do so. However, the log is telling me when I run the if/then statements, that the categorical variable, jointyears, is uninitialized, even though I created it immediately before and included a data and a set statement. I also ran a proc contents for work.adenovar and work.adeno1, and in each the variables that I need/are coding with are all present. Here is my code/log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 /*duration*/

74 data work.adenovar;

75 set work.adeno1;

76 if hashtot >= 1 and hashtot < =4 and hashfage1 ^= 99 and hashlage1 ^= 99 then hashdur1 = (hashlage1-hashfage1)+1;

77 if hashtot >= 2 and hashtot <= 4 and hashfage2 ^= 99 and hashlage1 ^= 99 then hashdur2 = (hashlage2-hashfage2)+1;

78 if hashtot >= 3 and hashtot <= 4 and hashfage3 ^= 99 and hashlage1 ^= 99 then hashdur3 = (hashlage3-hashfage3)+1;

79 else if hashtot = 4 and hashfage4 ^= 99 and hashlage4 ^= 99 then hashdur4 = (hashlage4-hashfage4)+1;

81 /*total duration*/

82 hashdurtot = sum(of hashdur1-hashdur4);

84 /*convert all times to days*/

85 if hashnumx1 = 1 then hashnumx1_day = "1";

86 if hashnumx1 = 2 then hashnumx1_day = "7";

87 if hashnumx1 = 3 then hashnumx1_day = "30";

88 if hashnumx1 = 4 then hashnumx1_day = "365.25";

89 if hashnumx1 = 5 then hashnumx1_day = "1";

90 else if 8 > hashnumx1 > 9 then hashnumx1_day = ".";

91 if hashnumx2 = 1 then hashnumx2_day = "1";

92 if hashnumx2 = 2 then hashnumx2_day = "7";

93 if hashnumx2 = 3 then hashnumx2_day = "30";

94 if hashnumx2 = 4 then hashnumx2_day = "365.25";

95 if hashnumx2 = 5 then hashnumx2_day = "1";

96 else if 8 > hashnumx2 > 9 then hashnumx2_day = ".";

97 if hashnumx3 = 1 then hashnumx3_day = "1";

98 if hashnumx3 = 2 then hashnumx3_day = "7";

99 if hashnumx3 = 3 then hashnumx3_day = "30";

100 if hashnumx3 = 4 then hashnumx3_day = "365.25";

101 if hashnumx3 = 5 then hashnumx3_day = "1";

102 else if 8 > hashnumx3 > 9 then hashnumx3_day = ".";

103 if hashnumx4 = 1 then hashnumx4_day = "1";

104 if hashnumx4 = 2 then hashnumx4_day = "7";

105 if hashnumx4 = 3 then hashnumx4_day = "30";

106 if hashnumx4 = 4 then hashnumx4_day = "365.25";

107 if hashnumx4 = 5 then hashnumx4_day = "1";

108 else if 8 > hashnumx4 > 9 then hashnumx4_day = ".";

109

110 /*inhalations/day calculation*/

111 /*1ep*/ if hashtot = 1 then inhl_day = ((hashinhl1*hashnum1)/hashnumx1_day);

112 /*2ep*/ if hashtot = 2 then inhl_day = ((hashinhl1*hashnum1)/hashnumx1_day) + ((hashinhl2*hashnum2)/hashnumx2_day);

113 /*3ep*/ if hashtot = 3 then inhl_day = ((hashinhl1*hashnum1)/hashnumx1_day) + ((hashinhl2*hashnum2)/hashnumx2_day) +

113 ! ((hashinhl3*hashnum3)/hashnumx3_day);

114 /*4ep*/ if hashtot = 4 then inhl_day = ((hashinhl1*hashnum1)/hashnumx1_day) + ((hashinhl2*hashnum2)/hashnumx2_day) +

114 ! ((hashinhl3*hashnum3)/hashnumx3_day) + ((hashinhl4*hashnum4)/hashnumx4_day);

115 else if 98 > hashtot > 99 then inhl_day = ".";

116

117 /*inhalations/day to joints/day*/

118 joints_day = (inhl_day / 12);

119

120 /*joint years calculation*/

121 jointyears = joints_day * hashdurtot;

122 run;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).

111:62 112:62 112:101 113:62 113:101 113:140 114:62 114:101 114:140 114:179 115:43

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

403 at 82:14 4 at 111:61 404 at 118:24 407 at 121:25

NOTE: There were 989 observations read from the data set WORK.ADENO1.

NOTE: The data set WORK.ADENOVAR has 989 observations and 2961 variables.

NOTE: DATA statement used (Total process time):

real time 0.07 seconds

cpu time 0.07 seconds

123

124 data work.adenovar;

125 set work.adeno1;

126 if jointyears = 0 then jointyears_cat = "0";

127 if 0 > jointyears >= 2 then jointyears_cat = "1";

128 if 2 > jointyears >= 5 then jointyears_cat = "2";

129 else if jointyears > 5 then jointyears_cat = "3";

130 run;

NOTE: Variable jointyears is uninitialized.

NOTE: There were 989 observations read from the data set WORK.ADENO1.

NOTE: The data set WORK.ADENOVAR has 989 observations and 2951 variables.

NOTE: DATA statement used (Total process time):

real time 0.06 seconds

cpu time 0.06 seconds

131

132 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

144

Please help!! Thank you.

YRDIF function not working for some observations

cris17 — Thu, 10 Dec 2020 15:11:28 GMT

Hi SAS communities,

I match merged 4 data sets into one. There should only be 1 observation per person, which includes the most recent visit. One data set had a Birth Date variable and another data set had a Visit Date variable. After merging all 4 I then had to create a new variable that shows what age the person was between Birth date and Visit Date. Below is my code and I think I did the code correctly, but in the log, it shows that 2 out of the 573 are missing data. I checked the data sets and they show both the Birth date and Visit date. It could possibly be the way I also made the 4 data sets, but want to know ifs a simple coding mistake. Below is my code and a screenshot of the partial log.

Let me know if you need more information

Thank you.

SAS Base programming 1 Lesson 3

anming — Tue, 01 Dec 2020 23:09:37 GMT

Type	Frequency	Percent	Cumulative Frequency	Cumulative Percent
NM	63	46.67	63	46.67
NP	51	37.78	114	84.44
NPRE	1	0.74	115	85.19
NS	10	7.41	125	92.59
PRE	3	2.22	128	94.81
PRESERVE	4	2.96	132	97.78
RIVERWAYS	1	0.74	133	98.52
RVR	2	1.48	135	100.00

For level 2 practice of lesson 3, I generated the table above by proc freq. The answer is that NPRE, PRESERVE, and RIVERWAYS are invalid values for Type. I do not understand why. Has anyone worked on the relevant codes?

SAS programming 1 data package

anming — Tue, 01 Dec 2020 03:41:12 GMT

There are only 13 datasets in the data package of SAS programming 1 (pg1V2).

Anyone can provide the full datasets? I can not see any .sas7bdat. There are no storm_summary, eu_occ, np_summary, np_species used for courses. Thanks!

SAS Programming 1 Lesson 5: IDGROUP query

Siroo — Sun, 29 Nov 2020 05:24:13 GMT

Hi all,

I have question pertaining to the challenger question in SAS programming 1 Lesson 5 - Analyzing and Reporting on Data.

Image below shows the solution to the "Challenger" practice of Topic "Creating Summary Reports and Data".

My question:

Why didn't the proc means step creating the output of top 3 parks grouped by REGION and YEARS?

The answer for 188594 is the third highest number of park visitors in Alaska region in the month of JUNE of year 2010.

If I were to sum the total of visitors by YEARS and REGION, what would the code look like?

Regards,

Siroo

Calculating counts and percentages with conditions

ak2011 — Sat, 28 Nov 2020 04:57:14 GMT

Hi,

Could someone help me with the code to solve this problem?

From data oc below, I would like to select the industry code(indscode) with the following conditions:

(1) In which at least 50% of the jobs are exposed to agent a(0=unexposed, 1=exposed).[I want all percentages to be displayed and from there I will select the >=50%].

(2) Couting number of subjects( lung cases(case) and controls(cont) for the selected indscode.

I used proc SQL, expecting the indscode variable to be displayed on the table results, but it didn't.

Coding help is needed to have the indscode count and % displayed on the table,please.

Please find my code and results below:

Thanks in advance.

ak.

data oc;
input id$ 1-5 job 6-7 a 8-9 b 10-11 indscode 12-16 lung$ 17-21;
datalines;
OS1 3 1 0 6198 case
OS2 2 1 1 6191 cont
OS3 3 1 0 6191 case
OS4 3 0 0 6198 cont
OS5 3 1 0 6191 case
OS6 3 1 0 6191 cont
OS6 4 1 1 6198 case
OS7 4 1 1 6191 case
OS8 1 1 1 6191 cont
OS9 1 0 0 6198 cont
OS10 1 1 1 6191 cont
OS11 3 1 1 4153 case
OS12 1 1 1 6191 case
OS13 3 1 1 8563 case
OS14 1 1 1 6191 case
OS14 2 0 0 6191 cont
OS14 5 1 1 6191 cont
OS15 1 1 1 4153 cont
OS16 1 1 0 8563 case
OS17 4 1 1 6191 case
OS17 2 1 0 6191 case
OS17 3 1 0 6191 cont
OS20 3 1 1 4153 cont
;

proc sql;
create table want as
select job, count(job)/(select count(*) from oc) as pct format=percent.
from oc where a=1 /*a=0 is unexposed to agent a; 1= exposed to agent a*/
group by indscode;
quit;

proc print data=want;
run;

Obs job pct
1 3 13%
2 3 13%
3 1 13%
4 5 57%
5 1 57%
6 3 57%
7 1 57%
8 3 57%
9 1 57%
10 4 57%
11 2 57%
12 4 57%
13 3 57%
14 2 57%
15 3 57%
16 1 57%
17 4 9%
18 3 9%
19 3 9%
20 1 9%

Using SAS studio trying to delete observations

ayosas — Fri, 27 Nov 2020 17:07:51 GMT

Hello

I am working with a large dataset and trying to subset the data to only keep certain variables, I am only looking at a certain age range for the data too so I want to delete the ages that I do not need. My code for this isn't working and I'm not sure why.

data nsch1718;
if  2=>SC_AGE_YEARS>5 then delete;
keep ACEct_1718 PrntNativity_1718 TalkAbout_1718 WrkToSolve_1718 strengths_1718 hopeful_1718 CtFamRes_1718 FamResilience_1718 
confident_1718 ACEdivorce_1718 ACEdeath_1718 ACEjail_1718 ACEdomviol_1718 ACEneighviol_1718 ACEmhealth_1718 ACEdrug_1718 ACEdiscrim_1718
sex_1718 SC_AGE_YEARS SC_HISPANIC_R SC_RACE_R raceAsia_1718 povSCHIP_1718 FPL_I1 AdultEduc_1718 FamCount_1718 RecogLetter_1718 
CountTo_1718 CONFIDENT WorkToFin_1718 HurtSad_1718 WriteName_1718;
format CONFIDENT confidentf. prntnativity_1718 prntnativityf. confident_1718 confidentf.;
set mc759.nsch1718combined_drc;
run;

Can't copy paste from Mac into SAS Studio

paulgs — Wed, 25 Nov 2020 22:31:00 GMT

Hi,

I'm new to SAS but trying to learn using SAS Studio (running in Chrome). I use a Mac and when I try to paste text from the system clipboard (e.g. code I find online somewhere) the moment I hit the command key (command-V) the SAS Studio pop-up menu appears. I don't think I've done anything weird with my keyboard settings that should cause that behaviour.

Any ideas? I can't figure out why I can't paste from the Mac side to the SAS browser side.

Thanks,

Paul

model market share with proc logistic?

magalineven — Mon, 23 Nov 2020 16:43:12 GMT

We need to model the market share of a certain brand in a certain store at a given time. According to what we have learned, logistic models are often used when the dependent variable is marketshare as the natural maximum is 100%. However, when we use proc logistic in sas, we get impossible outputs. The reason for this might be the fact that in order to use proc logistic, you need an event and a non-event.

Do you have any idea which sas procedure to use instead? Thanks in advance!

How to explicitly set a port for SAS Studio 3.8 in Windows 10 ?

zpc — Sat, 21 Nov 2020 04:00:23 GMT

There is already a question regarding this topic (https://communities.sas.com/t5/SAS-Communities-Library/How-to-explicitly-set-a-port-for-SAS-Studio-4-x/ta-p/601708) but it appears to be geared towards the VM/Unix version.

I am looking to set the default port for SAS Studio Single User running on Windows 10, so every time I open SAS Studio, it uses the same port on localhost.

Thx

Census Bureau CPS data w Supplement via census.gov or IPUMS?

ButteryBatman — Thu, 19 Nov 2020 03:27:34 GMT

Hi All,

I know nothing of programming and working with data like this. The US Census Bureau website has .xlsx tables that relate family income to voter turnout and reasons for not voting, using CPS data from Nov 2018, and I guess preceding months, plus their Voting and Registration Supplement. There are what looks like .dat purely numerical fixed width documents of this data on the Census website, and I guess there may be various renditions of the same info on cps.ipums.org. How may this information be viewed in a similar format to the .xlsx tables for a single state? Is this practical on SAS Studio? Thank You 🙂