About SASJedi

SASJedi · ‎10-27-2020

Moved to the SAS Procedures community for better visibility.

SASJedi · ‎10-27-2020

I love the SCAN solution for its simplicity and speed. But to ensure you preserve the '-' int the original values (indicating that there is no initial in that position) you need to specify comma as the only delimiter for SCAN. This should do the trick: data want; set have; /* Split Initials into 2 "words" using SCAN with only comma as delimiter */ /* Then concatenate the "words" in the desired order */ initials=cats(scan(initials,-1,','),scan(initials,1,',')); run;

SASJedi · ‎10-26-2020

You can get a detailed description of any cas action result set using the describe statement. proc cas; /* Get a list of all the tables in the CASUSER caslib */ action table.tableinfo result=r/caslib="casuser"; /* Write a description of the result set to the SAS log */ describe r; quit; Produces this information in the SAS log: dictionary ( 1 entries, 1 used); [TableInfo] Table ( [2] Rows [24] columns Column Names: [1] Name [ ] (varchar) [2] Label [ ] (varchar) [3] Rows [ ] (int64) [4] Columns [ ] (int64) [5] IndexedColumns [Indexed Columns ] (int64) [6] Encoding [ ] (char) [7] CreateTimeFormatted [Created ] (varchar) [8] ModTimeFormatted [Last Modified ] (varchar) [9] AccessTimeFormatted [Last Accessed ] (varchar) [10] JavaCharSet [Character Set ] (char) [11] CreateTime [ ] (double) [12] ModTime [ ] (double) [13] AccessTime [ ] (double) [14] Global [ ] (int32) [15] Repeated [ ] (int32) [16] View [ ] (int32) [17] MultiPart [ ] (int32) [18] SourceName [Loaded Source ] (varchar) [19] SourceCaslib [Source Caslib ] (varchar) [20] Compressed [ ] (int32) [21] Creator [Table Creator ] (varchar) [22] Modifier [Last Table Modifier] (varchar) [23] SourceModTimeFormatted [Source Modified ] (varchar) [24] SourceModTime [ ] (double) So, the result set is a dictionary with a single entry, a table named TableInfo. In the TableInfo table, the NAME column contains the names of the tables in the caslib. We can use this table to drive other CAS actions. For example: proc cas; /* Get a list of all the tables in the CASUSER caslib */ action table.tableinfo result=r/caslib="casuser"; /* Using the result set, process every table in a specified caslib */ do i over r.tableinfo; /* Display detailed table information */ table.tabledetails result=tinfo / caslib="casuser" name=i.name; print tinfo; /* Display detailed column information */ table.columninfo result=cinfo / table={caslib="casuser" name=i.name}; print cinfo; /* Display 5 rows */ table.fetch / table={caslib="casuser" name=i.name} to=5; end; quit; Produces the following results: tinfo: Results from table.tableDetails Detail Information for CARS in Caslib CASUSER(SASJedi). Node Number of Blocks Active Blocks Rows Data size Variable Data size Blocks Mapped Memory Mapped Blocks Unmapped Memory Unmapped Blocks Allocated Memory Allocated Index Size Compressed Size Compression Ratio ALL 40 20 428 68480 0 20 72000 20 72000 0 0 0 0 0 cinfo: Results from table.columnInfo Column Information for CARS in Caslib CASUSER(SASJedi) Column Label Id Type Length Formatted Length Format Format Width Format Decimal Make 1 char 13 13 0 0 Model 2 char 40 40 0 0 Type 3 char 8 8 0 0 Origin 4 char 6 6 0 0 DriveTrain 5 char 5 5 0 0 MSRP 6 double 8 8 DOLLAR 8 0 Invoice 7 double 8 8 DOLLAR 8 0 EngineSize Engine Size (L) 8 double 8 12 0 0 Cylinders 9 double 8 12 0 0 Horsepower 10 double 8 12 0 0 MPG_City MPG (City) 11 double 8 12 0 0 MPG_Highway MPG (Highway) 12 double 8 12 0 0 Weight Weight (LBS) 13 double 8 12 0 0 Wheelbase Wheelbase (IN) 14 double 8 12 0 0 Length Length (IN) 15 double 8 12 0 0 Results from table.fetch Selected Rows from Table CARS _Index_ Make Model Type Origin DriveTrain MSRP Invoice Engine Size (L) Cylinders Horsepower MPG (City) MPG (Highway) Weight (LBS) Wheelbase (IN) Length (IN) 1 Acura MDX SUV Asia All $36,945 $33,337 3.5 6 265 17 23 4451 106 189 2 Audi RS 6 4dr Sports Europe Front $84,600 $76,417 4.2 8 450 15 22 4024 109 191 3 BMW 745Li 4dr Sedan Europe Rear $73,195 $66,830 4.4 8 325 18 26 4464 123 204 4 Cadillac Seville SLS 4dr Sedan USA Front $47,955 $43,841 4.6 8 275 18 26 3992 112 201 5 Chevrolet Astro Sedan USA All $26,395 $23,954 4.3 6 190 14 17 4605 111 190 tinfo: Results from table.tableDetails Detail Information for IRIS in Caslib CASUSER(SASJedi). Node Number of Blocks Active Blocks Rows Data size Variable Data size Blocks Mapped Memory Mapped Blocks Unmapped Memory Unmapped Blocks Allocated Memory Allocated Index Size Compressed Size Compression Ratio ALL 40 20 150 7200 0 20 10720 20 10720 0 0 0 0 0 cinfo: Results from table.columnInfo Column Information for IRIS in Caslib CASUSER(SASJedi) Column Label Id Type Length Formatted Length Format Width Format Decimal Species Iris Species 1 char 10 10 0 0 SepalLength Sepal Length (mm) 2 double 8 12 0 0 SepalWidth Sepal Width (mm) 3 double 8 12 0 0 PetalLength Petal Length (mm) 4 double 8 12 0 0 PetalWidth Petal Width (mm) 5 double 8 12 0 0 Results from table.fetch Selected Rows from Table IRIS _Index_ Iris Species Sepal Length (mm) Sepal Width (mm) Petal Length (mm) Petal Width (mm) 1 Setosa 50 33 14 2 2 Setosa 49 30 14 2 3 Setosa 51 35 14 3 4 Versicolor 61 28 40 13 5 Versicolor 58 27 39 12 You didn't specify how you wanted to save the tables - as files in the CASLIB (and what type - SASHDAT, CSV, etc) or as SAS data sets, so I have no sample code for that. But these same techniques should be able to be adapted for use with the table.save CAS action of the SAVERESULT statement to achieve your desired result. Hope this helps. May the SAS be with you!

SASJedi · ‎10-25-2020

Have a peek at Mark Steven's blog post "Six tips to prepare for SAS programming certifications". There are lots of good resources there. In addition to the free sample questions and practice exam, the SAS Certification Prep Guide has lots of quiz questions to test your understanding. The section quizzes in the free SAS Programming 1 e-learning course are another good source of practice questions. There are lots of quizzes available for free at SASensi too. May the SAS be with you in your certification quest!

SASJedi · ‎10-25-2020

What interface are you using to run the task? Enterprise Guide / SAS Studio / SAS Windowing Environment?

SASJedi · ‎10-22-2020

This issue is a result of reading in the INDEX variable from a SAS data set. Variables read from a SAS data set are not re-initialized automatically when the step reiterates. The code doesn't re-initialize the INDEX variable either, so once set to '100' by your program, the value persists in the PDV. Adding logic to set the value to missing will resolve the issue: data test; set test2 test1 ; if index(VISIT, 'Fir')^=0 then do; index='100'; end; else call missing(index); run; proc print data=test; run; Result: Obs index visit 1 100 First 2 Second May the SAS be with you! Mark

SASJedi · ‎10-21-2020

I would use PROC SQL, like this: data have; infile datalines; input year code:$3. industry:$1. Value; datalines; 2016 001 A 800 2017 001 A 900 2018 001 A 1700 2016 002 A 1200 2017 002 A 1500 2018 002 A 1100 2016 003 B 600 2017 003 B 1400 2018 003 B 950 2016 004 B 780 2017 004 B 1200 2018 004 B 3000 ; proc sql; create table want as select Year, Code, Industry, max(Value) as MaxValue from have group by Year, Code, Industry ; quit; Yields: Want year code industry MaxValue 2016 001 A 800 2016 002 A 1200 2016 003 B 600 2016 004 B 780 2017 001 A 900 2017 002 A 1500 2017 003 B 1400 2017 004 B 1200 2018 001 A 1700 2018 002 A 1100 2018 003 B 950 2018 004 B 3000 Hope this helps!

SASJedi · ‎10-21-2020

What SAS are you using for your studies? SAS On Demand for Academics, SAS University Edition, or SAS you have access to at work? And are you using SAS Studio, SAS Enterprise Guide, SAS Windowing Environment or some other method to write and submit your SAS code?

SASJedi · ‎10-21-2020

Moved into the Learn - Programming 1 & 2 forum for quicker response times

SASJedi · ‎10-19-2020

How about something like this: data r_mam; length cow flag 8 ; array sp_[5] $ 40; infile datalines4 delimiter=';' missover; input cow SP_1 SP_2 SP_3 SP_4 SP_5; do i= 1 to dim(SP_); SP_[i]=lowcase(SP_[i]); flag=max(flag,(find(SP_[i],'staphylococcus') and not find(SP_[i],'aureus'))); put sp_[i]= flag=; end; drop i; datalines4; 1;Streptoccous dysgalactiae;Klebsiella pneumoniae;Staphylococcus chromogenes 2;Staphylococcus aureus;Staphylococcus xylosus;Escherichia coli 3;Streptococcus uberis;Staphylococcus aureus ;;;; run; The result looks like this: Obs cow flag sp_1 sp_2 sp_3 sp_4 sp_5 1 1 1 streptoccous dysgalactiae klebsiella pneumoniae staphylococcus chromogenes 2 2 1 staphylococcus aureus staphylococcus xylosus escherichia coli 3 3 0 streptococcus uberis staphylococcus aureus

SASJedi · ‎10-19-2020

As far as I can determine, the fncprod column indicates where a function will run. B = runs in the SAS Compute server (base SAS) I = unique to IML X = runs in both the SAS Compute server (base SAS) and CAS

SASJedi · ‎10-19-2020

From the last SAS log you sent I can see you're using Enterprise Guide to write your SAS code. The "open code recursion" error most frequently occurs when a macro statement has previously been submitted without a semicolon. Try resetting your SAS session an submitting this code from a fresh SAS session: %macro month(sasdate); %qsysfunc(month(%superq(sasdate))) %mend; %macro year(sasdate); %qsysfunc(year(%superq(sasdate))) %mend; %let Auswertungstag = '01OCT2020'D; *Bei Bedarf: Datum vorgeben; %let Spanne=9; *Spanne: Anzahl der Monate des Dashboardszeitraum; *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; %let Monat= %eval(%month(&Auswertungstag.)); %let Jahr1= %eval(%year(&Auswertungstag.)); %let Jahr2= %eval(&Jahr1.-1); %put NOTE: &=Auswertungstag.; %put NOTE: &=Spanne. &=Monat. &=Jahr1. &=Jahr2.; %put NOTE: Subnmitted from &_CLIENTAPP version &_CLIENTVERSION; %put NOTE- Running on SAS version &sysvlong; This code runs without error or warnings for me from Enterprise Guide 8.2 running SAS 9.4M7. The last two lines should provide your Enterprise Guide and SAS version information, which might be helpful if further troubleshooting is necessary.

SASJedi · ‎10-13-2020

I moved this to the Statistical Procedures community, where it may get additional attention from folks more familiar with this topic.

SASJedi · ‎10-13-2020

fiscal_year (the result of your INTNX function call) is a SAS date value, not just a year value. You want fiscal_year as a character value representing the year, just like the character value you built for calendar_year. Try this instead: data test; format date mmddyy10. calendar_year fiscal_year best12. combine combine2 $20.; date='01jan2019'd; calendar_year= put(date,year4.); fiscal_year = put(intnx('YEAR.4',date,0),year4.); combine = cats(calendar_year,"check"); combine2 = cats(fiscal_year,"check"); output; date='01jun2019'd; calendar_year= put(date,year4.); fiscal_year = put(intnx('YEAR.4',date,0),year4.); combine = cats(calendar_year,"check"); combine2 = cats(fiscal_year,"check"); output; run; proc print; run; This is the result: Obs date calendar_year fiscal_year combine combine2 1 1/1/2019 2019 2018 2019check 2018check 2 6/1/2019 2019 2019 2019check 2019check

SASJedi · ‎10-13-2020

My pleasure! Stay SASy, my friend 🙂

Online Status	Offline
Date Last Visited	3 weeks ago