About yangx

yangx · ‎05-23-2023

Thanks for your reply, I have figured out where the problem is. Now proc import works as expected, the last two characters were truncated, so the variable name has 32 characters. Xiumei

yangx · ‎05-23-2023

Dear Support, When I import a csv file, which contains a variable name with length of 34 characters, since SAS variable name can only have 32 characters, what I expected is the last 2 characters will be truncated, then the variable name in SAS dataset should be 32 characters long, however, after the import, the variable name contains 33 characters, which cause other problems, I cannot use the variable name in my program to assign this variable to another variable. Could you please advise how we should handle the problem? Thanks. xiumei

yangx · ‎03-01-2019

Thank you for your reply and explanation. I tried to use round function and it works. So based on your explanation, whenever decimal number is produced, we should use round function, otherwise, the result might be unexpected. yangx

yangx · ‎03-01-2019

Thanks for your reply, but "if 0<= c <=10 then group=1" is doing the same thing, doesn't work.

yangx · ‎02-28-2019

Dear Support, I have a very simple program which used a number to divide group, but the result is unexpected. I cannot find the reason for this. Could you please help me with this? Please see the program below: data t1; input id a b; cards; 1 56 50.4 2 25 22.5 3 55 49.4 ; run; data t2; set t1; c=((a-b)*100/a); group=0; if 0<=c=10 then group=1; if c>10 then group=0; run; For id 1 and 2, c has value of 10, so group should equal to 1, however, group has 0 and 1. Any help is appreciated. thanks. Xiumei

yangx · ‎10-22-2018

Hello, Thank you very much for your reply. Now I understand where the problem is. I tried to use round function when I assign the time value to another variable timev, then SAS can find where timev=29701. xiumei

yangx · ‎10-19-2018

To be more specific, not all of the values are not working, only some of time value are not working, such as '8:15:01', '9:20:48'. Don't know why some of values can be found, some of values don't equal to what you see in the dataset. thanks.

yangx · ‎10-19-2018

Thanks for your reply, but it doesn't work.

yangx · ‎10-19-2018

Dear Experts, I have a problem with time variables when I use "proc import" to import an excel file which contains time variables. Please see the attached excel file. My program is: PROC IMPORT OUT= work.Lab1 DATAFILE='test.xlsx' DBMS=xlsx REPLACE; getnames=yes; format Static_test_1 Static_test_2 time8.; run; data lab2; set lab1; timev=static_test_2;run; proc print data=lab2; where timev=29701; run; /*no output printed */ When I check variable timev, it does have a value of 29701, but proc print log shows there is no observation for this value. However the other values are okay. Please let me know where I did wrong. Thanks a lot! yangx

yangx · ‎08-31-2018

Thank you very much for your help!

yangx · ‎08-31-2018

Dear DBailey, Thank you so much for the solution. I tried your program, it worked! The first time to get data from sqlserver, don't know where to find the information. If possible, could you please let me know where I can find the related information? Kind regards, Xiumei

yangx · ‎08-31-2018

Hello, I would like to get all the sas dataset through a libname that is created by using odbc connection, but I cannot use proc sql to select the sas dataset, while the same statement if libname is work directory, it works. Please see the program below. libname mydblib odbc uid=unixtest pw=xxxxxx dsn=UATREP; data gdemog4; set mydblib.G_DEMOG_4; run; proc sql ; select memname into: memlist separated by " " from dictionary.tables where libname='WORK'; quit; /*the libname work is worked, macro variable &memlist has value of gdemog4*/ proc sql ; select memname into: sqlmeml separated by " " from dictionary.tables where libname='MYDBLIB'; quit; /*the libname MYDBLIB is not worked. the macro variable sqlmeml is not created */ Could you please help me with understanding why the libname MYDBLIB created by ODBC is not recognized in proc sql statement? thanks. xiumei

yangx · ‎04-12-2018

Hello, Thanks for your reply. Sorry I probably didn't describe clearly. The warning messages from "ods tagsets.ExcelXP" contain the variable lists that are not in the program, the other variables are "'title_footer_over_rides', 'system_footer_setup', etc. The error message from "ods html" is "Physical file doesn't exist". The program worked perfectly in SAS9.4M2. My file name doesn't contain a space. thanks

yangx · ‎04-12-2018

Dear Support, We've just upgraded from SAS94M2 to SAS94M5. All of our existing programs with the "ODS html" and "ODS tagsets.ExcelXP" statements that worked in SAS94M2, cannot run in the Program Editor. The error messages like "Physical file does not exist,Physical file does not exist, /var/tmp/SAS_workCBC30001463E_ristatp6.dbri.local//studies/TIPS3/reports/output/compliance/2018Apr/Compliance_bycentre_2018Apr12 .xls.ERROR: No body file. HTML output will not be created. ". While "var/tmp/SAS_workCBC30001463E_ristatp6.dbri.local" is not in the program. SAS added this to the path. The ods tagsets.ExcelXP got the warning message "'putvars' was compiled using a different version of SAS. This might result in unexpected behavior", as a result, the output file is not created. Could you please explain what the reason for the problem and how to solve this? Thanks. Kind regards, xiumei

yangx · ‎11-24-2017

Hello, I am fairly new to SAS VA, I tried to export a report by using Distribute Reprots->New Report Job->Add Recipients, but there is no recipients listed in the window. Could you please let me know the reason why there is nothing displayed in the window? thanks. xiumei

Online Status	Offline
Date Last Visited	‎05-24-2023 05:56 PM

Re: var name length greater than 32 characters in CSV file

var name length greater than 32 characters in CSV file

Re: SAS decimal points unexpected result

Re: SAS decimal points unexpected result

SAS decimal points unexpected result

Re: Problems with time variable when SAS import data from Excel file

Re: Problems with time variable when SAS import data from Excel file

Re: Problems with time variable when SAS import data from Excel file

Problems with time variable when SAS import data from Excel file

Re: Proc SQL, odbc connection

Re: Proc SQL, odbc connection

Re: SAS 9.2 and SAS 9.4 create different variable names when import ex...

Custom Sorting with Proc SQL

Re: SAS Visual analytics: bubble colors for geography

Re: ods tagsets excelXP footnote problem

Re: var name length greater than 32 characters in CSV file

Re: Without missing statement why do numeric variables accept one char...

Re: var name length greater than 32 characters in CSV file

var name length greater than 32 characters in CSV file

Re: SAS decimal points unexpected result

Re: SAS decimal points unexpected result

SAS decimal points unexpected result

Re: Problems with time variable when SAS import data from Excel file

Re: Problems with time variable when SAS import data from Excel file

Re: Problems with time variable when SAS import data from Excel file

Problems with time variable when SAS import data from Excel file

Re: Proc SQL, odbc connection

Re: Proc SQL, odbc connection

Proc SQL, odbc connection

Re: Ods HTML, ODS Tagsets.ExcelXP problem

Ods HTML, ODS Tagsets.ExcelXP problem

No user list under Add Recipients window

SAS Analytics Explorers