New SAS User topics

About base exam

Jianan_luna — Tue, 11 Aug 2020 20:17:04 GMT

I am planning to take Programming Associate/Base Programming Specialist. I am confused whether INFILE/ARRAY/INPUT statement included in the exam. I check the exam guide, there is nothing related it. But when I do the practice questions, there are some related it. Thanks so much.

SAS Sudio Sends Data to SAS?

jmpalumbNCSU — Mon, 10 Aug 2020 20:37:19 GMT

Hello all, I'm learning to use SAS Studio as it's the coding environment the training modules were taught in and I'm not the most computer literate person, so to make things easier on myself I've been using it alone. My coworker who requested that I take the training says that I cannot use the SAS Studio environment for our data as it takes the form of patient records and is therefore shared with SAS when I use Studio. Is this true? I'd like to continue using it if I can since I'm much less familiar with Enterprise or 9.4 which are also on this PC. Please advise.

Question about means ins SAS 9.4

Annie_Fréchette — Mon, 10 Aug 2020 18:25:48 GMT

Hi! I'm tryin to calculate a mean LS for a lac (see the print screen) Not every cow have the same number of test in their lactation. How can I code SAS for this: Sum all the LS ne . then divide it by the number of LS ne . And put the result in a new variable called LSmean.

Thanks you very much!!

Is my output correct

Kimberly_2020 — Mon, 10 Aug 2020 16:28:29 GMT

"Create a frequency table of current gender and sexual orientation for patients between the age of 18 - 50 years" was my instructions...I want to know if my output is correct. Please see attachment.

What does it mean if SAS says variable type is not on file?

Kimberly_2020 — Mon, 10 Aug 2020 15:52:31 GMT

Hello there,

SAS keeps saying that the variable type is not on file....What does this mean? WHen I did a one way frequency table without the where statement it ran...But when I made this edit, it didn't.

Code:
proc freq data=WORK.SYPHILIS;
	tables genderB genderC sex_o RACE age / plots=(freqplot cumfreqplot);
	where Type in ("genderB", "genderC", "sex_o", "race") and 18<=age<=50;
run;

Log: 

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 SYMBOLGEN:  Macro variable _SASWSTEMP_ resolves to /home/u49152646/.sasstudio/.images/db1b9e49-6774-45a2-9899-069be7ad3673
 SYMBOLGEN:  Some characters in the above value which were subject to macro quoting have been unquoted for printing.
 SYMBOLGEN:  Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME;
 72         
 73         /*
 74          *
 75          * Task code generated by SAS Studio 3.8
 76          *
 77          * Generated on '8/10/20, 8:32 AM'
 78          * Generated by 'u49152646'
 79          * Generated on server 'ODAWS03-USW2.ODA.SAS.COM'
 80          * Generated on SAS platform 'Linux LIN X64 3.10.0-1062.9.1.el7.x86_64'
 81          * Generated on SAS version '9.04.01M6P11072018'
 82          * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)
 82       ! Chrome/84.0.4147.105 Safari/537.36'
 83          * Generated on web client
 83       ! 'https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-07%253A00&ticket=ST-27624-sinmcsizLgE19kH9QBkl-cas'
 84          *
 85          */
 86         
 87         proc freq data=WORK.SYPHILIS;
 88         tables genderB genderC sex_o RACE age / plots=(freqplot cumfreqplot);
 89         where Type in ("genderB", "genderC", "sex_o", "race") and 18<=age<=50;
 ERROR: Variable Type is not on file WORK.SYPHILIS.

SAS DAte conversion to numeric

jorquec — Mon, 10 Aug 2020 15:51:42 GMT

Hi all,

I am struggling in some date conversion.

Is there a way of conversion for this subtraction as Tenure_length_months results in a numeric number in the same format as Teradata output. Despite this code works on SAS, the final result for column Tenure_lenght_month does not manky any sense on my model with SAS results.

When I run on Teradata column Tenure_length_months give me numbers like 125,31,48 which is absolutely fine however SAS gives me results like 6278800, 6252333 that could be right on a SAS approach but is not what I would like to see as an output for this column.

Example:

Considering today as 2020-04-31 I would have a customer that is with us in 10 months

Teradata results

ten_date

Start_Month_End

tenure_mth

Tenure_length_months

Tenure_Months

02/07/2019

31/07/2019

201,907.00

10.98

Considering today as 2020-04-31 I would have a customer that is with us the same 10 months but SAs calculate in another way so gives me results like 627880.

SAS results

ten_date

Start_Month_End

tenure_mth

Tenure_length_months

Tenure_Months

02JUL2019 31JUL2019 201907 627880.40 627880

How I should write to see the same results as Teradata please?

proc delete
   lib= smm  data=payg_base_1;
run;

proc sql;                                                        
connect to teradata                                                     
(user=&td_usr. password=&td_pass. server = 'edwprod' database = 'insights_consumer' mode = teradata);                                                         
EXECUTE (
                                                          
CREATE SET TABLE sasmod_manager.payg_base_1 AS                                                       
(                                                         

select  a.*,

bb.Effective_From_Dt as ten_date ,
ADD_MONTHS(ten_date - EXTRACT(DAY FROM ten_date) + 1, 1) - 1 AS Start_Month_End,
cast(trim(extract (year from  ten_date ))  || trim(extract (month from  ten_date  ) (format '99')) as float) as tenure_mth,
((  '2020-04-31' - ten_date)/ 30.42) AS Tenure_length_months,

Cast(( Tenure_length_months ) AS INT)  AS Tenure_Months

from

(  select       subscr_id,  
  subscr_num,
Tariff_Offering_Id,    
 Device_Type_Id   ,
sales_channel_id

/*from NUC_PL_USER_VIEW.SUBSCR_TRACK WHERE DATE    between effective_from_dt  and  effective_to_dt */
from NUC_PL_USER_VIEW.SUBSCR_TRACK WHERE 1200431  between effective_from_dt  and  effective_to_dt 
AND PREPYD_IND = 'Y'  
AND pandl_segment_id = 1 
AND mobile_broadband_ind = 'N' 
AND TELEMATIC_IND='N' 
AND (  Internal_BASE_IND=1 ) 
 )  a  

         left join
( select     subscr_id,    Effective_From_Dt    from     NUC_PL_USER_VIEW.SUBSCR_TRACK 
   WHERE    
   PREPYD_IND = 'Y'    AND pandl_segment_id = 1   AND mobile_broadband_ind = 'N'   AND TELEMATIC_IND='N'  AND Internal_BASE_IND=1    /* START DATE*/
  qualify rank () over (  partition by  subscr_id    order by  Effective_From_Dt asc )  =1     )  bb
   on a.Subscr_id=bb.Subscr_id 
 

) WITH DATA PRIMARY INDEX(subscr_id);)BY TERADATA;                      
quit;

how do repeat the ID for every patient 11 times

sasgyro — Mon, 10 Aug 2020 01:32:29 GMT

how do repeat the ID for every patient so that they have 11 instances they appear in the dataset. Some patients appear 3 4 7 or 11 times but I want everyone to be featured 11 times.

Struggling with Missingness in a data set

klongway — Sun, 09 Aug 2020 02:16:50 GMT

Hello,

I am running a logistic regression with four predictor variables, 1 outcome variable, and 6 covariates. My N is around 2000 participants.

For one of my four predictor variables, there are around 1000 people missing the question. The question asked was very sensitive and it is normal for people to skip it on surveys per other papers. The situation is similar for one of my covariates, where a question on a sensitive topic is also skipped by a substantial number of people.

Right now when I run it, my data set ends up cut in half. My major professor will not let me do multiple imputations and wants me to do Full Information Maximum Likelihood to account for the missing data.

Does anyone have any advice on if I can do this in SAS?

Thank you!

several questions: options control, format control, ods procedure tables output data sets

emaguin — Sat, 08 Aug 2020 20:15:20 GMT

this is a stored-up list.

1) Somewhere, i've seen that it is possible get rid of that centered output and have left justified output in the results viewer window. What was showed was the specific command that went in the syntax file. Stumbling around, i found a directory or file called options. I'm looking for a permanent fix. Do modify the options file? What option name and how done?

2) Today, i wanted to write out a text data file. In spss i'd say

write outfile='path string' var list (optional Fortran-type format specification). Nice and simple and highly controllable. I see in Cody's book how to export an excel file. Mplus, the receiving program, takes only text files. In SAS, how would i write out a text data file and, if desired, control variable formats and new lines. For example: recid y1-y50 (f4.0,2x,25f3.0/6x,25f3.0).

3) I want to export a set of frequency tables to a dataset. Based on Cody's book I used this

52 ods output bprawfreqs=OneWayFreq;
53 proc freq data=pbitems; tables dpb4-dpb16; run;

WARNING: Output 'bprawfreqs' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options
are used to produce the requested output object. For example, verify that the
NOPRINT option is not used.

So. i believe the object name is correct because i did and ODS Trace command. I assume that the file (bprawfreqs is just a sas data set and it's location is controlled by the active lib statement (Correct or not?)

I read the documentation for proc freq and see that there is an "out' subcommand for a table statement. However, as i understand the documentation what is written out to the named dataset is only the last named frequency/crosstab table in the table subcommand. That's useless and it's hard to believe that is true.

4) I want to come back to the output export problem. Recently i was running GEE models Working through the iterations of IV variable combinations, i had a list of 26 or 27 and I had to run each combination with two different DVs. The PIs requested that i summarize the results and what they wanted to see the coefficients and their significance values. (I want to say something to head off Proc Report: The coefficients and their significance are looked at and discussed, decisions are made, and the syntax and mht files could be deleted because they served their function). In spss i could say OMS "analysis type" select if table="coefficients" ahead of the first GEE model and OMS End after the last one. In Cody i read that i can specify ods select >object< (persist); and that will do what i want. True?

That does it for now. Thanks.

Creating a frequency table using age

Kimberly_2020 — Sat, 08 Aug 2020 18:57:06 GMT

Hello there,

I am trying to create a frequency table for gender and sexual orientation between the ages of 18-50. Where am I going wrong.

Code:
proc freq data=WORK.SYPHILIS;
	tables genderC genderB sex_o age RACE / plots=(freqplot cumfreqplot);
	where  Type in ("genderC", "genderB", "sex_o", age "18-50");
run;

Log:

87         proc freq data=WORK.SYPHILIS;
 88         tables genderC genderB sex_o age RACE / plots=(freqplot cumfreqplot);
 89         where  Type in ("genderC", "genderB", "sex_o", age "18-50");
                                                            ___
                                                            22
                                                            202
 ERROR: Syntax error while parsing WHERE clause.
 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ).  
 ERROR 202-322: The option or parameter is not recognized and will be ignored.
 90         run;

how to chain datasets with same name and variables structure

PierreYvesILY — Fri, 07 Aug 2020 10:33:25 GMT

Hello SAS experts,

I have a list of datasets with the same name and variables structure, and I want to add them all in a single one.

this doesn't work:

data vzk_2020;

do i=1 to 8;

set vzk_2020_i;

end;

run;

what's the correct way?

regards,

proc sql to copy records from one table to another

Naveen1111 — Sat, 08 Aug 2020 13:07:21 GMT

Hi All,

i have one question. There are two datasets A and B, want to move/copy two rows from table B to A. Could someone help me which syntax I should use IN proc SQL.

Regards

Navin

How do I plot individual variables over time

cdunlea — Thu, 06 Aug 2020 19:19:47 GMT

Hello All, I am attempting to plot the means of 8 individual variables in my dataset over time. I am using SAS university so proc gplot is not an option.

What I want is a way to take my proc means and plot it. So far nothing has worked. Here is the proc means I am running

proc means data=wide_merged_file_sans_pooled mean stddev median min max;
var gmcsf_fuvisit_f0 gmcsf_fuvisit_f1 gmcsf_fuvisit_f2 gmcsf_fuvisit_f3 gmcsf_fuvisit_f5
gmcsf_fuvisit_f6 gmcsf_fuvisit_f7 gmcsf_fuvisit_f8; run;

I want to take the results of this proc means and plot it with an x-axis of "fuvisit"(each variable is a follow up visit) and a y axis of "Mean" along with standard deviation.

Any advice is appreciated.

Saving files in SAS University Edition

Tim_sas_ — Thu, 06 Aug 2020 19:09:44 GMT

Hello,

I know it is a very basic question but my search did not yield satisfactory results so far.

I want to save data files permanently from my work library. Do I have to export them into myfolders or is there a more convenient way to do this in SAS University edition?

Many thanks for any help!

Tim

Remove decimal from variable

marleeakerson — Thu, 06 Aug 2020 18:17:00 GMT

Hello,

How do i remove a decimal from a variable?

For example - go from:

3.4

66.5

z4.1

to:

665

z41

Is this possible using the cat or catx function?

Creating three new variables in a panel ?

AntonioFinn — Thu, 06 Aug 2020 17:52:36 GMT

I have a panel dataset which includes weekly data for several brands across four years (250 observations per brand). I appreciate if you help me with doing the following three things (I apologize in advance if I shouldn't ask multiple questions under one topic). Also sorry I cannot share a sample of my data due to NDA.

1. My dataset includes a column named "brand_name". I want to create a new column ("id") which uniquely identifies each brand. So it should take on the same value for all the 250 rows associated with each brand.

2. I need a new variable which assigns a number (from 1 to 250) to each observation for each brand. My dataset includes two columns "Year0" and "week". For each brand, my data starts from the 6th week of 2014 up until 52nd week of 2014. Then, from week 0 of 2015 to week 52 of 2015, and so on. In other words, when "Year0" is 2014, "week" starts from 6 all the way to 52. Then for the next row, in which "Year0" is 2015, "week" is 0 (so the variable week starts over with a change in Year0). The new variable should assign 1 whenever Year0 is 2014 and week is 6, and continue this until the last observation, for which it should be 250.

3. I have several variables which are in percentage (they have been calculated using avg() format=percent7.2 ). I need to convert these to numbers. so for example 91.70% should be converted to 0.917.

Thanks so much in advance for your help.

Extract first and last name from character variable

bkq32 — Thu, 06 Aug 2020 01:51:29 GMT

I have a variable that has a first name and last name embedded in it. How can I extract the name into a new variable, assuming it always comes after "Requestor: " and before "Reason:"?

data have; 
 length note $200.;
 input note $ ;
cards;
This_is_the_Requestor:_Mary_L._Santiago_Reason:
Additional_text_This_is_the_Requestor:_John_Doe_Reason:_stuff
This_is_the_Requestor:_Tyler_Nguyen_Reason:_text_text
;
run;

data have;
 set have;
 note = tranwrd ( note, "_", " " );
run;

How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 18:00:57 GMT

How do I import a csv file into the library or is it possible?

Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 18:24:46 GMT

Hello there! i am a new SAS user and I am trying to import a CSV file...I have already created a folder in SAS where the csv file is..The problem is that when I press run, it keeps saying physical file does not exist...The folder name is rapid_syphilis and the csv in it is named sample_8.3.2020...

Here is my code:

/*import a CSV file*/

%let path=S:\CSV Import;

options validvarname=v7;

proc import datafile="&path\rapid_syphilis.csv"

out=syphilis

dbms=csv replace;

run;

Delete various datasets in one step

Tim_sas_ — Tue, 04 Aug 2020 15:21:16 GMT

Hello,

I have a problem to delete some datasets in one step. I have various datasets in my work library with the same name and different numbers (e.g. data_1, data_2, data_3, ...). I would like to delete all datasets which start with the term "data".

I have already tried to use PROC Delete, but something is missing.

I would be very grateful if someone has an idea.

Many thanks,

Tim

Proc Delete Data= Data: ;
Run;

could not find my former file on web SAS Studio

salamada163 — Mon, 03 Aug 2020 10:50:07 GMT

when I renew my SAS studio system, I am about to continue to process my datas by the new SAS system on line, but the problem is that I can't find my datas file which I kept before.

Do I need to install SAS before I take a performance based test at home?

herewish — Mon, 03 Aug 2020 01:47:25 GMT

Do I need to install SAS before I take a performance-based test at home? Thank you!

Many-to-many merge

bkq32 — Sat, 01 Aug 2020 00:48:07 GMT

My apologies if this has already been answered on here and I didn't see it, but I have two tables that I'd like to do a many-to-many merge on.

data one;                  
  input id $ color $ animal $ farm $;      
datalines;                 
a blue . .
a black . .
d green . .
;                          
run;
 
data two;                  
  input id $ animal $;      
datalines;                 
a turtle
a snake
b cat
b cow
c bird
c horse
;      
run; 

data want;                  
  input id $ color $ animal $ farm $;      
datalines;  
a blue turtle .
a blue snake .
a black turtle .
a black snake .
b . cat .
b . cow .
c . bird .
c . horse .
d green . .
;      
run;

I've tried the following, but it doesn't yield the same results as the "want" table.

proc sql;
 create table both
  as select * from one as a
   full join two as b
    on a.id = b.id;
quit;

Any suggestions would be greatly appreciated.

Remove 'duplicates' from membership data where term date differs

rrenzi — Fri, 31 Jul 2020 20:26:46 GMT

Using SAS enterprise guide 7.1 32 bit.

My department receives a monthly membership listing. January's data might not show a term date for a member, but February will. People will often change subscriptions, so a member can have multiple effective and expired dates in a year on various products. Below is the bare minimum data. EFFDAT is Effective date. EXPDAT is a term/expired date. 279999 means there is no term date. All subscriptions begin on the first of the month and end the last day of the month. So 201804 means an effective date of 4/1/2018. For 201804 initially there was no term date, but then they termed 201905 (or 5/30/2015) and went to a new product. They started a new product 201906. Initially there was no term date on 201906 effective date but then they termed 201910 and started a new product 201911 with no term date. I have a dozen fields I want to append to the records when I get to the desired result. Below is one sample member record with the desired result below. I do not want to change dates to a date format. I already have a methodology to count months of membership using the date formats used. I am a novice and write basic queries. I think this will need some elementary code. No idea where that goes in my query, but I can probably ask a coworker. I have summarized my data to the data below, but I need another level of summary as shown in desired results. Thanks- I hope this is easy.

Data
MEMBNO	EFFDAT	EXPDAT
23000	201804	279999
23000	201804	201905
23000	201906	279999
23000	201906	201910
23000	201911	279999


Desired result
MEMBNO	EFFDAT	EXPDAT
23000	201804	201905
23000	201906	201910
23000	201911	279999

fill the digits with zero

Smitha9 — Thu, 30 Jul 2020 16:17:21 GMT

Hi,

I have a data example:

345

4654

I want to make the above ID to 5digits by filling the initial digits with Zero.

Example:

00001

00020

00345

04654

can anyone help me with this? thank you in advance

Not enough quota is available to process this command.

marleeakerson — Thu, 30 Jul 2020 13:45:06 GMT

Hello,

I am trying to run a piece of code but I keep getting this error message - any advice?

ERROR: Windows error code: 1816 in hc_normal_write for
/file path/, Not enough quota
is available to process this command.
ERROR: An I/O error has occurred on file data.data1.
ERROR: File data.data1 is damaged. I/O processing did not complete.

Better understanding of IF/THEN-DO

armoore — Thu, 30 Jul 2020 04:55:53 GMT

I am having trouble understanding why " OR " is used instead of " AND " for Step 3.

The Question Asked:

Step 1:

create a temporary data set, cleandata36.
In this data set, convert all group values to upper case.
Then keep only observations with group equal to 'A' or 'B'.

Step 2:

Determine the MEDIAN value for the Kilograms variable for each group (A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.

Step 3:

create results.output36 from cleandata36
Ensure that all values for variable Kilograms are between 40 and 200, inclusively.
If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2.

Step 1: 
data work.cleandata36;
  set cert.input36;
  group=upcase(group);
  if upcase(group) in ('A','B');
run;

Step 2:
proc means data=work.cleandata36 median;
class group;
var kilograms;
run;

Step 3:
data results.output36;
  set cleandata36;
  if Kilograms < 40 OR Kilograms > 200 then do;
  if group='A' then kilograms=79;
  else kilograms=89; 
end;
run;

Merge of 3 data sets

Tim_sas_ — Wed, 29 Jul 2020 16:20:58 GMT

Hello,

I have a very basic question but something seems to be wrong with my code.

I would like to merge 3 data sets (Out_1, Out_2, Out_3, please see below). All have exactly the same structure (variables) and I would like to create a merged table that includes all 3 datasets.

I have tried the following code:

Data final;
Merge Out_1 Out_2 Out_3;
Run;

There seems to be something wrong with it because the merged file only includes the information from Out_3.

I would be very glad if someone could help me out.

Many thanks,

Tim

remove last one digit and first two digits from a number

Smitha9 — Wed, 29 Jul 2020 13:37:42 GMT

Hi,

I have a dataset

2000032

2000072

2000092

I want the dataset:

0003

0007

0009

I want to remove first 2digits and last one digit.

Can anyone help in this. thank you

Observations Selection

JJ_83 — Tue, 28 Jul 2020 14:29:04 GMT

Hello,

I have a dataset with the following structure.

What I want to do is keep only those observations with a day_01 to day_05 value of "1" for any day between the exposure_start and exposure_end.

I would like to do this for each Participant_ID. The exposure_start and exposure_end values are unique to each participant_id

Any ideas?

Here is the code for this sample dataset:

data have;
	input WELL_ID DAY_01 DAY_02 DAY_03 DAY_04 DAY_05 EXPOSURE_START $ EXPOSURE_END $ PARTICIPANT_ID;
	FORMAT WELL_ID z14.;
	datalines;
		01133244410000 0 0 1 0 0 DAY_01 DAY_05 1
		02019220960000 0 0 0 0 0 DAY_01 DAY_05 1
		07167297020000 1 0 0 0 0 DAY_01 DAY_05 1
		17067210480000 0 0 0 0 0 DAY_01 DAY_05 1
		34000000000000 0 0 0 0 0 DAY_01 DAY_05 1
		34001200010000 0 0 0 0 0 DAY_02 DAY_04 2
		34001200020000 0 0 0 0 0 DAY_02 DAY_04 2
		34001200030000 0 0 0 1 0 DAY_02 DAY_04 2
		34001200040000 0 0 0 0 0 DAY_02 DAY_04 2
		34001200050000 0 0 0 0 0 DAY_02 DAY_04 2
	;
run;

Skipping cycles based on dates contained in another dataset

MMariani — Mon, 27 Jul 2020 20:38:40 GMT

Hello there SAS community and I hope to be clear enough about the problem I'm facing.

I have a dataset with many variables including these three : start_date, end_date and leaves_count.

The first variable tells the date when a person is absent from work(due to health reasons, vacations etc), the second when it finishes the absence period while the third gives the absence duration in days. Here is a small sample of the data:

start_date end_date leaves_count
06AUG2018 10AUG2018 5
13AUG2018 14AUG2018 2
17AUG2018 17AUG2018 1

What I would like is an output like this in which each absence is printed:

start_date end_date leaves_count
06AUG2018 10AUG2018 1
07AUG2018 10AUG2018 1
08AUG2018 10AUG2018 1
09AUG2018 10AUG2018 1
10AUG2018 10AUG2018 1
13AUG2018 14AUG2018 1
14AUG2018 14AUG2018 1
17AUG2018 17AUG2018 1

I have already a similar result but now I have a problem i.e. sometimes the absence period contains one or more days that should not be counted as an absence since they are already national holiday. I have the holiday list in another SAS dataset that is just one column similar like this:

holydays
01JAN2020
06JAN2020
25APR2020
01MAY2020

So, I would like to write a code able to compare from_date with the dates contained in the other dataset and skip the holidays if they are contained within the absence period and to be more clear here is an example to show what I'm trying to obtain:

Input

start_date end_date leaves_count
30DEC2019 03JAN2020 4

Output

start_date end_date leaves_count
30DEC2019 03JAN2020 1
31DEC2019 03JAN2020 1
02JAN2020 03JAN2020 1
03JAN2020 03JAN2020 1

So, the code should "jump/skip" a cycle in this case and not printing 01JAN2020 but of course it should be valid for all other holidays within the list.

Hope you can give me some insights or suggestions on how to tackle this problem.

Thanks.

P.s.

I'm working on Enterprise Guide version 8.2 (8.2.0.946) (32-bit).

Fonction INTCK : Date de sortie erronée

CélineSBD17 — Mon, 27 Jul 2020 14:34:00 GMT

Bonjour,

Je rencontre un problème avec ma fonction INTCK. Les données de sortie que j'obtiens ne sont pas toutes bonnes.

Voici mon code:

PROC SQL;
CREATE TABLE VENTES_CAMPAGNE AS 

SELECT DISTINCT
TVEN.SIREN,
TRESUL.UTILISATEURID,
TVEN.OFFRE_VENTES,
TVEN.FAMILLE_VENTES,
TVEN.DATE_VALIDE2 AS DATE_ED_VENTE,
TVEN.PRI_IC AS MONTANT_PRI_VENTE,
TRESUL.DATEFIN_CAMPAGNE,
intnx('dtmonth',TRESUL.DATECREATION_LEAD,+4,'SAMEDAY') AS DFC_3 FORMAT=DATETIME16.,
TRESUL.DATECREATION_LEAD


FROM WORK.VENTES_TOTALE TVEN 
INNER JOIN WORK.CIBLAGE TRESUL ON (TRESUL.SIREN = TVEN.SIREN)

GROUP BY 1,2,3

;
QUIT;

et voici les données que j'obtiens:

Les 3 premières lignes sont bonnes mais pas la 4ème ... etc

Savez-vous pourquoi?
Certaines de mes dates DFC_3 sont bonnes et d'autres non ...

Iterative procedure

Thi_Oliveira — Mon, 27 Jul 2020 13:12:50 GMT

Good Morning, my name is Thiago and I'm trying to do an interactive procedure to calculate real base and ceiling temperatures of beta model in tree growth.

I used a procedure described in an article (image below), however I do not understand the way it is done, since my SAS code is showing errors.

SAS code:

data temp;
k=(Tc-To)/(To-Tb);
l=(0.05**2)*(To-Tb)*((Tc-To)**k);
do i=0 to 10;
L[i+1]=l/(((Tc-Tb)**(k+1))*((1-L[i])**k));
U[i+1]=(l/(((Tc-Tb)**(k+1))*((1-U[i])))**(1/k);
output;
end;

My data "temp" has the To, Tb and Tc values for the iteractive procedure.

Someone could help about that?

Thanks

deleting observations conditioned by previous observations

RTN — Mon, 27 Jul 2020 11:38:11 GMT

I need help removing observations depending on previous observations.

I have

ID HA

1 1

1 3

2 3

3 2

3 3

4 1

4 2

4 3

I want

ID HA

1 1

2 3

3 2

4 1

For each ID I want to keep the observation where HA=1 or HA=2. If one ID has both HA=1 and HA=2, I only want to keep the one where HA=1. If an ID has neither HA=1 nor 2 (ie. only HA=3), then I want to keep all the observations with HA=3.

Any suggestions?

what is basic STMS

Amy0223 — Sun, 26 Jul 2020 00:17:52 GMT

Hi everyone,

Does anyone know what is basic STMS? I’m not sure if STMS stands for Scientific, Technical, Medical, and Scholarly or something else?

Thanks for your kind help!

Display mean on boxplot with sgpanel

hinashah — Sat, 25 Jul 2020 19:04:57 GMT

I have an sgpanel where I want to show categorical boxplots inside each panel. For these boxplots, I'd like to display the mean quantity. However, I can't find a way to do this. Is it possible? Here's my proc sgpanel, and the result is below. I'd like to display the value for mean on this panel for each of the box.

proc sgpanel data=new_one;
panelby testtrain;
vbox diff/category=category nooutliers group=category transparency=0.3;
refline 0/axis=Y lineattrs=(colors=black thickness=2);
run;

Excel file uploaded in library successfully

ws_adan — Sat, 25 Jul 2020 14:39:43 GMT

in message libref EXL was successfully assigned but it is now showing excel sheet in library.

libname ExL xlsx 'C:\Users\Wajeeha Bilal\Desktop\T2_YARD.XLSX';

Cumulative returns for different time windows

anildonmez — Fri, 24 Jul 2020 22:35:01 GMT

Hi SAS community,

This is my very first post to this forum, I hope I can ask my question while abiding by the forum rules.

I have an unbalanced panel data set of daily security log returns. This data set is constructed by merging two data sets: security return data (firm id is gvkey) and another data set containing firm-specific information (firm id is gvkey+iid). Each observation has two dates (date and date2) together with a dummy variable and I'd like to calculate the cumulative log returns between these two dates for those having dummy=1. I'd also like to note that the data is not uniquely defined in the gvkey-date pair since the data set containing firm characteristics has a more disaggregated firm id definition (gvkey+iid). Below, I included a screenshot of the part of my data set:

What I want to do is to calculate the cumulative returns between date and date2 only for row numbers 301, 302, and 310 (where dummy=1). Below screenshot displays what I am trying to get in the end:

Just to make it clearer, the cumulative return for row 310 is calculated as the sum of log-returns shown within red rectangles (or, the sum of single daily log returns from 12/21/2010 to 12/31/2010). Of course, this is just a sample data set, the original data has millions of observations with multiple gvkeys and a larger time frame.

I have some experience with SAS but I couldn't think a clever way to tackle this specific problem. I'd appreciate your help!

How do I set up complete 1st demo (st101d01.sas) in the Statistics 1 course?

ewei — Fri, 24 Jul 2020 18:10:14 GMT

I just started the Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression course.

When I tried to do the st101d01.sas demo, I received the following error messages:

ERROR: The ODS initializer failed to instantiate during SAS startup.
ERROR: Exception text: Assistive Technology not found:
com.sun.java.accessibility.AccessBridge

I have SAS 9.4 (English with DCBS) and SAS Enterprise Guide 7.4 (64-bit). Please note that I first ran the setup file before running parts 1 (%let statements) and 2 (proc freq) of the st101d01.sas file.

How do I solve this problem?

Thank you in advance for your assistance!

PCA in SAS viya , How to do eigen vector matrix(or rotation matrix) by using Proc PCA

satgrgfq4tr4fds — Sun, 26 Jul 2020 04:51:26 GMT

I’m doing PCA on a training dataset before training a predictive model and I'm using 3 PC’s that explains about 97% of the data. Now, how can I do PCA transformation on test data? I will probably have to use eigen vector matrix(or rotation matrix) obtained from the PCA results of the train dataset and perform matrix multiplication with test data. Do I have to scale and center the test data before? Or is there a function in SAS that does this operation? If you are familiar with R, it will be equivalent to using predict() function with prcomp object.

Applying SAS licences to SAS9.4

JLARK — Fri, 24 Jul 2020 01:33:15 GMT

will the relicensing cause any unexpected access to drop off

Adding rows to a data set for each ID

alpera — Thu, 23 Jul 2020 17:31:46 GMT

Hello,

i have an table with repeating id ( because of the recurring events) and i need to add two rows for each observations. Ex if id 1 exist with 4 rows , i need to more rows with same id number which in this case is 1. This should happen for different id i have in my data set.

Thanks.

Integer overflow on computing amount of memory required A request to allocate the memory ....SAS9.4

Annie_Fréchette — Thu, 23 Jul 2020 14:55:04 GMT

Hi! How can I bypass or resolve this problem in my log... I am tryin to create a model where I have multiple SCC_linear_score by lactation, multiples lactations by cow and multiple cows by herd, and of course multiple herds.

proc sort data=qulac;
by No_ferme cow jr_test;
run;

proc mixed data=qulac order=data /*method=ml*/;
class type_lit cow No_ferme Lac;
model SCC_linear_score=type_lit  /solution cl;
random intercept /subject=No_ferme;
random intercept/subject=Cow (No_ferme);
Repeated /subject=lac (cow No_ferme) type=toep;
lsmeans type_lit / cl;
run;

Here's a print screen form my log.

Thanks a lot!!

sas_alo

asassasasas — Thu, 23 Jul 2020 13:09:39 GMT

joining tables: a version of many to one??

drshashlik — Thu, 23 Jul 2020 03:30:17 GMT

Hi SAS users,

I need to join two tables, and no matter which way I go, I get many blank cells.

Table 1 has many rows with events and dates for each event.

Table 2 has 41 rows with inflation index by year and quarter for 10 years.

I need a table that has inflation value matched to each date. For example, all events occuring between January 1, 2010 and March 31, 2010 should have the inflation value for 2010Q1 in the new column.

My attempts at using proc sql (including left join) to join the tables are giving me thousands of blank cells in the inflation column.

Your help is, as always, appreciated!

serial ID

Smitha9 — Wed, 22 Jul 2020 18:33:01 GMT

Hi,

I have repetitive ClassID and I want to give seperated ID per classID.

ClassID ID

1 1

1 2

1 3

2 1

2 2

2 3

I want create ID's like above using the classID.

can anyone help me with this?

thank you in advance

Converting data character to numeric, yeah again.... (SAS9.4)

Annie_Fréchette — Wed, 22 Jul 2020 18:31:46 GMT

Hi, I've read some posts and watch the tutorial, but I can figure out how to resolver my (pretty simple) problem. My original data are character format $105 (even if there are numbers) and I want to create a new variable where they would be numerics... Can you help me ? I'm confused between the input, the informat and format...

/*changer mon type de colonnes, ce sont toutes des character sauf No_ferme*/
data prx;
set pr;
DIMx=input(DIM, $8.);
run;

Here is a print screen of the data and the code.... THANKS!:)

Variable

honeyblue — Wed, 22 Jul 2020 03:50:54 GMT

I have a variable name with value NaveenKumar, HarishChandra, SivaKumar

But I want to separate as firstname and last name

ex Firstname ------------Naveen lastname ----Kumar

Variable

honeyblue — Tue, 21 Jul 2020 20:58:39 GMT

I have 25 observations i want to assign 1 to a variable for 1 - 12 observations and assign 2 to the same variable for 13-25 observations

difference of # of days from 1st row to 2nd row and 2nd row to 3rd row so on by ID

mahossain — Tue, 21 Jul 2020 16:54:47 GMT

i.e first # of days (difference) will be missing and the 2nd will be difference of Jan 22, 2020-Jan 01, 2020 and so on by ID
ID Date # of days (difference)
1 Jan 01, 2020
1 Jan 22, 2020
1 Feb 02, 2020
2 Jan 01, 2020
2 Jan 24, 2020
2 Feb 12, 2020

range in if statment

veda8 — Tue, 21 Jul 2020 16:08:52 GMT

Ensure that all values for variable Kilograms are between 40 and 200, inclusively.

what does the word inclusive mean here

should it be this option 1) ,if so why?

if Kilograms ge 40 or Kilograms le 200 then do;

is this correct?

or should i write kilograms > 40 or kilograms =40 or kilograms =200 or kilograms < 200 them do;

If condition error

suresh123 — Tue, 21 Jul 2020 14:38:15 GMT

I have two numeric variables with 1 and 0 as data points.

data new;

set new1;

if a=1 and b=0 then out="bad" else bad="good";

run;

I am getting below error:

Note: Invalid Numeric data.

I cant change the dataset but how to change the code to handle this error

proc format and proc freq

emaguin — Tue, 21 Jul 2020 14:38:11 GMT

A while back a responder generously provided to me a detailed example on writing a proc format statement. I'm now trying to use that example and do something useful. Here's what i have.

proc format;

value couse2 0='0 neither' 1='1 either' 2 '2 both';

value dalc1r_ 0= '0 no' 1='1 yes';
value dmj1r_ 0 = '0 no' 1 = '1 yes';
run;

proc freq data=co_usevars;

table couse2;

table dalc1r*dmj1r;
run;

Here's what i want. Instead of the standard listing, I want to see the frequency listings show this;

0 neither 200 25.00 200 25.00

1 either 400 50.00 600 75.00

2 both 200 25.00 800 100.00

I want the crosstab to show, what i would call the value labels, e.g., 1 yes, in the table.

Nothing works.

The format for couse2 gives an error because a variable can not end in a number, dalc1r_ doesn't give an error in the format command but neither that construction nor dalc1r yields the value labels in either the frequency listing nor the crosstab.You may be wondering why i wrote dalc1r 0='0 no' instead of dalc1r 0='no'. That's because a much more experienced use warned me that the 'no' wipes out the 0. I've got Ron Cody's very nice book and, interesting ly, in the proc format chapter he does not show an example that uses proc freq. I been told that proc report or proc tabulate gives more options. I accept that it's true--and i'm sure that additional work is involved. What is useful enough to us is a fully labeled frequency listing or crosstab table, sometimes with a chisquare and sometimes without a chisquare.

The question is can sas be made to give me what i want?

Thanks, Gene Maguin

Where clause doesn't work.

GN0001 — Tue, 21 Jul 2020 01:34:53 GMT

SAS Studio doesn't filter it:

I have this:

Add a WHERE statement that uses the SUBSTR        *;
*       function to include rows where the second letter  *;
*       of Basin is P (Pacific ocean storms).


data pacific;
	set pg1.storm_summary;
	drop Type Hem_EW Hem_NS MinPressure Lat Lon;
    WHERE Substr(Basin, 2, 1) = "P";
run;

It shows all the values for the column when I run this code:

Regards,

Date and text in the same column

Barkat — Tue, 21 Jul 2020 00:11:48 GMT

I have a dataset that contains both text and date value in one column. When I import the dataset in SAS, that column is imported as char. How do I keep the dates in DATE9. format and convert the texts as missing in SAS?

identifier	effectiveFromTime	effectiveThruTime
1	4/23/1987 23:00	NULL
2	6/4/1987 0:55	7/1/1997 10:50
3	5/27/1987 8:20	7/15/2015 11:20
4	5/28/1987 5:20	8/4/2011 0:00
5	6/1/1987 14:56	NULL
6	5/28/1987 4:50	NULL
7	4/15/1987 0:20	NULL
8	5/11/1987 17:06	9/6/1996 21:30
9	6/8/1987 10:40	7/1/1997 11:50

Creating three new variables in a panel dataset

AlG — Mon, 20 Jul 2020 22:56:44 GMT

Hi friends,

3. I have several variables which are in percentage (they have been calculated using avg() format=percent7.2 ). I need to convert these to numbers. so for example 91.70% should be converted to 0.917.

Thanks so much in advance for your help.

Separating text into separate variables

marleeakerson — Mon, 20 Jul 2020 19:10:32 GMT

Hello,

I have a variable with first and last names and I am trying to separate them into two separate variables. See the sample data below:

Name

Smith Joe

Reynolds Jack

Anderson Amy

But I want the data to read:

Last Name First Name

Smith Joe

Reynolds Jack

Anderson Amy

Does anyone have any advice for me? Thank you!

proc sort data using noduprecs

veda8 — Mon, 20 Jul 2020 14:08:49 GMT

do we have to always sort by _ALL_ to use noduprecs?

Unable to connect to SAS Studio

rmosaad — Sat, 18 Jul 2020 20:30:14 GMT

I downloaded SAS University Edition and VMWare Playstation 15 and successfully did some coding on SAS Studio. Now I am trying to log into SAS Studio and it is giving me a connection error (ERR_Connection) on Internet Explorer and ERR_EMPTY_ RESPONSE on google Chrome. Any suggestions?

compare two datasets and create a new dataset that only has different observations

knighsson — Sat, 18 Jul 2020 15:17:53 GMT

Hi,

I have two datasets with different variables. But both datasets have a variable "sequence number" to represent observations. I want to know how many observations are different from each other (or how many observations are not in dataset 1 but in dataset 2). I also want to create a new dataset with variables in dataset 2.

Dataset 1:

seqn variable1 variable 2

1 3 2

3 4 2

......

dataset 2:

seqn variable3 variable 4

1 1 4

2 2 3

3 2 3

......

dataset I want:

seqn variable3 variable 4

2 2 3

......

Thank you!

Need help with code of seperate variables with delimiter

manilara44 — Sat, 18 Jul 2020 10:48:32 GMT

i have data set in note pad like that i want import into sas

Car Make Model Type Origin Seat MRP Show Room Price Rate Star
Acura|MDX|SUV|Asia|All|$36,945|$33,337|3.5|
Acura|RSX Type S 2dr|Sedan|Asia|Front|$23,820|$21,761|2|

Those data have delimiter value of |

Expected result as

Result
Car Make Model Type Origin Seat MRP Show Room Price Rate Star
Acura MDX SUV Asia All $36,945 $33,337 3.5
Acura RSK Sedan Asia Front $23,820 $21,761 2

How to speed up multiple regressions in SAS

Tim_sas_ — Sat, 18 Jul 2020 09:20:12 GMT

Hello,

I have a problem to speed up my regressions in SAS using the macro below.

I would like to suppress the regression results in the results window, however, the Noprint function does not work here because it sends no output to ODS.

I have tried "ODS select none" as well as "ODS exclude none", but the results window then still appears. I would be very glad if someone could help me out. Any ideas on how to speed up the macro (multiple regressions) below or on how to suppress the output in the results window while still calculating the output tables are highly appreciated.

Thank you a lot for any help.

Tim

*Macro to run several regressions using a loop (based on a startyear);
%Macro Startermacro (window=,dataset_in=);
	%do startyear = 2003 %to %eval(2014 - &window. + 1);

*Run a regression of earnings on lagged variables and save the output statistics;
proc reg data=&dataset_in. ;
	model earn_w = L1_earn_w L1_negE_w L1_NExE_w;
	where &startyear. <= HouFyear <= %eval(&startyear. + &window. - 1);
	ODS OUTPUT parameterestimates = par_est_&startyear.;
run; quit;

*Write the start year in a separate column; 
		data par_est_&startyear.;
			set par_est_&startyear.;
			startyear = %eval(&startyear. + &window. - 1);
		run;

*Combine all outputs to one file;
	data combined_par_est;
		set par_est_:;
	run;
%end;
%mend;

help please :) adding confidence intervals to SGplot after repeated measures Proc Glm?

GabbyJ — Fri, 17 Jul 2020 21:00:45 GMT

Hi,

Could you kindly help me?

I would like to add confidence intervals to a graph following proc GLM with data from multiple timepoints.

I calculated the means in each group, but not CIs. Could you teach me how to calculate and graph the CIs?

Or would it be easier to use a mixed model?

Data, code, and sample graph are below.

Thank you so much 🙂

proc glm data=exercise;
  class exertype;
  model time1 time2 time3 = exertype;
  repeated time 3 ;
  lsmeans exertype / out=means;
run;
quit;
proc print data=means;
run;

proc sgplot data=means;
	series x=_name_ y=lsmean / group=exertype;
run;
quit;

sample data:

data exercise;
  input id exertype diet time1 time2 time3;
cards;
1     1         1       85       85       88
2     1         1       90       92       93
3     1         1       97       97       94
4     1         1       80       82       83
5     1         1       91       92       91
6     1         2       83       83       84
7     1         2       87       88       90
8     1         2       92       94       95
9     1         2       97       99       96
10    1         2      100       97      100
11    2         1       86       86       84
12    2         1       93      103      104
13    2         1       90       92       93
14    2         1       95       96      100
15    2         1       89       96       95
16    2         2       84       86       89
17    2         2      103      109       90
18    2         2       92       96      101
19    2         2       97       98      100
20    2         2      102      104      103
21    3         1       93       98      110
22    3         1       98      104      112
23    3         1       98      105       99
24    3         1       87      132      120
25    3         1       94      110      116
26    3         2       95      126      143
27    3         2      100      126      140
28    3         2      103      124      140
29    3         2       94      135      130
30    3         2       99      111      150
;
run;

Conversion of a table in SAS

Tim_sas_ — Fri, 17 Jul 2020 19:59:37 GMT

Hello,

I have a very basic question regarding a table where I would like to change the order of rows and columns.

The problem is illustrated by the picture below. I have a SAS table in the upper format and would like to transform it to the format describes below.

I would be very glad if some could help me out.

Thanks a lot.

Peter

PROC SQL help

marleeakerson — Fri, 17 Jul 2020 17:35:28 GMT

Hello,

I need some help with a proc SQL problem. Take the sample data below:

Table 1

Code Description

1 X

2 Y

3 Z

Table 2

Code ID

2 a

3 b

4 c

So I want to pull all the observations from Table 2 that have a matching Code from Table 1 (so this would be Code 2 and Code 3).

Is there a way to do this in SAS (I presume it is easiest with proc SQL but if it works with a data step that is great too)

Thanks!

delete lines based on a character (SAS 9.4)

Annie_Fréchette — Fri, 17 Jul 2020 12:32:33 GMT

Hi! I would like to delete some lines from my data. See the print screen for an overview.

I want to remove the lines from the cows who have a chain_number starting with an "N". How can I ask this to SAS?

Thanks!

How do I get variable values to show up in output? SAS 9.4

jranta — Fri, 17 Jul 2020 04:55:19 GMT

I know there has to be a simple solution here. It prints out everything I want except for the values.

proc format;
value id = 'ID';
value Diagnosis 0 = 'n/a' 
				1 = 'LTBI'
    			2 = 'ACTIVE' 
				3 = 'NOT TB';
value PPD 		0 = 'n/a' 
				1= 'Positive' 
				2= 'Negative';
value CXR 		0 = 'n/a' 
				1 = 'WNL' 
				2 = 'Abnormal';
value Treatment 0 = 'n/a' 
				1 = 'Yes' 
				2 = 'No' 
				3 = 'Pending';
				run;
Data Notes;
input ID Diagnosis PPD CXR Treatment;
datalines;
1 1 1 1 1
2 1 1 1 1
3 1 1 1 1
4 1 1 1 1
5 2 1 2 2
6 1 1 1 1
7 1 1 1 1
8 0 0 0 0
9 1 1 1 1
10 1 1 1 1
11 2 1 2 2
12 1 2 0 0
13 3 2 0 0
14 3 2 0 0
15 3 2 0 0
16 2 1 2 2
17 1 1 1 1
18 3 2 0 0
19 3 2 0 0
20 1 1 1 1
21 1 1 1 1
22 3 2 0 1
23 1 1 1 0
24 3 2 0 1
25 3 2 0 0
26 1 1 1 0
27 3 2 0 1
28 3 2 0 0
29 3 2 0 0
30 3 2 0 0
31 3 2 0 0
32 2 1 2 3
33 3 2 0 0
34 1 1 1 3
35 2 1 2 2
36 0 0 0 0
37 3 2 0 0
38 3 2 0 0
;
run;
format id id. diagnosis diagnosis. ppd ppd. cxr cxr. treatment treatment.;
proc print data = notes;
var diagnosis ppd cxr treatment;
title 'Chart';
run;

Counting observations with a specific value

AlG — Thu, 16 Jul 2020 20:35:13 GMT

Hi experts,

I have a pretty basic question.

I have a panel dataset, including weekly data on several firms. I have a variable "Week_Volume". I want to know for each firm (identifier variable: brand_name) how many times (i.e., for how many weeks) "Week_Volume" equals zero.

Can you please recommend an easy solution for this? Thanks!

Identifying missing data values in data set

armoore — Thu, 16 Jul 2020 03:49:49 GMT

For the missing values in cholesterol. The code is not working for the output variable chol_status. Each time I run the code the output variable chol_status displays “Safe” instead of a blank space.

To identify missing values I thought you used: if variable-name=. then variable-name=. ; or if missing(variable-name) then variable-name=. ;

What would be the correct code for missing values for ?

data results;
	set "/home/u44696116/TheCut/input/input44.sas7bdat";
	length chol_status $ 15;
	drop bp_status weight_status smoking_status;
	if cholesterol=. then chol_status=. ;
			if cholesterol<200 then chol_status="Safe";
			else if cholesterol<=239 then chol_status="High-Borderline";
			else if cholesterol>=240 then chol_status="High";		
run;

SAS ANSWER

data out;
	set "/home/u44696116/TheCut/input/input44.sas7bdat";
	length chol_status $ 15;
	drop bp_status weight_status smoking_status;
	if cholesterol ne . then do;
	                if cholesterol < 200 then chol_status='Safe';
			else if cholesterol <=239 then chol_status='High-Borderline';
			else if cholesterol >=240 then chol_status='High';
		end;
run;

Removing duplicate dates from observation, and count number of dates

Barkat — Wed, 15 Jul 2020 23:50:38 GMT

Hello,

I have the following dataset

data have;
infile datalines dsd dlm=',' ;
input name :$3. id :$3. date1 :MMDDYY10. date2 :MMDDYY10. date3 :MMDDYY10. date4 :MMDDYY10. date5 :MMDDYY10.;
datalines;
abc,010,01/10/2017,03/20/2016,.,01/10/2017,.
def,023,.,.,04/20/2018,.,04/20/2018
pqr,125,08/10/2013,.,05/20/2012,.,.
xyz,200,01/12/2016,01/21/2016,05/10/2017,09/01/2018,03/02/2016
;
run;

I would like to have an output from the above that will look like the output of the following dataset. Please note that there will be no duplicate dates for an observation, and the remaining dates will be sorted and shifted to the left columns in ascending or descending order. Missing values will be shifted to the right columns.

I would also like to add a column that will count the number of dates of each observation. Suppose number of dates for abc is 2, number of dates for def is 1, number of dates for pqr is 2, and number of dates for xyz is 5.

data have;
infile datalines dsd dlm=',' ;
input name :$3. id :$3. date1 :MMDDYY10. date2 :MMDDYY10. date3 :MMDDYY10. date4 :MMDDYY10. date5 :MMDDYY10.;
datalines;
abc,010,03/20/2016,01/10/2017,.,.,.
def,023,04/20/2018,.,.,.,.,.
pqr,125,05/20/2012,08/10/2013,.,.,.
xyz,200,01/12/2016,01/21/2016,03/02/2016,05/10/2017,09/01/2018
;
run;

Thanks a lot.

SAS date variable help

marleeakerson — Wed, 15 Jul 2020 21:40:17 GMT

Hello,

I need help converting numeric variable to a usable SAS date variable.

This is a snippet of the data:

Date1

19370215
19370215
19370215
19700210

and I want the data to look like this

Date2

1937/02/15
1937/02/15
1937/02/15
1970/02/10

So I am using this code:

data want;
set have;
Date2 = Input( Put( Date1, z8.), mmddyy10.);

run;

But I keep getting this note

NOTE: Invalid argument to function INPUT at line 30 column 14.

And Date2 column is completely blank.

Any help?

Error from code

adzoyi — Wed, 15 Jul 2020 16:20:18 GMT

Hi! I am struggling with SAS syntax error diagnosis. I am new to SAS and I have been trying hard to resolve simple errors but I still cant. Any help with the below error from my proc procedure please.

proc sql;
create table Co_STLoc as
select a.*, b.St_fips AS Client_state, co_fips AS G132
from Co_ST_Out as a left join Fipsmod1 as b
on a.State = b.State AND a.county = b.county;

quit;

ERROR: Expression using equals (=) has components that are of different data types.

Leading zeros

marleeakerson — Wed, 15 Jul 2020 16:06:15 GMT

Hello,

I need some help with important an excel document where some observations have leading zeros and some do not. For example, take the following sample dataset:

ID Variable

1 002

2 617

3 012

4 G317

How do I import this into sas while keeping the leading zeros?

Thank you!

calculate a difference between two days; SAS 9.4

Annie_Fréchette — Wed, 15 Jul 2020 12:23:42 GMT

Hi!

I wondering if there is a way to calculate the number of days between first jr test and second test, and between second and third, etc. Knowing that some jrtest will be ".".

data have;
input cow$ jrtest:ddmmyy10. scc;
cards;
daisy 10/7/2017 200
maggy 10/7/2017 120
lily 10/7/2017 98
daisy . 89
maggy 11/8/2017 120
lily 11/8/2017 98
daisy 13/9/2017 102
maggy 13/9/2017 154
lily 13/9/2017 232
;

Not sure if it helps, but after that I'm transposin my jrtest and I don't want to keep the dates so I'm going with this

proc sort data=have;
format jrtest date9.;
by cow jrtest;
run;

data want;
set have;
by cow jrtest;
retain no_test;
if first.cow then no_test=1;
else no_test+1;
run;

So, I want to know how many days are between test 1 and test 2, test 2 and test 3 etc.....

Thanks!

Help with data stratification

marleeakerson — Tue, 14 Jul 2020 19:01:27 GMT

Hello,

I need figuring out the code to stratify my data.

For instance, take this sample data:

ID Index

1 A

1 B

1 C

2 A

2 B

3 C

3 B

3 A

4 A

So I am trying to make two output data sets -

One table where it only contains the rows where the ID has both A and B Index
One table where it only contains the rows where the ID has both A and C Index

Does anyone have any ideas?

Thank you!

How to KEEP duplicates in Proc SQL, aggregating for quarter

User12321 — Tue, 14 Jul 2020 06:01:10 GMT

I am trying to aggregate data for the quarter from months.

Data is quite simple has Type, Code and then values (revenue, quantity, label etc.).

Occasionally some lines in month 1 match exactly lines in month 2 or month 3 of the quarter. I just discovered that in that case data from one of the month is dropped ( i.e. duplicates are eliminated). I need to keep all data! Can this be done with proc sql?

Current program in the nutshell:

proc sql;

create table Q as

select type, code, sum (revenue) as Revenue, sum(quantity) as Quantity, label

from

(select * from month1 union

select * from month2 union

select * from month3)

where code is not null

group by type, code, label,

order by type , code;

quit;

Thanks!

title statement

Jianan_luna — Tue, 14 Jul 2020 02:00:43 GMT

I am confused about this question, why does the title statement t for the last PROC PRINT step cancel all the higher TITLEn statements? Thanks!

create a variable from a date

Annie_Fréchette — Mon, 13 Jul 2020 12:34:03 GMT

Hi!

I want to create a variable who goes frome 1 to 12 based on the date of a test (like first test of the year, second test of the year etc) Here is a little example of what I want it to look like:

Anyone can teach me?

Thanks a lot!

Annie

Macro variable while input to data cause zero missing

Sas_user_14 — Mon, 13 Jul 2020 08:02:24 GMT

Hi,

I meet a problem.

while I want to insert a marco variable with zero at the front into a data.

I found that the zero will be clean.

Because the process of insert marco variable will change type by : marco variable-> num -> char.

And it will case the zero missing.

Example:

%let i = 007;

data a;
ax=put(&i. , $4);
run;


*/output: 7 /*

About case sensitive

Jianan_luna — Sun, 12 Jul 2020 19:53:45 GMT

When I refer column_name in statement like where and var, sometimes I ignore the font format. Is it matter to ignore the upper case or lower case when I reference the column name?

thanks!

about the usage of table optoin

Jianan_luna — Sun, 12 Jul 2020 19:48:41 GMT

when I learn programming 1 course, some statement use

Proc freq data=;

table options;

tables options;

what's the difference between table and tables?

Thanks

Exporting file from SAS

Jianan_luna — Sat, 11 Jul 2020 21:04:09 GMT

When I learn exporting file from SAS, I have some questions about some statements. Like:

ods noproctitle;

options orientation=landscape;

ods excel file=;

when we add those statement at the beginning of the code. We always need add some statements like:

ods proctitle;

options orientation=portrait;

ods excel close; at the end of program. Why we need to add those statements at end of the program? Thanks so much

Exporting excel

Jianan_luna — Sat, 11 Jul 2020 20:58:34 GMT

When I do the quiz from SAS programming 1 course, I cannot make sense this question. Can anyone help me this question?

HELP: No columns show in my dependent variable when running a graph.

tessa3 — Sat, 11 Jul 2020 17:59:39 GMT

Please help me!! I am a beginner student to SAS and need help with running a graph. Every time I try it says there's no columns in my dependent variable section. I will attach the code that I get when I upload my .csv file into SAS.

SAS UniversityEdition - Macro for PISA

rojouno — Fri, 10 Jul 2020 23:51:24 GMT

Hi everyone, can I use macros in SAS University Edition? I am in educational research, PISA 2015 and 2018, and I want to use the macro that the OECD provides to deal with the 10 plausible values, and to make multilevel models. I have experience in SPSS, but macros in SPSS do not work for me, or I do not know how to make them work, and there are only 5 plausible values.

https://www.oecd.org/pisa/data/httpoecdorgpisadatabase-instructions.htm

Thanks, Walter

struggling with dates

Annie_Fréchette — Fri, 10 Jul 2020 18:19:46 GMT

Hi! I'm having some issues with a variable. Test_date is , when I double click ont it, a character type. But it's a date. Ex:18-12-2017. I try to convert it in a date format (DDMMYY10.;) but it doesn't work.

data work.f2sd;
set work.f2sd;
informat Test_date DDMMYY10.;
format Test_date DDMMYY10.;
run;

Here is my log:

326 data work.f2sd;
327 set work.f2sd;
328 informat Test_date $DDMMYY10.;
----------
48
ERROR 48-59: Le(la) informat $DDMMYY est introuvable ou n'a pas pu être chargé(e).

329 format Test_date $DDMMYY10.;
----------
48
ERROR 48-59: Le(la) format $DDMMYY est introuvable ou n'a pas pu être chargé(e).

330 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.F2SD may be incomplete. When this step was stopped there were 0
observations and 8 variables.
WARNING: Table WORK.F2SD non remplacée car cette étape a été interrompue.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds

Anyone can help?

And I have a second question: How could I code for this steps:

First, class the dates from older to newer;

if date is before 31-01-2018, then delete this line.

Thanks a lot!

SAS university edition is not opening and showing some strange codes on my virtual machine

VarshiRGK — Fri, 10 Jul 2020 18:04:44 GMT

Kindly help me resolve this issue

LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid errors

thebugslayer — Fri, 10 Jul 2020 16:27:19 GMT

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

76 libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";

ERROR: seacoastlib is not a valid SAS name.

ERROR: Error in the LIBNAME statement.

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Running the statement below to connect to a SQL Server database through DSN and I get error "ERROR: seacoastlib is not a valid SAS name:

libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";

I have another statement, almost the same, to a different DSN, all in the same ODBC.INI file; the only difference is that the other statement includes a schema.

libname etllib odbc dsn="etl" user="myuser" pass="mypassword" schema="myschema";

PS: this statement that executes resides in a file created a long time ago. Maybe some variable created that reside in the system somewhere. The one that fails was created today.

I have even tried

caslib seacoastlib datasource="seacoast" user="myuser" pass="mypassword"

What am I missing?

Re: SAS university Edition not working on VirtualBox

wprice165 — Fri, 10 Jul 2020 02:31:45 GMT

Hi,

I've got an HP laptop with windows 10 and it was running sas university real well, but now when told to put http://localhost:10080 into browser no window or error message.

Any troubleshoots or fixes you can give most appreciated.

Comparing dates in a macro - help needed

tahos — Fri, 10 Jul 2020 07:46:19 GMT

Hi,

I am looking to be able to set a custom interval and then create month dummies for observations with a macro. I am running into problems with the comparison of dates. In addition to what is below, I have also tried using quotes around the macro date variables and using the %sysevalf-function with %if-%then-%else -structure (and both at the same time). In the %sysevalf-case the date comparison is just always true or false. Below is my code:

%macro date_loop(start,end);
	data WORK.x7;
			set work.x99;
		   %let start=%sysfunc(inputn(&start,anydtdte9.));
		   %let end=%sysfunc(inputn(&end,anydtdte9.));
		   %let dif=%sysfunc(intck(month,&start,&end));
		     %do i=0 %to &dif;
					%let date=%sysfunc(intnx(month,&start,&i,b),date9.);
					%let date2=%sysfunc(intnx(month,&start,&i,e),date9.);
					if mydate1 <= &date2. AND mydate2 >= &date. then 
						%do;
							if employed = 'true' then p&i. = 1;
							if dummy = 'true' then p&i. = 1;
						%end;
					
					else %do;
							p&i. = 0;
						%end;
		     %end;
	 run;
%mend date_loop;


%date_loop(01jan2019,01jan2020);

which results in following errors

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, 
              LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.  

ERROR 388-185: Expecting an arithmetic operator.

ERROR 76-322: Syntax error, statement will be ignored.

I would be grateful for any help!

How to create an ods html output in SAS Studio?

Jfrank — Fri, 10 Jul 2020 00:53:20 GMT

data sample;

input x y z;

datalines;

8.9 4.2 9.3

5.7 6.0 2.0

6.4 5.5 2.7

;

run;

ods listing close;

ods html body="e\SASUniversityEdition\Myfolder\reg.htm”；

proc reg data=sample;

model y=x;

run;

quit;

After my running the above program, the logo shows error: insuffient authorization to access/opt/sasinside/sasconfig....

No body file; Html output will not be created.

I don't know what is wrong with it? Can you help me? Thanks!

But when running the above

503 Service Unavailable

rh3303 — Thu, 09 Jul 2020 22:49:57 GMT

Hello, is anyone having problems trying to start the JupyterLab Notebooks right now? Every time I go to the startup link for it, it shows:

'Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Apache Server at localhost Port 10080'

Is anyone else experiencing the same problem right now? Thanks.

File location?

GN0001 — Wed, 08 Jul 2020 22:20:43 GMT

Hello team,

I am learning SAS. I have created a library, I can't find where the physical location of the this library/ folder is.

Regards,

ERROR 65-58: Name 'AMCOHORTS_01MAY2019_31MAR2020_MEDICAL' is too long for a SAS name in this context

wheddingsjr — Thu, 09 Jul 2020 16:40:31 GMT

Good afternoon

I am trying to export an excel file into SAS EG and I keep getting the above mentioned error message. Can anyone assist me? This is the code I am using.

/* claims file name from AM From payer directory */
%LET claimsFile= \\Cifs2\pop_lab$\P4P\BCBSMA\FY20\Actively Managed\From BCBSMA\AMCohorts_01May2019_31Mar2020_medical.xlsx;
%LET claimsFileType= XLSX; 		/* Options: DLM, XLSX */
%LET claimsSheetname= AMCohorts_01May2019_31Mar2020_m;

LIBNAME EPICPAT odbc complete="driver=SQL Server; database=EPIC; server=PHSSQL2195" schema=PATIENT; /* dev server */

/*Cohort period*/
%let Beg_dt= '01MAY2019'D;
%LET End_dt = '30APR2020'D;
%LET HCPCS = hcpcs_proc_cd IN ('99281',' 99282', '99283', '99284', '99285');
%LET REV = revenue_cd IN ('450','451','452','456','459','981');

proc sql;
create table AMCohort as select
distinct *
from claimsfile.AMCohorts_01May2019_31Mar2020_medical
where &REV
and &HCPCS
;quit;

SAS Date Help

marleeakerson — Thu, 09 Jul 2020 15:47:27 GMT

Hello,

I think I have a very simple question using date variables but I can't seem to figure it out. I am working with a date variable in this format

Date

02/09/1996
02/09/1996
02/09/1996
06/19/1981
10/31/1954
10/09/1958
06/17/1960

and I am trying to find all the variables where the Date is after October 1, 2019. So I am using this piece of code:

if Date >= 10/01/2019
then Variable= "X";

But I keep getting observations where the Date is before 10/01/2019 marked as "X".

Any suggestions?

About the length of column

Jianan_luna — Thu, 09 Jul 2020 03:50:02 GMT

I took quiz from SAS programming 1, I think the length is 8. But the answer is 6. Could anyone help me about it?

small question relate to programming 1

Jianan_luna — Thu, 09 Jul 2020 01:08:40 GMT

1. When I do the practice in programming 1:essentials, some statements use the NODUPRECS statement other than the NODUPKEY statement. What's the difference between those two?

2. Some questions ask for formatting commas with decimal places. But I don't know how to decide the proper width of length. Can I round it? An example like comma6., what does 6 stand for?

3. I saw some questions use " ", some use '', is there any difference?

4. one question ask for "Write a DATA step to read the pg1.np_species table and create a new table named fox.
Note: If you are using SAS Studio, try creating fox as a permanent table in the EPG1V2/output folder." But there is no answer for libname statement. I am not sure whether it's correct.

libname out "path-to-EPG1V2/output.fox";
data fox;
    set pg1.np_species;
    where Category='Mammal' and upcase(Common_Names) like '%FOX%' 
        and upcase(Common_Names) not like '%SQUIRREL%';    
    drop Category Record_Status Occurrence Nativeness;
run;

Thanks so much!

Proc SQL Count help

marleeakerson — Wed, 08 Jul 2020 16:13:11 GMT

hello,

i have a very basic proc SQL question.

What should the syntax be to count the number of different observations in a variable? For instance in the table below

ID Variable

1 X

2 X

3 Y

4 X

How would I find the total count of X and Y appearances in the "Variable" column using proc SQL?

Thank you!

Base SAS

Raj00007 — Wed, 08 Jul 2020 04:43:21 GMT

"Exclude all variables that begin with "ex" from results.nomatch08.".

i have a question like this. How do i execute it ?

Split single colum data into multiple column

Barkat — Wed, 08 Jul 2020 00:36:27 GMT

I have follwoing dataset.

data have;
infile datalines dsd dlm=',' ;
input name :$3. id :$3. reg_dates :MMDDYY10. test_dates :MMDDYY10.;
datalines;
abc,010,01/10/2017,01/20/2017
abc,010,01/10/2017,05/12/2017
abc,010,08/01/2019,08/13/2019
abc,010,10/02/2018,10/09/2018
def,023,02/11/2017,02/14/2017
def,023,07/03/2016,07/30/2016
def,023,11/20/2017,11/26/2017
def,023,11/20/2017,04/20/2018
def,023,06/02/2017,07/02/2017
pqr,125,05/10/2013,05/20/2013
xyz,200,09/12/2015,09/18/2015
xyz,200,01/12/2016,11/22/2017
xyz,200,01/12/2016,01/21/2016
;
run;

Please note that most of the subjects have multiple reg_dates and test_dates. How can I split the dates into multiple column. Like, reg_date1, reg_date2, reg_date3 . . . and also test_date1, test_date2 and so on.

So, the column of the output dataset will be like below.

name id reg_date1 reg_date2 reg_date3 reg_date4 reg_date5 test_date1 test_date2 test_date3 test_date4 test_date5

Ultimately one subject will have one row.

Thanks,