topic sas stored process create new variable sas code in SAS Enterprise Guide

sas stored process create new variable sas code

Daily1 — Tue, 19 Apr 2022 10:48:02 GMT

sas stored process create new variable sas code

PROC SQL;
CREATE TABLE DATA1 AS
SELECT

t1.HEAD,put(input(t1.HEAD,best4.),z4.) as HEAD1

from data t1

quit;

ods markup file="//report/data.xls" tagset=tagsets.test alias='normal' style=mystyle;

proc report data=data;
run;

excel output not display and columns not display

Re: sas stored process create new variable sas code

andreas_lds — Tue, 19 Apr 2022 11:13:15 GMT

Read the log, or post it here so that we see what's happening actually.

Re: sas stored process create new variable sas code

Astounding — Tue, 19 Apr 2022 12:34:22 GMT

PROC REPORT is printing the wrong data set. The new variables are part of DATA1, not DATA.

Re: sas stored process create new variable sas code

Sajid01 — Tue, 19 Apr 2022 15:55:02 GMT

Hell @Daily1
If your intention is to create an excel file, why not use ods excel instead of ods markup?

I am giving an example code approximating your code. Try this and it should work.

data class;
set sashelp.class;
Age_c=put(age, 3.);
run;
PROC SQL;
CREATE TABLE DATA1  AS
SELECT
t1.Name, put(input(t1.Age_c,best4.),z4.) as HEAD1 
from class t1;
quit;
ods excel  file="/home/theprogmin/data.xlsx" ;
proc report data=data1;
run;
ods excel close;

If this does not work, do post the complete log as text - not as an image or screen shot.

Re: sas stored process create new variable sas code

Daily1 — Wed, 20 Apr 2022 05:08:57 GMT

HEAD1 column records are not leading zeros like 0086 not dispaly in excel download in stored process

Re: sas stored process create new variable sas code

Patrick — Wed, 20 Apr 2022 05:20:34 GMT

Use in below code the option to create and populate variable HEAD that fits your data the best.

It's just about applying the right format to the SAS variable so SAS can "tell" Excel how to represent the value.

data class;
  set sashelp.class;
  Age_c=put(age, 3.);
run;

PROC SQL;
  CREATE TABLE DATA1  AS
    SELECT
      t1.Name, 
      put(input(t1.Age_c,best4.),z4.) as HEAD1 format=$4.,
      input(t1.Age_c,best4.) as HEAD2 format=z4.,
      t1.age as HEAD3 format=z4.
    from class t1;
quit;

ods excel  file="c:\temp\data.xlsx";

proc report data=data1;
run;

ods excel close;

Re: sas stored process create new variable sas code

Daily1 — Wed, 20 Apr 2022 09:44:46 GMT

This code implement on sas code stored process manager but output this excel format is leading zero and new variable not display

Re: sas stored process create new variable sas code

Patrick — Wed, 20 Apr 2022 10:40:02 GMT

@Daily1

English is also not my native language but ... can you please re-formulate what you've trying to say because currently it's all gibberish to me.

Re: sas stored process create new variable sas code

Daily1 — Wed, 20 Apr 2022 11:10:52 GMT

First create Stored process this code after excel output not show

data class;
  set sashelp.class;
  Age_c=put(age, 3.);
run;

PROC SQL;
  CREATE TABLE DATA1  AS
    SELECT
      t1.Name, 
      put(input(t1.Age_c,best4.),z4.) as HEAD1 format=$4.,
      input(t1.Age_c,best4.) as HEAD2 format=z4.,
      t1.age as HEAD3 format=z4.
    from class t1;
quit;

ods excel  file="c:\temp\data.xlsx";

proc report data=data1;
run;

ods excel close;