About Lost_Gary

Lost_Gary · ‎10-28-2025

Ha - this is such a great observation. Now when I tell you that cobbling data in this format is for government reporting and following government specs, maybe you'll give me some slack.

Lost_Gary · ‎10-28-2025

I am trying to combine 3 sets of variables into a single group of variables and I am struggling to get my head around the most efficient way to do this. I currently have about 150 if then statements and I still can't get this to line up as I would like. Here is what i am after: Have Obs A1 A2 A3 A4 A5 B1 B2 B3 B4 B5 C1 C2 C3 C4 C5 1 1 2 3 44 22 2 1 3 2 22 4 4 2 22 23 5 5 1 6 4 Want Obs ABC1 ABC2 ABC3 ABC4 ABC5 1 1 2 3 44 22 2 1 3 2 22 4 4 2 22 23 5 5 1 6 4 Any thoughts are appreciated.

Lost_Gary · ‎08-18-2025

This is great. But naturally I've over simplified my example. My data would be more representative of: data work.have; input Alabama Arkansas Indiana; datalines; 100 200 250 200 100 275 300 900 100 250 25 120 50 8 65 400 700 200 ; run;

Lost_Gary · ‎08-18-2025

Is there a way to pull the variable column header based on the lowest value within a dataset? Such as: Have1 Have2 Have3 Want 100 200 250 Have1 200 100 275 Have2 300 900 100 Have3 250 25 120 Have2 50 8 65 Have2 400 700 200 Have3 I have a very large number of variable to compare. Thanks in advance.

Lost_Gary · ‎07-25-2025

Brilliantly Simple - Thank you.

Lost_Gary · ‎07-25-2025

Sorry - just 5 decimal places - one of my examples had too many. textfield get need -3.51400 -3.5140 -3.51400 -0.00001 -.00001 -.00001 3.05000 3.05000 3.05000 0.09000 0.09000 .09000 NA . NA -3.33100 -3.3310 -3.33100 -0.02900 -.02900 -.02900 -0.29000 -.29000 -.29000

Lost_Gary · ‎07-25-2025

I need to covert data to remove the leading zeros from a text field that has decimals. Here is what I have: data Have; infile datalines; format textfield $8000.; input textfield ; datalines; -3.51400 -0.00001 3.05000 0.09000 NA -3.33100 -0.02900 -0.29000 ;run; data notwhatiwant; set have; get = put(input(textfield,8.5),7.5); run; textfield get need -3.51400 -3.5140 -3.51400 -0.00001 -.00001 -.00001 3.05000 3.05000 3.05000 0.09000 0.09000 .09000 NA . NA -3.33100 -3.3310 -3.33100 -0.02900 -.02900 -.029000 -0.29000 -.29000 -.29000 I seem to be struggling with that 5th decimal place that I need when there is the negative and non-zero before the decimal. And those that are positive with a leading zero. Seems like this should be easy, but boy am i struggling. Any assistance is appreciated. Thanks.

Lost_Gary · ‎07-17-2025

As i suspected, i was hitting the API to quickly. Apparently, some have a rate limit that my macro was exceeding. I resolved my issue by slowing down my macro with the following code: Data _null_; call sleep(15,1); run;

Lost_Gary · ‎07-17-2025

I have an API that works just fine. However, when i attempt to call the API several times within a Macro, after about the 4th call of the API, I get a data error that the dataset is not found. I've put it in a do loop and then more simply put it in code such as this: %macro one(macvar); filename rsi "\\mypath.json"; proc http url="https://my API &macvar" out=rsi; run; libname rsi json "\\mypath.json"; %mend; %one(A); %one(B); %one(C); %one(D); when it gets to D, i receive an error that the data set 'Results_Values' does not exist. wondering if i am hitting the API to many times to fast with the macro. If I run D on it's own it will work just fine. Has anyone else experienced this and is there a known workaround? I am using SAS Enterprise Guide 8.3.

Lost_Gary · ‎04-28-2025

I have a data field 'TimeStamp' that I've imported via API that appears as 1.7454672E12. The information published states the field is ' Either a date with the format YYYY-MM-DD or a millisecond timestamp.' I'd appreciate any thoughts on a SAS format that can help me understand what this value is. Thanks.

Lost_Gary · ‎10-16-2024

Perfect - Thanks.

Lost_Gary · ‎10-16-2024

I am apparently not seeing something simple in this code. The below code returns a testdate of 1/1/60, but the log somehow is recognizing the macro variable correctly as 9/30/24. How do i get that macro variable date into my dataset? I think i've done this a million times but today it doesn't seem to be working for me. %let lastday = %sysfunc(intnx(month,%sysfunc(today()),-1,e),mmddyy10.); data test; set have; testdate = &lastday; format testdate mmddyy10.; run; log: 28 %let lastday = %sysfunc(intnx(month,%sysfunc(today()),-1,e),mmddyy10.); 29 30 data test; 31 set have; 32 testdate = &lastday; SYMBOLGEN: Macro variable LASTDAY resolves to 09/30/2024 33 format testdate mmddyy10.; 34 run;

Lost_Gary · ‎03-29-2024

the connection in the libname statement is set up through the Windows ODBC connection and path is set up in the ODBC utility. As long as there is the ODBC driver (and the SAS/Access to ODBC license), SAS can then connect using that libname statement . This would include MS Excel, MS Access, SQL and .csv & .txt sources. Your code is intriguing - where in the macro would i set my external path? As I tinker with it, I seem to be receiving a number of errors trying to figure that out.

Lost_Gary · ‎03-28-2024

Not sure my terminology was correct or if it matters, but these are comma delimited text files and the data does have quotations as the text qualifier. There is no database. It is simply a network folder full of these files that i am trying to read. My ODBC connection works for many of these files, which makes reading them simple and routine. However, a few of the large files give me the naming convention error. I can't seem to get proc import to work with this file format consistently because of the random commas (unless there is DSD function in Proc Import that I am unaware of). Again the infile is a challenge because the data files continue to shift (mostly adding files) and my infile statement is now over 3k lines for a singe file import. The validmemname option had no effect on the naming convention error. Unfortunately I cannot modify the data structure. Any other thoughts are appreciated.

Lost_Gary · ‎03-26-2024

I've tried to connect to a number of .csv files on a network folder and i can't seem to figure out the best way. There are probably 10-12 files each with a few hundred fields each. I've tried a proc import, but one of the data fields is a 'description' field that contains miscellaneous commas that skews the import fields and record count. I tried the infile statement with the DSD option - it works great, except they keep changing the data file and adding a record here and there, causing import errors. So, now I'm trying an ODBC connection. I like this - very clean in my code, except that I am getting a naming convention error because of the data: ERROR: This DBMS table or view cannot be accessed by the SAS System because it contains column names that are not unique when a SAS normalized (uppercased) compare is performed. See "Naming Conventions" in the SAS/ACCESS documentation. I've tried validvarname and preserve_col_names as options, but i am unable to read the data. I even tried dropping the culprit field but that didn't work and as I said the data keeps changing so there could be additional fields in the future causing this issue. Is there any hope for me? I'm using SAS EG 8.3. Here is my code: libname mylib odbc noprompt="myconneciton" schema=DBO Connection=global; options validvarname=v7; data test; set mylib.'crappycommadata.txt'n; run;

Online Status	Offline
Date Last Visited	‎10-28-2025 08:33 AM

Re: Combining Variables

Combining Variables

Re: Pulling Variable Header for Lowest Value

Pulling Variable Header for Lowest Value

Re: Removing leading zeros from a decimal that is a text field

Re: Removing leading zeros from a decimal that is a text field

Removing leading zeros from a decimal that is a text field

Re: API Macro Loop issues

API Macro Loop issues

timestamp

Re: Removing Multi-Line Breaks (ALT+ENTER) in Variables from Imported ...

Re: Using PROC IMPORT to read CSV file with long list of var names (>3...

Re: Pulling Variable Header for Lowest Value

Re: Counting observations by ID

Re: Bar Chart Axis Parameters and Color Scaling

Re: API Macro Loop issues

Re: Concatenate with Carriage Return and special formatting

Re: Combining Variables

Combining Variables

Re: Pulling Variable Header for Lowest Value

Pulling Variable Header for Lowest Value

Re: Removing leading zeros from a decimal that is a text field

Re: Removing leading zeros from a decimal that is a text field

Removing leading zeros from a decimal that is a text field

Re: API Macro Loop issues

API Macro Loop issues

timestamp

Re: Macro Variable Date

Macro Variable Date

Re: Trying to Connect to a folder with a number of .CSV Files

Re: Trying to Connect to a folder with a number of .CSV Files

Trying to Connect to a folder with a number of .CSV Files