About sgtrun

sgtrun · ‎05-03-2018

No I already know about this link. I am looking for definitions of these fields. How a record gets created, what the fields mean, etc.This link simply gives the names of the fields in each of the tables.

sgtrun · ‎05-03-2018

I am using the Artifacts file for some reporting and I want to be sure I understand what each of these records mean. Specifically I am using the Artifactsusagedetails file and I want to understand what each of the columns mean. Can someone tell me if there is a data dictionary for this file.

sgtrun · ‎06-29-2017

<html> <body> In Excel I can use the Paste Special to read this this and convert it to Unicode and get rid of the HTML. Any way to do this in SAS? <div align="left" style="min-height: 9pt; ">Stover,Susan<TEST>, 6/21/2018 12:47:47 PM:  </div> <div align="left" style="min-height: 9pt; ">Can this be set to retest with recent or new records?  This issue was encountered while Susan was testing code</div> <div align="left" style="min-height: 9pt; "> ________________________________________ </div> </body> </html>

sgtrun · ‎06-21-2017

Works perfectly. Thank you so much.

sgtrun · ‎06-21-2017

I am trying to create a sequence number to be placed at the end of a file name for a proc export. Work.seq_nbr will contain the number I want to start with and then the datastep increment will increment that number by one and put a leading zero before it. If the seq_nbr starts off at say 270 then I want 0271 to be &seq_nbr_pad in my proc export. I just can't figure out how to make it a macro variable in my datastep or I need help in finding a way to do this. data increment(keep=seq_nbr_pad); length seq_nbr_txt $ 4 seq_nbr_pad $ 4; set work.seq_nbr; /* read charvar as number, then format with leading zeroes */ /* then put result into padded */ seq_nbr = seq_nbr+1; seq_nbr_txt = put(seq_nbr,4.); seq_nbr_pad = put(input(seq_nbr_txt,best4.),z4.); %let seq_nbr=seq_nbr_pad; run; PROC EXPORT DATA=increment OUTFILE="\\Home1\userid\GMF_&SEQ_NBR_PAD..csv" DBMS=CSV REPLACE; RUN;

sgtrun · ‎10-28-2016

Tom, Typically the results will show up in the results tab without having to do a proc print. I may have to call TS because a month ago the Results tab would show the results and now it shows up as a light blue screen but the log shows there were records generated. I am thinking it might be a setting I have changed that messed things up.

sgtrun · ‎10-28-2016

I have a simple query against the SASHELP.CARS table to pull all of the data (just using something simple to show what keeps happening). So when I run the query I get all of the records and I then want to create a stored procedure. I go through the steps and then the Results tab shows a blank screen. PROC SQL; CREATE TABLE WORK.FILTER_FOR_CARS AS SELECT t1.Make, t1.Model, t1.Type, t1.Origin, t1.DriveTrain, t1.MSRP, t1.Invoice, t1.EngineSize, t1.Cylinders, t1.Horsepower, t1.MPG_City, t1.MPG_Highway, t1.Weight, t1.Wheelbase, t1.Length FROM SASHELP.CARS t1; QUIT;

Online Status	Offline
Date Last Visited	‎06-04-2021 08:49 PM

Re: Artifacts file

Artifacts file

Convert HTML field to unicode

Re: Using a Macro Variable inside a proc export

Using a Macro Variable inside a proc export

Re: Output does not display when I run a simple stored procedure in EG...

Output does not display when I run a simple stored procedure in EG 5.1

Re: Output does not display when I run a simple stored procedure in EG...

Artifacts file

Re: Artifacts file

Artifacts file

Convert HTML field to unicode

Re: Using a Macro Variable inside a proc export

Using a Macro Variable inside a proc export

Re: Output does not display when I run a simple stored procedure in EG...

Output does not display when I run a simple stored procedure in EG 5.1

SAS Analytics Explorers